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 |
分享到:
相关推荐
并发程序的验证方法和基础.对于编写并行程序、并行程序测试、程序正确性验证等方面的同学值得一看
Chapter 6, Concurrent Collections will teach the readers to how to use some concurrent data structures provided by the Java language. These data structures must be used in concurrent programs to avoid...
My aim with this book was to write the book people will buy to understand how to write concurrent programs on the Windows and .NET platforms. This is clearly of increasing importance due to multi-core...
verification of sequential and concurrent programs-third extended edition,一本很实用的英文书
As parallel and distributed computing systems are now the norm, most applications are concurrent, be it for increasing the performance or for handling asynchronous events. So far, most developers ...
We introduce a method to dynamically construct highly concurrent linked lists on modern graphics processors. Once constructed, these data structures can be used to implement a host of algorithms ...
This book provides an introduction to writing concurrent programs with “threads”. A threads facility allows you to write programs with multiple simultaneous points of execution, synchronizing ...
then this book is for you., What You Will Learn, Design concurrent applications by converting a sequential algorithm into a concurrent oneDiscover how to avoid all the possible problems you can get ...
The language was C or C++, which I loved deeply; however, to my surprise I found that it was a herculean effort to maintain a legacy code base, written in C/C++ that was multithreaded. The shared ...
If you have a working knowledge of Haskell, this hands-on book shows you how to use the language’s many APIs and frameworks for writing both parallel and concurrent programs. You’ll learn how ...
An isolation level determines the degree to which data is isolated for use by one process and guarded against interference from other processes. Prior to SQL Server 7.0, REPEATABLE READ and ...
concurrent Synchronizer Framework,讲解整个并发框架的设计思路!
You can specify for how many concurrent threads these steps will be executed and which Oracle accounts should be used. The performance results can be viewed in real-time as text, bar chart, or line ...
并发系统的监督控制-Petri网方法 Chapter 1:Introduction Chapter 2: This chapter introduces the Petri nets ...in the process of abstracting concurrent hybrid systems to the DES setting of Chapter 9.
1.1You may use the SOFTWARE PRODUCT pursuant to the license grant above and subject to the following terms and the proprietary notices in the SOFTWARE PRODUCT or on the media upon which the SOFTWARE ...
This is because your operating system allows the concurrency of tasks, much like the Java platform which offers various classes to execute concurrent tasks inside a Java program. "Java 7 Concurrency ...
or a computer at which the SOFTWARE is used by more than one Developer. You may not network the SOFTWARE or any component part of it, where it is or may be used by more than one Developer unless you...
Inside the Oracle Concurrent Manager
or a computer at which the SOFTWARE is used by more than one Developer. You may not network the SOFTWARE or any component part of it, where it is or may be used by more than one Developer unless you...