EBS: 并发程序运行情况查询

EBS R12.1.3 并发程序运行情况查询  

-- FND-并发程序运行情况查询 
SELECT FA.APPLICATION_SHORT_NAME, 
       FCP.APPLICATION_ID,
       FCP.CONCURRENT_PROGRAM_ID,
       FCP.CONCURRENT_PROGRAM_NAME AS "简称",
       FCP.USER_CONCURRENT_PROGRAM_NAME AS "程序",
       FCP.DESCRIPTION AS "并发程序-说明",
       FCP.OUTPUT_FILE_TYPE AS "输出-格式",
       FCP.EXECUTABLE_ID,
       FE.EXECUTABLE_NAME  AS "可执行名称",
       decode(fe.execution_method_code,'P',
              'Oracle Reports',
              'I',
              'PL/SQL 存储过程',
              'L','SQL*Loader 程序',
              'H','主机',
              'E','Perl 并发程序',
              'Q','SQL*Plus',
              'A','派生',
              'B','请求集阶段函数',
              'M','多语言功能',
              'K','Java 并发程序',
              'J','Java 存储过程',
              'S','立即',
              fe.execution_method_code
       ) as "执行方法",
       FE.EXECUTION_FILE_NAME  AS "可执行程序文件",
       FCR.LOGFILE_NAME AS "日志文件",
       FCR.OUTFILE_NAME AS "输出文件",
       FCR.ARGUMENT_TEXT AS "参数列表",
       FCR.NUMBER_OF_ARGUMENTS AS "参数数量",
       FCR.RESPONSIBILITY_ID ,
       FR.RESPONSIBILITY_KEY ,
       FR.RESPONSIBILITY_NAME,
       FR.DESCRIPTION AS RESPONSIBILITY_DESC ,
       FU.USER_NAME ||'-'|| FU.DESCRIPTION AS "USER_NAME",
       FCR.REQUEST_ID AS "请求编号",
       DECODE(FCR.PHASE_CODE,'C','完成','P','Pending',FCR.PHASE_CODE) AS "PHASE",
       DECODE(FCR.STATUS_CODE,'C','Normal','Q','Scheduled', FCR.STATUS_CODE) AS "状态" ,
       FCR.REQUEST_DATE ,
       FCR.ACTUAL_START_DATE,
       FCR.ACTUAL_COMPLETION_DATE ,
       FCR.OUTPUT_FILE_TYPE,
       DECODE(FCR.ROOT_REQUEST_ID,NULL,'立即任务','定时任务') AS "TYPE" 
      -- , FCR.* 
  FROM 
       APPS.FND_CONCURRENT_PROGRAMS_VL FCP, -- 并发程序 
       APPS.FND_EXECUTABLES_VL fe ,  -- 并发执行程序
       APPLSYS.FND_CONCURRENT_REQUESTS  FCR, -- 118120
       APPS.FND_APPLICATION_VL FA ,
       APPS.FND_RESPONSIBILITY_VL FR ,
       APPS.FND_USER FU 
 WHERE 1=1 
 -- AND FCR.PROGRAM_APPLICATION_ID = 30006 
  AND  FE.APPLICATION_ID = FCP.APPLICATION_ID
  AND FE.EXECUTABLE_ID = FCP.EXECUTABLE_ID
  AND FCP.CONCURRENT_PROGRAM_ID  = FCR.CONCURRENT_PROGRAM_ID 
  AND FE.APPLICATION_ID = FA.APPLICATION_ID 
  AND FCR.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID 
  AND FCR.REQUESTED_BY = FU.USER_ID 
  AND FCR.REQUEST_DATE >= TO_DATE('2026-06-02','YYYY-MM-DD')
--  AND FCR.ACTUAL_START_DATE >= TO_DATE('2026-06-02','YYYY-MM-DD')
 -- AND FCR.REQUEST_ID = 38956244 -- 38952665