KEMBAR78
Query To Check Concurrnet Program Run Details in r12 | PDF
Scribd
Upload
35 views1 page

Query To Check Concurrnet Program Run Details in r12

The document contains a SQL query that retrieves distinct records related to a specific concurrent program named 'ADP OC Backlog Data Population Program'. It selects various fields such as program name, request ID, start and completion dates, phase code, status, parameters, username, and elapsed time in minutes. The results are ordered by the completion date in descending order.

Uploaded by

Balu bala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
35 views1 page

Query To Check Concurrnet Program Run Details in r12

The document contains a SQL query that retrieves distinct records related to a specific concurrent program named 'ADP OC Backlog Data Population Program'. It selects various fields such as program name, request ID, start and completion dates, phase code, status, parameters, username, and elapsed time in minutes. The results are ordered by the completion date in descending order.

Uploaded by

Balu bala
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

SELECT DISTINCT

ft.user_concurrent_program_name "Conc Program Name",


fr.request_id "Request ID",
to_char(fr.actual_start_date, 'dd-MON-yy hh24:mi:ss') "Started at",
to_char(fr.actual_completion_date, 'dd-MON-yy hh24:mi:ss') "Completed at",
decode(fr.phase_code, 'C', 'Completed', 'I', 'Inactive',
'P', 'Pending', 'R', 'Running', 'NA') "Phasecode",
decode(fr.status_code, 'A', 'Waiting', 'B', 'Resuming',
'C', 'Normal', 'D', 'Cancelled', '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') "Status",
fr.argument_text "Parameters",
fu.user_name "Username",
round(((nvl(fv.actual_completion_date, sysdate) - fv.actual_start_date) * 24 *
60),
2) "ElapsedTime(Mins)"
FROM
apps.fnd_concurrent_requests fr,
apps.fnd_concurrent_programs fp,
apps.fnd_concurrent_programs_tl ft,
apps.fnd_user fu,
apps.fnd_conc_req_summary_v fv
WHERE
fr.concurrent_program_id = fp.concurrent_program_id
-- AND fr.actual_start_date >= ( sysdate - &number_of_days )
AND fr.program_application_id = fp.application_id
AND ft.concurrent_program_id = fr.concurrent_program_id
AND fr.requested_by = fu.user_id
AND fv.request_id = fr.request_id
AND ft.user_concurrent_program_name LIKE 'ADP OC Backlog Data Population
Program'
ORDER BY
to_char(fr.actual_completion_date, 'dd-MON-yy hh24:mi:ss') DESC;

You might also like