Wednesday, April 18, 2018

SQL Query to find Request Set for the given concurrent program

SQL Query to find  Request Set  for the given concurrent program :


SELECT
   DISTINCT  user_request_set_name
FROM
    fnd_request_sets_tl rs,
    fnd_request_set_programs rsp,
    fnd_concurrent_programs_tl cp
WHERE
    rsp.concurrent_program_id = cp.concurrent_program_id
    AND   rs.request_set_id = rsp.request_set_id
    AND   upper(user_concurrent_program_name) = upper(:enter_prog_name)
                       ;

1 comment: