Concurrent Request Status Codes:
SELECT LOOKUP_CODE STATUS_CODE, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'CP_STATUS_CODE'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 0
ORDER BY LOOKUP_CODE;
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'CP_STATUS_CODE'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 0
ORDER BY LOOKUP_CODE;
STATUS_CODE | MEANING |
A | Waiting |
B | Resuming |
C | Normal |
D | Cancelled |
E | Error |
G | Warning |
H | On Hold |
I | Normal |
M | No Manager |
P | Scheduled |
Q | Standby |
R | Normal |
S | Suspended |
T | Terminating |
U | Disabled |
W | Paused |
X | Terminated |
Z | Waiting |
Concurrent Request Phase Codes:
SELECT LOOKUP_CODE PHASE_CODE, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'CP_PHASE_CODE'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 0
ORDER BY PHASE_CODE;
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'CP_PHASE_CODE'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 0
ORDER BY PHASE_CODE;
STATUS_CODE | MEANING |
C | Completed |
I | Inactive |
P | Pending |
R | Running |