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

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

APPLICATIONCONCURRENT PROGRAM NAMESHORT NAME
FNDPurge Signon Audit dataFNDSCPRG
FNDPurge Obsolete SOA Monitor DataFNDSOA_PURGE
FNDPurge Inactive SessionsFNDDLTMP
FNDPurge Workflow Provisioning Runtime DataFNDWFPRVPR
FNDPurge Web Service Audit DataOAMSOAPPUR
FNDPurge Obsolete ECX DataFNDECXPR
FNDDelete Diagnostic StatisticsDELDIAGSTAT
FNDDelete Diagnostic LogsDELDIAGLOG
FNDPurge FND_STATS History RecordsFNDPGHST
FNDPurge Concurrent Processing setup data for cloningFNDCPCLN
FNDPurge Rule ExecutionsFNDDWPURG
FNDPurge Logs and Closed System AlertsFNDLGPRG
FNDPurge Obsolete Generic File Manager DataFNDGFMPR
FNDPurge Obsolete Workflow Runtime DataFNDWFPR
FNDPurge Concurrent Request and/or Manager DataFNDCPPUR
INVInventory Position PurgeINVGIPPG
INVPurge cycle count entries open interfaceMTL_CCEOI_PURGE
INVPurge transaction historyINCTPG
INVPurge cycle count informationINCACP
INVPurge replenishment countsINCRPG
INVPurge physical inventory informationINCAPP
INVDelete items reportBOMRDDEL
INVTransaction PurgeINVTMLPR
INVDelete Items Report GUIBOMRDDELG
INVDelete items report (XML)BOMRDDEL_XML
INVGlobal Transaction PurgeINVGTPG
INVCopy Inventory Organization Interface Data PurgeINVISCORP
INVMove Order PurgeINVMOPG
INVHigh Volume Transaction PurgeINVHVTPG
INVTransaction Purge WorkerINVTPGWB
INVInventory Position Purge AllINVGIPPA
INVDelete Items Report GUI (XML)BOMRDDELG_XML
INVCopy Inventory Organization Report Data PurgeINVCORPP
INVPurge ABC informationINCAAP
ONTPurge Secured Payment Data - WorkerONTIBYCN_WKR
ONTPurge Retrobilling RequestsOERETPUR
ONTPurge Advanced Item Search Session DataOEXADPRB
ONTQuote Purge SelectionGENPSETQTEWHERE
ONTPurge Order Management WorkflowOEXPWF
ONTPurge Imported Credit ExposureOEXCEPRG
ONTADS Purge Order TransactionsADS_TRANS_PURGE
ONTPurge Open Interface DataOEXOIPCP
ONTMessage PurgeOEMPRG
ONTCreate Purge SetGENPSET
ONTPurge Secured Payment DataONTIBYCN_MGR
ONTOrder PurgeORDPUR
ONTOrder Purge SelectionGENPSETWHERE
POPurge Purchasing Open Interface Processed DataPOXPOIPR
POPurge System Saved RequisitionPOXSSPG
WIPWIP PurgeWIPPURGE
WIPWIP Purge (XML)WIPPURGE_XML
WMSPurge Labor TransactionsWMS_LMS_PURGE_TXNS
WMSPurge WMS History TablesPURGE_WMS
WMSPurge Labor Setup History RecordsWMS_LMS_PURGE_SETUP_HISTORY

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值