SELECT frt.responsibility_name, fcpt.user_concurrent_program_name
FROM fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_responsibility fr,
fnd_responsibility_tl frt
WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcp.application_id = fcpt.application_id
AND fcp.concurrent_program_id = frgu.request_unit_id(+)
AND frgu.unit_application_id(+) = fcp.application_id
AND frgu.request_group_id = fr.request_group_id(+)
AND fr.responsibility_id = frt.responsibility_id(+)
AND fr.application_id = frt.application_id(+)
AND frgu.request_unit_type(+) = 'P'
AND frt.language(+) = 'US'
AND fcpt.language = 'US'
AND fcpt.user_concurrent_program_name LIKE '%Trial Balance All Entities Mapping Report%'
ORDER BY frt.responsibility_name
FROM fnd_concurrent_programs fcp,
fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_responsibility fr,
fnd_responsibility_tl frt
WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcp.application_id = fcpt.application_id
AND fcp.concurrent_program_id = frgu.request_unit_id(+)
AND frgu.unit_application_id(+) = fcp.application_id
AND frgu.request_group_id = fr.request_group_id(+)
AND fr.responsibility_id = frt.responsibility_id(+)
AND fr.application_id = frt.application_id(+)
AND frgu.request_unit_type(+) = 'P'
AND frt.language(+) = 'US'
AND fcpt.language = 'US'
AND fcpt.user_concurrent_program_name LIKE '%Trial Balance All Entities Mapping Report%'
ORDER BY frt.responsibility_name
Thank you for sharing wonderful information with us to get some idea about that content.
ReplyDeleteMulesoft Training
Mule Training