查询EBS计划请求信息

SELECT fcr.request_id “请求ID”,
fcpv.user_concurrent_program_name “请求名称”,
fcpv.concurrent_program_name “请求简称”,
frv.responsibility_name “职责”,
fcr.argument_text “参数”,
fu.user_name “提交人”,
fcr.status_code “状态”, –状态 I:暂挂,已计划,无管理器,C:正常,G:警告,Q:正在等待,X:已终止,E:错误,D:已取消
fcr.phase_code “阶段”, –阶段 P:无效,待定 C:已完成,I:已计划
to_number(fcr.resubmit_interval) “重新运行间隔时间”,
fcr.resubmit_interval_unit_code “重新运行间隔时间单位”,
fcr.resubmit_interval_type_code “申请间隔时间”,
fcr.requested_start_date “计划起始日期”,
fcr.resubmit_end_date “计划终止日期”
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs_vl fcpv,
fnd_responsibility_vl frv,
fnd_user fu
WHERE fcr.concurrent_program_id = fcpv.concurrent_program_id
AND fcr.program_application_id = fcpv.application_id
AND frv.responsibility_id = fcr.responsibility_id
AND fu.user_id = fcr.requested_by
AND fcr.phase_code = ‘P’
AND fcr.status_code IN (‘I’,
‘Q’)
ORDER BY frv.responsibility_name,
fcpv.user_concurrent_program_name DESC;