/* Formatted on 9/11/2013 9:26:01 AM (QP5 v5.114.809.3010) */
SELECT A.REQUEST_ID,
B.USER_NAME,
C.USER_CONCURRENT_PROGRAM_NAME,
C.ARGUMENT_TEXT
FROM FND_CONCURRENT_REQUESTS A, FND_USER B, FND_CONC_REQ_SUMMARY_V C
WHERE B.USER_ID = A.REQUESTED_BY
AND A.REQUEST_ID = C.REQUEST_ID
AND A.REQUESTED_START_DATE > SYSDATE
AND A.HOLD_FLAG = 'N'
AND A.STATUS_CODE IN ('Q', 'I')
AND B.USER_NAME LIKE '%'
AND A.DESCRIPTION LIKE '%'
ORDER BY A.REQUEST_ID
SELECT A.REQUEST_ID,
B.USER_NAME,
C.USER_CONCURRENT_PROGRAM_NAME,
C.ARGUMENT_TEXT
FROM FND_CONCURRENT_REQUESTS A, FND_USER B, FND_CONC_REQ_SUMMARY_V C
WHERE B.USER_ID = A.REQUESTED_BY
AND A.REQUEST_ID = C.REQUEST_ID
AND A.REQUESTED_START_DATE > SYSDATE
AND A.HOLD_FLAG = 'N'
AND A.STATUS_CODE IN ('Q', 'I')
AND B.USER_NAME LIKE '%'
AND A.DESCRIPTION LIKE '%'
ORDER BY A.REQUEST_ID
No comments:
Post a Comment