SELECT DISTINCT
fa.APPLICATION_SHORT_NAME, --application（模組）
fat.APPLICATION_NAME,
fcp.CONCURRENT_PROGRAM_NAME, --program（應用程式）
fcpt.USER_CONCURRENT_PROGRAM_NAME,
fcpT.DESCRIPTION,
fcpt.LANGUAGE
FROM apps.fnd_application_tl fat,
apps.fnd_application fa,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_programs fcp,
apps.fnd_executables fe
WHERE fat.APPLICATION_ID = fa.APPLICATION_ID
AND fat.LANGUAGE = fcpt.LANGUAGE
AND fa.APPLICATION_ID = fcp.APPLICATION_ID
AND fcpt.CONCURRENT_PROGRAM_ID = fcp.CONCURRENT_PROGRAM_ID
AND fcp.executable_id = fe.executable_id
AND fcpt.USER_CONCURRENT_PROGRAM_NAME='HUB flow concurrent';
--報表名稱
SELECT
distinct user_concurrent_program_name,
responsibility_name,
request_date,
argument_text,
request_id,
phase_code,
status_code,
logfile_name,
outfile_name,
output_file_type,
hold_flag,
user_name
FROM
apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs_tl fcp,
apps.fnd_responsibility_tl fr,
apps.fnd_user fu
WHERE
fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id
and fcr.responsibility_id = fr.responsibility_id
and fcr.requested_by = fu.user_id
--and user_name = upper('HIMSINGH')
and user_concurrent_program_name in ('deliverry flow concurrent')
--and Phase_code='P'
ORDER BY REQUEST_DATE DESC;
--查看request執行狀況
SELECT /*+ rule */
rq.parent_request_id,
rq.request_id,
tl.user_concurrent_program_name,
rq.actual_start_date,
rq.actual_completion_date,
ROUND((rq.actual_completion_date - rq.actual_start_date) * 1440, 2) run_time_min
FROM apps.fnd_concurrent_programs_vl tl,
apps.fnd_concurrent_requests rq
WHERE tl.application_id = rq.program_application_id
AND tl.concurrent_program_id = rq.concurrent_program_id
AND rq.actual_start_date IS NOT NULL
AND rq.actual_completion_date IS NOT NULL
AND tl.user_concurrent_program_name = 'employee master data'
ORDER BY rq.actual_completion_date DESC;
