SELECT
frg.request_group_name,
frg.description,
cp.concurrent_program_id,
cp.concurrent_program_name,
cpt.user_concurrent_program_name,
frv.responsibility_name
FROM
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt,
fnd_responsibility_vl frv
WHERE
frg.request_group_id = frgu.request_group_id
AND frgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND frv.request_group_id = frg.request_group_id(+)
AND frg.request_group_name LIKE 'All Reports'
AND frg.description = 'All Purchasing SRS Reports'
AND cpt.user_concurrent_program_name LIKE 'Account Analysis Report%'
frg.request_group_name,
frg.description,
cp.concurrent_program_id,
cp.concurrent_program_name,
cpt.user_concurrent_program_name,
frv.responsibility_name
FROM
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt,
fnd_responsibility_vl frv
WHERE
frg.request_group_id = frgu.request_group_id
AND frgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND frv.request_group_id = frg.request_group_id(+)
AND frg.request_group_name LIKE 'All Reports'
AND frg.description = 'All Purchasing SRS Reports'
AND cpt.user_concurrent_program_name LIKE 'Account Analysis Report%'
No comments:
Post a Comment