SELECT fcr.request_id
, fcr.parent_request_id parent_req_id
, fcr.hold_flag
, fcr.phase_code phase
, fcr.status_code status
, TRUNC( ( NVL( fcr.actual_completion_date, SYSDATE ) - fcr.actual_start_date ) * 24 * 60, 2 ) time_in_mins
, TRUNC( fcr.actual_start_date - fcr.requested_start_date, 2 ) kick_off_time
, fcr.requested_start_date req_start_date
, TO_CHAR( fcr.actual_start_date, 'DD-MON-YYYY HH:MI AM' ) start_date
, TO_CHAR( fcr.actual_completion_date, 'DD-MON-YYYY HH:MI AM' ) completion_date
, fcrs.completion_text
, fu.user_name
, fcpl.user_concurrent_program_name conc_program_name
, frl.responsibility_name
, fcp.concurrent_program_name conc_short_name
, fcp.executable_id
, fe.execution_method_code
, fe.execution_file_path
, fe.executable_name
, fe.execution_file_name
, fl.meaning execution_type
, fcr.argument_text
, fcr.printer
, fcp.concurrent_program_id
, fcr.outfile_name
, fcr.logfile_name
, fcr.has_sub_request
, fcr.resubmitted
, fcr.resubmit_interval
, fu.description
FROM apps.fnd_executables fe
, apps.fnd_concurrent_programs fcp
, apps.fnd_concurrent_programs_tl fcpl
, apps.fnd_concurrent_requests fcr
, apps.fnd_lookups fl
, apps.fnd_responsibility_tl frl
, apps.fnd_user fu
, apps.fnd_conc_req_summary_v fcrs
WHERE fe.executable_id = fcp.executable_id
AND fcp.execution_method_code = fe.execution_method_code
AND fcr.responsibility_application_id = frl.application_id
AND fcp.concurrent_program_id = fcr.concurrent_program_id
AND fcpl.concurrent_program_id = fcp.concurrent_program_id ----
AND frl.responsibility_id = fcr.responsibility_id
AND fu.user_id = fcr.requested_by
AND fl.lookup_code = fe.execution_method_code
AND fcrs.concurrent_program_id = fcr.concurrent_program_id
AND fcrs.request_id = fcr.request_id
AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fcpl.user_concurrent_program_name IN ('AR Reconciliation Report')
AND frl.language = 'US'
AND fcpl.language = 'US'
ORDER BY fcr.requested_start_date DESC, fcr.request_id DESC
No comments:
Post a Comment