Tuesday 5 March 2013

Query to findout Concurrent Program name from Request Set

SELECT frst.user_request_set_name request_set,
  frst.description description,
  frsst.user_stage_name stage_name,
  frsst.description stage_description
FROM apps.fnd_request_sets_tl frst,
  apps.fnd_request_set_stages_tl frsst
WHERE frst.application_id =frsst.set_application_id
AND frst.request_set_id   = frsst.request_set_id
AND user_request_set_name LIKE '%GEPS GL US Payroll Interface Request Set%';

No comments:

Post a Comment