The script to query all Concurrent Programs which used to Purge or Delete

来源：互联网发布：淘宝助理价格怎么弄编辑：程序博客网时间：2024/06/06 04:55

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 BWHERE A.APPLICATION_ID=B.APPLICATION_IDAND 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

APPLICATIONCONCURRENT PROGRAM NAMESHORT NAMEFNDPurge Signon Audit dataFNDSCPRGFNDPurge Obsolete SOA Monitor DataFNDSOA_PURGEFNDPurge Inactive SessionsFNDDLTMPFNDPurge Workflow Provisioning Runtime DataFNDWFPRVPRFNDPurge Web Service Audit DataOAMSOAPPURFNDPurge Obsolete ECX DataFNDECXPRFNDDelete Diagnostic StatisticsDELDIAGSTATFNDDelete Diagnostic LogsDELDIAGLOGFNDPurge FND_STATS History RecordsFNDPGHSTFNDPurge Concurrent Processing setup data for cloningFNDCPCLNFNDPurge Rule ExecutionsFNDDWPURGFNDPurge Logs and Closed System AlertsFNDLGPRGFNDPurge Obsolete Generic File Manager DataFNDGFMPRFNDPurge Obsolete Workflow Runtime DataFNDWFPRFNDPurge Concurrent Request and/or Manager DataFNDCPPURINVInventory Position PurgeINVGIPPGINVPurge cycle count entries open interfaceMTL_CCEOI_PURGEINVPurge transaction historyINCTPGINVPurge cycle count informationINCACPINVPurge replenishment countsINCRPGINVPurge physical inventory informationINCAPPINVDelete items reportBOMRDDELINVTransaction PurgeINVTMLPRINVDelete Items Report GUIBOMRDDELGINVDelete items report (XML)BOMRDDEL_XMLINVGlobal Transaction PurgeINVGTPGINVCopy Inventory Organization Interface Data PurgeINVISCORPINVMove Order PurgeINVMOPGINVHigh Volume Transaction PurgeINVHVTPGINVTransaction Purge WorkerINVTPGWBINVInventory Position Purge AllINVGIPPAINVDelete Items Report GUI (XML)BOMRDDELG_XMLINVCopy Inventory Organization Report Data PurgeINVCORPPINVPurge ABC informationINCAAPONTPurge Secured Payment Data - WorkerONTIBYCN_WKRONTPurge Retrobilling RequestsOERETPURONTPurge Advanced Item Search Session DataOEXADPRBONTQuote Purge SelectionGENPSETQTEWHEREONTPurge Order Management WorkflowOEXPWFONTPurge Imported Credit ExposureOEXCEPRGONTADS Purge Order TransactionsADS_TRANS_PURGEONTPurge Open Interface DataOEXOIPCPONTMessage PurgeOEMPRGONTCreate Purge SetGENPSETONTPurge Secured Payment DataONTIBYCN_MGRONTOrder PurgeORDPURONTOrder Purge SelectionGENPSETWHEREPOPurge Purchasing Open Interface Processed DataPOXPOIPRPOPurge System Saved RequisitionPOXSSPGWIPWIP PurgeWIPPURGEWIPWIP Purge (XML)WIPPURGE_XMLWMSPurge Labor TransactionsWMS_LMS_PURGE_TXNSWMSPurge WMS History TablesPURGE_WMSWMSPurge Labor Setup History RecordsWMS_LMS_PURGE_SETUP_HISTORY