`
xitong
  • 浏览: 6188791 次
文章分类
社区版块
存档分类
最新评论

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

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

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics