EBS导出开发的并发可执行列表及近期请求详细信息

EBS导出开发的并发可执行列表及近期请求详细信息

SELECT T.USER_CONCURRENT_PROGRAM_NAME
FROM apps.FND_CONCURRENT_PROGRAMS_VL T
WHERE T.USER_CONCURRENT_PROGRAM_NAME LIKE ‘CUX%’
OR T.USER_CONCURRENT_PROGRAM_NAME LIKE ‘SCUX%’;

SELECT A.PROGRAM,count(a.PROGRAM) FROM Fnd_Conc_Req_Summary_v A WHERE A.REQUESTED_START_DATE >= TO_DATE(‘2021-10-01’,‘YYYY-MM-DD’);