Status code and Phase code of Concurrent requests (programs)
Abbreviation for status code and phase code means for Concurrent Requests in Oracle Apps
fnd_concurrent_requests table, status_code column
STATUS_CODE Column:
A Waiting
B Resuming
C Normal
D Cancelled
E Error
F Scheduled
G Warning
H On Hold
I Normal
M No Manager
Q Standby
R Normal
S Suspended
T Terminating
U Disabled
W Paused
X Terminated
Z Waiting
PHASE_CODE column
C Completed
I Inactive
P Pending
R Running
Thus a request in "Running" "Normal" state will have phase_code "R" and status_code"R"
