Concurrent Program,Responsibility name and Requestor fetching details query

SELECT * FROM PER_ALL_PEOPLE_F

WHERE FULL_NAME LIKE '%SAN%'

SELECT * FROM FND_USER

WHERE EMPLOYEE_ID = 487

  SELECT REQUEST_ID,
         PHASE_CODE,
         STATUS_CODE,
         REQUEST_DATE,
         REQUESTED_BY,
         REQUESTOR,
         COMPLETION_TEXT,
         ARGUMENT_TEXT,
         PROGRAM,
         USER_CONCURRENT_PROGRAM_NAME,
         RESPONSIBILITY_NAME
    FROM FND_CONC_REQ_SUMMARY_V A, FND_RESPONSIBILITY_TL B
   WHERE     A.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
         AND A.USER_CONCURRENT_PROGRAM_NAME LIKE '%PDI%'
         AND REQUESTOR LIKE 'XX 1030%'
ORDER BY REQUEST_DATE DESC

Concurrent Program and attached Responsibility and Request Group Query

select * from fnd_concurrent_programs_tl
where user_concurrent_program_name like 'XXX%Sales%'

 'XXX GL Extract Report%'

SELECT frt.responsibility_name,
               frg.request_group_name,
               frg.description,
               fcpt.user_concurrent_program_name
  FROM fnd_request_groups frg
             ,fnd_request_group_units frgu
             ,fnd_concurrent_programs fcp
             ,fnd_concurrent_programs_tl fcpt
             ,fnd_responsibility_tl frt
             ,fnd_responsibility frs
 WHERE frgu.unit_application_id = fcp.application_id
 AND   frgu.request_unit_id = fcp.concurrent_program_id
 AND   frg.request_group_id = frgu.request_group_id
 AND   frg.application_id = frgu.application_id
 AND   fcpt.source_lang = USERENV('LANG')
 AND   fcp.application_id = fcpt.application_id
 AND   fcp.concurrent_program_id = fcpt.concurrent_program_id
 AND   frs.application_id = frt.application_id
 AND   frs.responsibility_id = frt.responsibility_id
 AND   frt.source_lang = USERENV('LANG')
 AND   frs.request_group_id = frg.request_group_id
 AND   frs.application_id = frg.application_id
-- AND   fcp.concurrent_program_name = <shortname>
 AND   (fcpt.user_concurrent_program_name)  like 'U%Credi%'
 --and frt.responsibility_name like '%Paper%'


 select * from fnd_concurrent_programs
 where CONCURRENT_PROGRAM_ID = 133344

 where concurrent_program_name = 'XXX GL Extract Report'

 select fcp.user_concurrent_program_name
,fcr.request_date
,fu.user_name
,fcr.actual_start_date
,fcr.actual_completion_date
,fcr.phase_code
,fcr.status_code
,fcr.argument1
,fcr.argument2
,fcr.argument3
from fnd_concurrent_programs_vl fcp
,fnd_concurrent_requests fcr
,fnd_user fu
where fcp.user_concurrent_program_name like 'U%Sales%'
and fcp.concurrent_program_id = fcr.concurrent_program_id
and fcr.requested_by = fu.user_id
order by fcr.actual_completion_date desc



SELECT * FROM ALL_OBJECTS
WHERE OBJECT_NAME = 'XXXX_GL_EXT_MUL_PERIOD_PROC'



select variable_name, value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;

Indian Localization Tax Summary Query of oracle Apps R12.2.5

Query:-

SELECT SUM(DECODE(jtc.TAX_TYPE,'Excise',jrpt.TAX_AMOUNT,0)) EXCISE_AMT
             ,SUM(DECODE(JTC.TAX_TYPE,'Other Excise',jrpt.TAX_AMOUNT,0)) EDU_CESS
             ,SUM(DECODE(JTC.TAX_TYPE,'Addl. Excise',jrpt.TAX_AMOUNT,0)) ADDL_EXCISE
             ,SUM(DECODE(JTC.TAX_TYPE,'SERVICE-EC',jrpt.TAX_AMOUNT,0)) EDU_CESS_SER_EC
             ,SUM(DECODE(JTC.TAX_TYPE,'CST',jrpt.TAX_AMOUNT,0)) CST
             ,SUM(DECODE(JTC.TAX_TYPE,'Freight',jrpt.TAX_AMOUNT,0)) FREIGHT
             ,(SUM(DECODE(JTC.TAX_TYPE,'Freight',jrpt.TAX_AMOUNT,0)))+ (SUM(DECODE(JTC.TAX_TYPE,'Insurance',jrpt.TAX_AMOUNT,0))) FREIGHT
             ,SUM(DECODE(JTC.TAX_NAME,'VAT 4 % On Purchase',jrpt.TAX_AMOUNT,0)) + SUM(DECODE(JTC.TAX_NAME,'VAT Addi. 1 % On Purchase',jrpt.TAX_AMOUNT,0)) LST
             ,SUM(DECODE(JTC.TAX_TYPE,'Service',jrpt.TAX_AMOUNT,0)) SERVICE
             ,SUM(DECODE(JTC.TAX_NAME,'ADHOC TOLL TAX',jrpt.TAX_AMOUNT,0)) AD_TOLL    
         ,SUUM(DECODE(JTC.TAX_NAME,'Less TOLL TAX',jrpt.TAX_AMOUNT,0)) LESS_TOLL  
--        into :cp_excise1,
--             :cp_edu_cess1,
--             :cp_addl_excise1,
--             :cp_edu_cess_Ser1,
--             :cp_cst1,
--             :cp_frt1,
--             :cp_lst1,
--             :cp_Service1,
--             :cp_ad_toll1,
--         :cp_less_toll1
        FROM  --ja_in_ap_tax_distributions jrpt,
                  JAI_AP_MATCH_INV_TAXES jrpt,
             --ja_in_tax_codes         jtc
             JAI_CMN_TAXES_ALL jtc
        where jrpt.tax_id  = jtc.tax_id
        and   jrpt.invoice_id = 413189 --:invoice_id2; --413261  --
       -- and   jrpt.po_distribution_id =787878 --:po_distribution_id1; -- 787879; --

       SELECT * FROM JAI_CMN_TAXES_ALL
       WHERE TAX_TYPE LIKE  '%VAT%'