SELECT frt.responsibility_name, user_concurrent_program_name,
frg.request_group_name,
frg.description, fcp.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 = 'XX_CUS_CFORM'
AND fcpt.user_concurrent_program_name LIKE '%Delivery Challan With Excise Invoice%'
Tuesday, February 5, 2013
Query to find Concurrent Programs & Responsibility
Query to find the concurrent programs and responsibility.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment