--SQL – List of Request Set Programs
SELECT USER_REQUEST_SET_NAME,
a.REQUEST_SET_ID,
Sequence,
b.CONCURRENT_PROGRAM_ID,
c.USER_CONCURRENT_PROGRAM_NAME
FROM FND_REQUEST_SETS_VL a,
FND_REQUEST_SET_PROGRAMS b,
FND_CONCURRENT_PROGRAMS_VL c
WHERE 1=1
--AND USER_REQUEST_SET_NAME LIKE '%RequestSetname%'
AND a.REQUEST_SET_ID = B.REQUEST_SET_ID
AND b.concurrent_program_id = c.concurrent_program_id
ORDER BY USER_REQUEST_SET_NAME,sequence ;
SELECT USER_REQUEST_SET_NAME,
a.REQUEST_SET_ID,
Sequence,
b.CONCURRENT_PROGRAM_ID,
c.USER_CONCURRENT_PROGRAM_NAME
FROM FND_REQUEST_SETS_VL a,
FND_REQUEST_SET_PROGRAMS b,
FND_CONCURRENT_PROGRAMS_VL c
WHERE 1=1
--AND USER_REQUEST_SET_NAME LIKE '%RequestSetname%'
AND a.REQUEST_SET_ID = B.REQUEST_SET_ID
AND b.concurrent_program_id = c.concurrent_program_id
ORDER BY USER_REQUEST_SET_NAME,sequence ;
No comments:
Post a Comment