SELECT DISTINCT frst.request_set_id,
frst.user_request_set_name request_set,
frst.description description,
frsst.request_set_stage_id,
frsst.user_stage_name stage_name,
frsst.description stage_description,
fcp.user_concurrent_program_name
FROM apps.fnd_request_sets_tl frst,
apps.fnd_request_set_stages_tl frsst,
apps.fnd_request_set_programs frsp,
apps.fnd_concurrent_programs_tl fcp
WHERE frst.application_id =frsst.set_application_id
AND frst.request_set_id = frsst.request_set_id
AND frst.request_set_id = frsp.request_set_id
AND frsst.request_set_stage_id = frsp.request_set_stage_id
AND frsp.concurrent_program_id = fcp.concurrent_program_id
AND frst.language =userenv('LANG')
AND fcp.language =userenv('LANG')
AND upper(frst.user_request_set_name) like '%'||upper('Request Set Name')||'%'
order by frst.user_request_set_name, frsst.request_set_stage_id;
No comments:
Post a Comment