How To Check Current Status Of Request

SELECT
r.request_id,

r.phase_code,

r.status_code,

r.request_date,

r.requested_start_date,

r.hold_flag,

r.parent_request_id,

r.last_update_date,

u1.user_name updated_by_name,

r.actual_start_date,

r.completion_text,

r.actual_completion_date,

u2.user_name requestor,

fa.application_name application_name,

cp.enabled_flag enabled,

r.controlling_manager,

DECODE (

r.description,

NULL, cp.user_concurrent_program_name,

r.description || ' (' || cp.user_concurrent_program_name || ')')

program_name,

queue_control_flag,

r.queue_method_code,

cp.run_alone_flag,

r.single_thread_flag,

r.request_limit,

r.cd_id

FROM
fnd_concurrent_requests r,

fnd_concurrent_programs_vl cp,

fnd_user u1,

fnd_user u2,

fnd_application_vl fa

WHERE
r.program_application_id = fa.application_id

AND r.program_application_id = cp.application_id(+)

AND r.concurrent_program_id = cp.concurrent_program_id(+)

AND r.last_updated_by = u1.user_id(+)

AND r.requested_by = u2.user_id(+);

------>> One More <<---------

SELECT
fcr.REQUEST_ID,

fu.user_name AS requested_by,

fcpt.user_concurrent_program_name,

fcr.request_date,

fcr.phase_code,

fcr.requested_start_date,

fcr.argument_text

FROM
fnd_concurrent_programs_tl fcpt,

fnd_concurrent_requests fcr,

fnd_user fu

WHERE
fcpt.concurrent_program_id = fcr.concurrent_program_id

AND fcr.requested_by = fu.user_id

AND TRUNC (fcr.request_date) = TRUNC (SYSDATE)

ORDER BY fcr.requested_start_date