Concurrent program status

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_date > sysdate - 60/1440

order by fcr.request_id desc;