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

In Verilog, a non-net refers to a variable that is not a wire or a register, but rather a constant or a parameter. Concurrent assignment refers to the assignment of a value to a variable using the "=" operator in a module outside of any procedural blocks (such as always or initial blocks). A concurrent assignment to a non-net is not allowed in Verilog. This is because a non-net does not have a storage element and cannot hold a value assigned to it. Instead, it is typically used as a constant or a parameter that is available for use in the module. To assign a value to a non-net, it should be done within a procedural block using the appropriate assignment operator (such as "<=" for registers or "assign" for wires). Alternatively, the value can be passed as an argument to the module using the parameter keyword. For example: module my_module #(parameter WIDTH = 8) ( input clk, input [WIDTH-1:0] data_in, output [WIDTH-1:0] data_out ); // This is a non-net parameter parameter ADD_VALUE = 5; // This is a register that can be assigned using the "=" operator within an always block reg [WIDTH-1:0] register_data; always @(posedge clk) begin register_data <= data_in + ADD_VALUE; end // This is a wire that can be assigned using the "assign" keyword assign data_out = register_data; endmodule In this example, ADD_VALUE is a non-net parameter that is used in the always block to add a constant value to the input data. The register_data variable is assigned using the "=" operator within the always block. The data_out wire is assigned using the "assign" keyword.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值