SELECT frt.responsibility_name, frg.request_group_name,
fcp.concurrent_program_name, 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 LIKE '%XXDA_DA_NAME%'
--AND fcpt.user_concurrent_program_name LIKE '%XXDA Concurrent Program Name%'
-- Request Set
SELECT frt.responsibility_name, frg.request_group_name,
frgu.request_unit_type, frgu.request_unit_id,
fcpt.user_request_set_name
FROM apps.fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_request_sets_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.request_set_id = frgu.request_unit_id
AND frt.LANGUAGE = USERENV ('LANG')
AND fcpt.LANGUAGE = USERENV ('LANG')
AND fcpt.user_request_set_name LIKE 'XXTEST Request Set'
fcp.concurrent_program_name, 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 LIKE '%XXDA_DA_NAME%'
--AND fcpt.user_concurrent_program_name LIKE '%XXDA Concurrent Program Name%'
-- Request Set
SELECT frt.responsibility_name, frg.request_group_name,
frgu.request_unit_type, frgu.request_unit_id,
fcpt.user_request_set_name
FROM apps.fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_request_sets_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.request_set_id = frgu.request_unit_id
AND frt.LANGUAGE = USERENV ('LANG')
AND fcpt.LANGUAGE = USERENV ('LANG')
AND fcpt.user_request_set_name LIKE 'XXTEST Request Set'
No comments:
Post a Comment