Script Like:
SELECT SUBSTR(B.APPLICATION_SHORT_NAME,1,11) "APPLICATION", SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,50) "CONCURRENT PROGRAM NAME", SUBSTR(A.CONCURRENT_PROGRAM_NAME,1,35) "SHORT NAME" FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPS.FND_APPLICATION_VL B WHERE A.APPLICATION_ID=B.APPLICATION_ID AND A.ENABLED_FLAG='Y' AND (Upper(A.USER_CONCURRENT_PROGRAM_NAME) LIKE Upper('%purge%') OR Upper(A.USER_CONCURRENT_PROGRAM_NAME) LIKE Upper('%delete%')) ORDER BY B.APPLICATION_SHORT_NAME;
Output of Some Module
APPLICATION | CONCURRENT PROGRAM NAME | SHORT NAME |
---|---|---|
FND | Purge Signon Audit data | FNDSCPRG |
FND | Purge Obsolete SOA Monitor Data | FNDSOA_PURGE |
FND | Purge Inactive Sessions | FNDDLTMP |
FND | Purge Workflow Provisioning Runtime Data | FNDWFPRVPR |
FND | Purge Web Service Audit Data | OAMSOAPPUR |
FND | Purge Obsolete ECX Data | FNDECXPR |
FND | Delete Diagnostic Statistics | DELDIAGSTAT |
FND | Delete Diagnostic Logs | DELDIAGLOG |
FND | Purge FND_STATS History Records | FNDPGHST |
FND | Purge Concurrent Processing setup data for cloning | FNDCPCLN |
FND | Purge Rule Executions | FNDDWPURG |
FND | Purge Logs and Closed System Alerts | FNDLGPRG |
FND | Purge Obsolete Generic File Manager Data | FNDGFMPR |
FND | Purge Obsolete Workflow Runtime Data | FNDWFPR |
FND | Purge Concurrent Request and/or Manager Data | FNDCPPUR |
INV | Inventory Position Purge | INVGIPPG |
INV | Purge cycle count entries open interface | MTL_CCEOI_PURGE |
INV | Purge transaction history | INCTPG |
INV | Purge cycle count information | INCACP |
INV | Purge replenishment counts | INCRPG |
INV | Purge physical inventory information | INCAPP |
INV | Delete items report | BOMRDDEL |
INV | Transaction Purge | INVTMLPR |
INV | Delete Items Report GUI | BOMRDDELG |
INV | Delete items report (XML) | BOMRDDEL_XML |
INV | Global Transaction Purge | INVGTPG |
INV | Copy Inventory Organization Interface Data Purge | INVISCORP |
INV | Move Order Purge | INVMOPG |
INV | High Volume Transaction Purge | INVHVTPG |
INV | Transaction Purge Worker | INVTPGWB |
INV | Inventory Position Purge All | INVGIPPA |
INV | Delete Items Report GUI (XML) | BOMRDDELG_XML |
INV | Copy Inventory Organization Report Data Purge | INVCORPP |
INV | Purge ABC information | INCAAP |
ONT | Purge Secured Payment Data - Worker | ONTIBYCN_WKR |
ONT | Purge Retrobilling Requests | OERETPUR |
ONT | Purge Advanced Item Search Session Data | OEXADPRB |
ONT | Quote Purge Selection | GENPSETQTEWHERE |
ONT | Purge Order Management Workflow | OEXPWF |
ONT | Purge Imported Credit Exposure | OEXCEPRG |
ONT | ADS Purge Order Transactions | ADS_TRANS_PURGE |
ONT | Purge Open Interface Data | OEXOIPCP |
ONT | Message Purge | OEMPRG |
ONT | Create Purge Set | GENPSET |
ONT | Purge Secured Payment Data | ONTIBYCN_MGR |
ONT | Order Purge | ORDPUR |
ONT | Order Purge Selection | GENPSETWHERE |
PO | Purge Purchasing Open Interface Processed Data | POXPOIPR |
PO | Purge System Saved Requisition | POXSSPG |
WIP | WIP Purge | WIPPURGE |
WIP | WIP Purge (XML) | WIPPURGE_XML |
WMS | Purge Labor Transactions | WMS_LMS_PURGE_TXNS |
WMS | Purge WMS History Tables | PURGE_WMS |
WMS | Purge Labor Setup History Records | WMS_LMS_PURGE_SETUP_HISTORY |