Script to get Request Set details

SELECT RS.USER_REQUEST_SET_NAME "Request Set"
, RSS.DISPLAY_SEQUENCE SEQ
, CP.USER_CONCURRENT_PROGRAM_NAME "Concurrent Program"
, E.EXECUTABLE_NAME
, E.EXECUTION_FILE_NAME
, LV.MEANING FILE_TYPE
,FAT.APPLICATION_NAME "Application Name"
-- ,get_appl_name(e.application_id) "Application Name"
FROM APPS.FND_REQUEST_SETS_VL RS
, APPS.FND_REQ_SET_STAGES_FORM_V RSS
, APPLSYS.FND_REQUEST_SET_PROGRAMS RSP
, APPS.FND_CONCURRENT_PROGRAMS_VL CP
, APPS.FND_EXECUTABLES E
, APPS.FND_LOOKUP_VALUES LV
, APPS.FND_APPLICATION_TL FAT
WHERE 1=1
--and rs.application_id IN ( 20006 )
AND RS.APPLICATION_ID = RSS.SET_APPLICATION_ID
AND RS.REQUEST_SET_ID = RSS.REQUEST_SET_ID
AND RS.USER_REQUEST_SET_NAME = :P_REQUEST_SET_NAME
AND CP.USER_CONCURRENT_PROGRAM_NAME = :CONCURRENT_PROGRAM_NAME
AND E.APPLICATION_ID =FAT.APPLICATION_ID
AND RSS.SET_APPLICATION_ID = RSP.SET_APPLICATION_ID
AND RSS.REQUEST_SET_ID = RSP.REQUEST_SET_ID
AND RSS.REQUEST_SET_STAGE_ID = RSP.REQUEST_SET_STAGE_ID
AND RSP.PROGRAM_APPLICATION_ID = CP.APPLICATION_ID
AND RSP.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND CP.EXECUTABLE_ID = E.EXECUTABLE_ID
AND CP.EXECUTABLE_APPLICATION_ID = E.APPLICATION_ID
AND LV.LOOKUP_TYPE = 'CP_EXECUTION_METHOD_CODE'
AND LV.LOOKUP_CODE = E.EXECUTION_METHOD_CODE
AND LV.LANGUAGE='US'
AND FAT.LANGUAGE='US'
AND RS.END_DATE_ACTIVE IS NULL
ORDER BY 1,2

No comments:

Post a Comment