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 |