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)
;
Your blogs stuff is purely enough for me personally.erp software dubai
ReplyDelete