Oracle Apps

Query to find concurrent requests’ status for a given request id.

select fcr.request_id
,decode(fcr.phase_code,’P',decode(fcr.hold_flag,’Y',’Inactive’,fl_p.meaning),fl_p.meaning) phase
,decode(fcr.phase_code,’P',decode(fcr.hold_flag,’Y',’On Hold’,decode(sign(fcr.requested_start_date - sysdate),1,’Scheduled’,fl_s.meaning)),fl_s.meaning) status
from fnd_concurrent_requests fcr
,fnd_lookups fl_p
,fnd_lookups fl_s
where 1=1
and fcr.phase_code = fl_p.lookup_code
and fl_p.lookup_type = ‘CP_PHASE_CODE’
and fcr.status_code = fl_s.lookup_code
and fl_s.lookup_type = ‘CP_STATUS_CODE’
and fcr.request_id = &request_id
order by fcr.request_id desc;