Monday, 22 February 2021

Concurrent Program assigned to Responsibility in oracle apps

SELECT  frt.responsibility_name, 

        frg.request_group_name,

       fcpt.user_concurrent_program_name

FROM fnd_Responsibility fr, 
     fnd_responsibility_tl frt,
     fnd_request_groups frg, 
     fnd_request_group_units frgu,
     fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
AND frt.LANGUAGE = USERENV('LANG')
AND fcpt.LANGUAGE = USERENV('LANG')
AND fcpt.user_concurrent_program_name = :conc_prg_name

No comments:

Post a Comment

In how many ways we can link the requisition to purchase order in oracle ebs

 In Oracle E-Business Suite (EBS) R12 / R12.2, a Purchase Requisition can be joined to a Purchase Order across 4 primary levels , depending ...