Saturday, June 6, 2009

Status of a particular Request

The following query gives the required result—

Set pagesize 9999
set linesize 150
col USER_CONCURRENT_PROGRAM_NAME format a25
col p.concurrent_program_name format a50
col ACTSTARTDATE format a18
col actcompdate format a18
select r.request_id, t.user_concurrent_program_name,
p.concurrent_program_name,
TO_CHAR(r.actual_start_date, 'DD-MON-RR HH24:MI:SS')actstartdate,
TO_CHAR(r.actual_completion_date, 'DD-MON-RR HH24:MI:SS') actcompdate,
r.phase_code, r.status_code
from fnd_concurrent_programs_tl t, fnd_concurrent_programs p,
fnd_application_tl a, fnd_concurrent_requests r
where a.application_id = t.application_id
and t.concurrent_program_id = p.concurrent_program_id
and t.concurrent_program_id = r.concurrent_program_id
and t.language = 'US' and a.language = 'US'
and r.request_id =6429038

No comments:

Post a Comment