Status code and Phase code from fnd_concurrent_requests

 

STATUS_CODE Column:	PHASE_CODE column.
A Waiting	C Completed
B Resuming	I Inactive
C Normal	P Pending
D Cancelled	R Running
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.