Concurrent Requests status can either be found under Find Requests form or from the database table applsys.fnd_concurrent_requests. Request status is determined by 2 colums Status and Phase Code. Following are the different entries and their meaning for both the columns.
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
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