SELECT UNIQUE 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 fr.responsibility_id = frt.responsibility_id
AND fr.request_group_id = frg.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND fcpt.LANGUAGE = 'US'
AND frt.LANGUAGE = 'US'
AND fcpt.user_concurrent_program_name LIKE
''
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 fr.responsibility_id = frt.responsibility_id
AND fr.request_group_id = frg.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND fcpt.LANGUAGE = 'US'
AND frt.LANGUAGE = 'US'
AND fcpt.user_concurrent_program_name LIKE
''
No comments:
Post a Comment