View: FND_CONC_WAITING_REQUESTS

Product:	FND - Application Object Library
Description:	FND_CONC_WAITING_REQUESTS
Implementation/DBA Data:	APPS.FND_CONC_WAITING_REQUESTS

View Text

SELECT R1.REQUEST_ID REQID
, R2.REQUEST_ID WREQID
, R2.PROGRAM
, R2.USER_NAME
, FND_AMP_PRIVATE.GET_PHASE(R2.PHASE_CODE
, R2.STATUS_CODE
, R2.HOLD_FLAG
, R2.ENABLED_FLAG
, R2.REQUESTED_START_DATE
, R2.REQUEST_ID) PHASE
, FND_AMP_PRIVATE.GET_STATUS(R2.PHASE_CODE
, R2.STATUS_CODE
, R2.HOLD_FLAG
, R2.ENABLED_FLAG
, R2.REQUESTED_START_DATE
, R2.REQUEST_ID) STATUS
, R2.ARGUMENT_TEXT
, R2.PRIORITY
, FND_AMP_PRIVATE.WHY_WAIT(R1.REQUEST_ID
, R1.SINGLE_THREAD_FLAG
, R1.REQUEST_LIMIT
, R1.REQUESTED_BY
, R1.PROGRAM_APPLICATION_ID
, R1.CONCURRENT_PROGRAM_ID
, R1.STATUS_CODE
, R2.REQUEST_ID
, R2.SINGLE_THREAD_FLAG
, R2.REQUEST_LIMIT
, R2.REQUESTED_BY
, R2.RUN_ALONE_FLAG
, R2.PROGRAM_APPLICATION_ID
, R2.CONCURRENT_PROGRAM_ID
, R2.IS_SUB_REQUEST
, R2.PARENT_REQUEST_ID) WHY
FROM FND_CONCURRENT_REQUESTS R1
, FND_AMP_REQUESTS_V R2
WHERE (R2.STATUS_CODE BETWEEN 'I'
AND 'W')
AND R2.HOLD_FLAG = 'N'
AND R2.ENABLED_FLAG= 'Y'
AND ((R2.PRIORITY > R1.PRIORITY) OR (R2.PRIORITY = R1.PRIORITY
AND R2.REQUEST_ID < R1.REQUEST_ID))
AND ((R2.REQUESTED_START_DATE<= SYSDATE) OR (R2.REQUESTED_START_DATE <= R1.REQUESTED_START_DATE))
AND ((R2.RUN_ALONE_FLAG = 'Y'
AND R2.CD_ID = R1.CD_ID) OR R2.REQUEST_ID IN (SELECT REQUEST_ID
FROM FND_CONCURRENT_WORKER_REQUESTS
WHERE (QUEUE_APPLICATION_ID != 0 OR CONCURRENT_QUEUE_ID NOT IN (1
, 4))
AND RUNNING_PROCESSES > 0))
AND R2.QUEUE_METHOD_CODE = 'B'
AND ((R2.RUN_ALONE_FLAG = 'Y'
AND R2.CD_ID = R1.CD_ID) OR (R1.QUEUE_METHOD_CODE = 'B'
AND ((R1.SINGLE_THREAD_FLAG = 'Y'
AND R2.SINGLE_THREAD_FLAG = 'Y'
AND R1.REQUESTED_BY = R2.REQUESTED_BY) OR (R1.STATUS_CODE='W'
AND R2.IS_SUB_REQUEST = 'Y'
AND R2.PARENT_REQUEST_ID = R1.REQUEST_ID) OR (R1.REQUEST_LIMIT = 'Y'
AND R2.REQUEST_LIMIT='Y'
AND R1.REQUESTED_BY = R2.REQUESTED_BY) OR ((R2.PROGRAM_APPLICATION_ID
, R2.CONCURRENT_PROGRAM_ID) IN (SELECT RUNNING_APPLICATION_ID
, RUNNING_CONCURRENT_PROGRAM_ID
FROM FND_CONCURRENT_PROGRAM_SERIAL
WHERE TO_RUN_APPLICATION_ID = R1.PROGRAM_APPLICATION_ID
AND TO_RUN_CONCURRENT_PROGRAM_ID = R1.CONCURRENT_PROGRAM_ID
AND (INCOMPATIBILITY_TYPE = 'G' OR R2.CD_ID = R1.CD_ID)))))) ORDER BY REQID
, WREQID

Columns