Monday 1 August 2022

Query to find out the concurrent program name from Request Set

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