How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution f

How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution file name

SELECT fcp.concurrent_program_name,fcpt.user_concurrent_program_name,fcp.EXECUTION_METHOD_CODE,flv.meaning   
FROM FND_CONCURRENT_PROGRAMS fcp,FND_CONCURRENT_PROGRAMS_TL fcpt,fnd_lookup_values flv 
WHERE fcp.CONCURRENT_PROGRAM_ID = fcpt.CONCURRENT_PROGRAM_ID
AND flv.lookup_type = 'CP_EXECUTION_METHOD_CODE'   
AND fcp.EXECUTION_METHOD_CODE = flv.lookup_code 
AND fcpt.LANGUAGE = 'US'
AND flv.LANGUAGE = 'US'
AND fcp.application_id = 401 --Inventory Module 
ORDER BY fcpt.user_concurrent_program_name;

NOTE1:使用 SELECT * FROM fnd_application来查找模块的application_id

NOTE2: Concurrent Program TYPE(PL/SQL,Oracle Reports...)
SELECT lookup_code,meaning
FROM fnd_lookup_values
WHERE lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND LANGUAGE = 'US'
ORDER BY lookup_code;

Sample Output(Inventory Module)

CONCURRENT_PROGRAM_NAME	USER_CONCURRENT_PROGRAM_NAME	MEANING
INVTRREG	@Tax Preference Report	Oracle Reports
INVARAAS	ABC assignments report	Oracle Reports
INVARAAS_XML	ABC assignments report (XML)	Java Concurrent Program
INVARADV	ABC descending value report	Oracle Reports
INVARADV_XML	ABC descending value report (XML)	Java Concurrent Program
INVSRAAL	Account alias listing	Oracle Reports
INVSRAAL_XML	Account alias listing (XML)	Java Concurrent Program
INVUPMST	Activate Onhand Level Material Status Tracking	PL/SQL Stored Procedure
INVLOTAG	Age Update For Lot Attributes	PL/SQL Stored Procedure
INV3PLBILLINGUNITS	Calculate Billing Units	PL/SQL Stored Procedure
MRPATPRS	Calculate Resource Supply for ATP	PL/SQL Stored Procedure
INVCPCLOS	Close Period Control	PL/SQL Stored Procedure
INCAAC	Compile ABC analysis	Spawned
INCFIF	Compile item forecast	Spawned
INVCCIDP	Consigned Inventory Diagnostics	PL/SQL Stored Procedure
INV_CONSOLIDATE_ONHAND	Consolidate Inventory Onhand Quantites	PL/SQL Stored Procedure
INVISCOR	Copy Inventory Organization	Java Concurrent Program
INVISCORP	Copy Inventory Organization Interface Data Purge	PL/SQL Stored Procedure
INVCORPP	Copy Inventory Organization Report Data Purge	PL/SQL Stored Procedure
INVCGUGB	Costgroup upgrade for closed periods	PL/SQL Stored Procedure
INVCTXNM	Create Consumption Advice	PL/SQL Stored Procedure
INVCTXCW	Create Consumption Advice Worker	PL/SQL Stored Procedure
INV_CREATE_DEF_TXNS	Create Deferred Logical Transactions	PL/SQL Stored Procedure
INCIAP	Create Intercompany AP Invoices	Spawned
INCIAR	Create Intercompany AR Invoices	Spawned
INCIDV	Create item flexfield view	Spawned
INVIRCOC	Customer Item Commodity Codes Listing	Oracle Reports
INVIRCOC_XML	Customer Item Commodity Codes Listing (XML)	Java Concurrent Program
INVIRCXR	Customer Item Cross References Report	Oracle Reports
INVIRCXR_XML	Customer Item Cross References Report (XML)	Java Concurrent Program
INVIRCIT	Customer Items Report	Oracle Reports
INVIRCIT_XML	Customer Items Report (XML)	Java Concurrent Program
MTL_CCEOI_WORKER	Cycle Count Entries Open Interface Worker	PL/SQL Stored Procedure
INVARCTA	Cycle count entries and adjustments report	Oracle Reports
INVARCTA_XML	Cycle count entries and adjustments report (XML)	Java Concurrent Program
INVARHMA	Cycle count hit/miss analysis	Oracle Reports
INVARHMA_XML	Cycle count hit/miss analysis (XML)	Java Concurrent Program
INVARCLI	Cycle count listing	Oracle Reports
INVARCLI_XML	Cycle count listing (XML)	Java Concurrent Program
INVARORE	Cycle count open requests listing	Oracle Reports
INVARORE_XML	Cycle count open requests listing (XML)	Java Concurrent Program
INVARRTA	Cycle count schedule requests report	Oracle Reports
INVARRTA_XML	Cycle count schedule requests report (XML)	Java Concurrent Program
INVARUIR	Cycle count unscheduled items report	Oracle Reports
INVARUIR_XML	Cycle count unscheduled items report (XML)	Java Concurrent Program
INVARCPA	Cycle counts pending approval report	Oracle Reports
INVARCPA_XML	Cycle counts pending approval report (XML)	Java Concurrent Program
INCAAA	Define ABC assignments	Spawned
INCACS	Delete Concurrent Request	Spawned
BOMRDDELG	Delete Items Report GUI	Oracle Reports
BOMRDDELG_XML	Delete Items Report GUI (XML)	Java Concurrent Program
BOMRDDEL	Delete items report	Oracle Reports
BOMRDDEL_XML	Delete items report (XML)	Java Concurrent Program
INVTRELT	Expired lots report	Oracle Reports
INVTRELT_XML	Expired lots report (XML)	Java Concurrent Program
MTL_CCEOI_EXPORT	Export cycle count entries to open interface	PL/SQL Stored Procedure
INVPRFRL	Forecast rule listing	Oracle Reports
INVPRFRL_XML	Forecast rule listing (XML)	Java Concurrent Program
INCAPF	Freeze physical inventory	Spawned
INVSRFRT	Freight carrier listing	Oracle Reports
INVSRFRT_XML	Freight carrier listing (XML)	Java Concurrent Program
INVLTGEN	Genealogy Reports	PL/SQL Stored Procedure
INVKBCGN	Generate Kanban Cards	PL/SQL Stored Procedure
INVLOC	Generate Stock Locator Flexfield definition for Mobile Transactions	PL/SQL Stored Procedure
INCACS	Generate automatic schedule requests	Spawned
INCACG	Generate cycle count requests	Spawned
INCAPT	Generate physical inventory tags	Spawned
INVGTPG	Global Transaction Purge	PL/SQL Stored Procedure
INVGRACHG	Grade Change History Report	PL/SQL Stored Procedure
INVHVTPG	High Volume Transaction Purge	PL/SQL Stored Procedure
INVMBTRX	INV Transaction Worker	PL/SQL Stored Procedure
INXATP	INXATP	Immediate
INXDSD	INXDSD	Immediate
INXGRP	INXGRP	Immediate
INXTCW	INXTCW	Immediate
INXTPU	INXTPU	Immediate
INVCIINTX	Import Customer Item Cross References	PL/SQL Stored Procedure
INVCIINT	Import Customer Items	PL/SQL Stored Procedure
INCOIN	Import Items	PL/SQL Stored Procedure
MTL_CCEOI_IMPORT	Import cycle count entries from open interface	PL/SQL Stored Procedure
INVIRSLO	Inactive items report	Oracle Reports
INVIRSLO_XML	Inactive items report (XML)	Java Concurrent Program
INCACI	Initialize cycle count items	Spawned
INVSRIOS	Inter-organization shipping information listing	Oracle Reports
INVSRIOS_XML	Inter-organization shipping information listing (XML)	Java Concurrent Program
INVCHGPU	Inventory Charges and Product Usage Report	Oracle Reports
INVGIAUP	Inventory Item Update Processor	PL/SQL Stored Procedure
INVAOPR	Inventory Option Report -DISABLED	Oracle Reports
INVINPSR	Inventory Packing Slip	Oracle Reports
INVINPSR_XML	Inventory Packing Slip (XML)	Java Concurrent Program
INVGIPPR	Inventory Position Processor	PL/SQL Stored Procedure
INVGIPPG	Inventory Position Purge	PL/SQL Stored Procedure
INVGIPPA	Inventory Position Purge All	PL/SQL Stored Procedure
INCTCW	Inventory transaction worker	Immediate
INV_ITEM_CAT_GRP_ELE_OI	Item Catalog Group Element Open Interface	PL/SQL Stored Procedure
INV_ITEM_CAT_ASSIGN_OI	Item Category Assignment Open Interface	PL/SQL Stored Procedure
INVITEMORG_ASSIGN	Item Organization Assignment	PL/SQL Stored Procedure
INVIRCAT	Item categories report	Oracle Reports
INVIRCAT_XML	Item categories report (XML)	Java Concurrent Program
INVIRXRF	Item cross-references listing	Oracle Reports
INVIRXRF_XML	Item cross-references listing (XML)	Java Concurrent Program
INVIRITD	Item definition detail	Oracle Reports
INVIRITD_XML	Item definition detail (XML)	Java Concurrent Program
INVIRITS	Item definition summary	Oracle Reports
INVIRITS_XML	Item definition summary (XML)	Java Concurrent Program
INVPRFDH	Item demand history report	Oracle Reports
INVPRFDH_XML	Item demand history report (XML)	Java Concurrent Program
INVIRISQ	Item quantities summary	Oracle Reports
INVIRISQ_XML	Item quantities summary (XML)	Java Concurrent Program
INVIRRIT	Item relationships listing	Oracle Reports
INVIRRIT_XML	Item relationships listing (XML)	Java Concurrent Program
INVIRRCR	Item replenishment count report	Oracle Reports
INVIRRCR_XML	Item replenishment count report (XML)	Java Concurrent Program
INVDRRSV	Item reservations report	Oracle Reports
INVDRRSV_XML	Item reservations report (XML)	Java Concurrent Program
INVIRDIS	Item statuses report	Oracle Reports
INVIRDIS_XML	Item statuses report (XML)	Java Concurrent Program
INVIRTMP	Item template listing	Oracle Reports
INVIRTMP_XML	Item template listing (XML)	Java Concurrent Program
INVSRISA	Item-subinventory report	Oracle Reports
INVSRISA_XML	Item-subinventory report (XML)	Java Concurrent Program
INVIDSEP	Items Data Scripts Execution	PL/SQL Stored Procedure
INVSRLOC	Locator listing	Oracle Reports
INVSRLOC_XML	Locator listing (XML)	Java Concurrent Program
INVIRILC	Locator quantities report	Oracle Reports
INVIRILC_XML	Locator quantities report (XML)	Java Concurrent Program
INVLSDAT	Lot And Serial Date Notification	PL/SQL Stored Procedure
INVLOTINV	Lot Inventory Report	PL/SQL Stored Procedure
INVLOTMAS	Lot Master Report	PL/SQL Stored Procedure
INVTRLNT	Lot transaction register	Oracle Reports
INVTRLNT_XML	Lot transaction register (XML)	Java Concurrent Program
INVSHPRC	Material Shortage Check Processor	PL/SQL Stored Procedure
INVMSCHR	Material Status Change History Report	Oracle Reports
INVMSCHR_XML	Material Status Change History Report (XML)	Java Concurrent Program
INVMATSTA	Material Status Definition Report	PL/SQL Stored Procedure
INVMSWHU	Material Status Where-Used Report	Oracle Reports
INVMSWHU_XML	Material Status Where-Used Report (XML)	Java Concurrent Program
INVTRDST	Material account distribution detail	Oracle Reports
INVTRDST_XML	Material account distribution detail (XML)	Java Concurrent Program
INVTRACS	Material account distribution summary	Oracle Reports
INVTRACS_XML	Material account distribution summary (XML)	Java Concurrent Program
INCTCC	Material cost transaction processor	Spawned
INVISMMX	Min-max planning report	Oracle Reports
INVISMMX_XML	Min-max planning report (XML)	Java Concurrent Program
INVIRMMX	Min-max planning report - superceded	FlexRpt
INVTOPKL	Move Order Pick Slip	Oracle Reports
INVTOPKL_XML	Move Order Pick Slip (XML)	Java Concurrent Program
INVMOPG	Move Order Purge	PL/SQL Stored Procedure
INVGIDEP	Movement Statistics Data Export	PL/SQL Stored Procedure
INVMVTEX	Movement Statistics Exception Report	Oracle Reports
INVMVTEX_XML	Movement Statistics Exception Report (XML)	Java Concurrent Program
INVCMVT	Movement Statistics Processor	PL/SQL Stored Procedure
INVSTMVT	Movement Statistics Report	Oracle Reports
INVSTMVT_XML	Movement Statistics Report (XML)	Java Concurrent Program
INVCMVTST	Movement Statistics Reset Status	PL/SQL Stored Procedure
INVCPRG	Movement Statistics Transaction Purging	PL/SQL Stored Procedure
INVIRMOQ	Multiple organization item quantities summary	FlexRpt
INVCPOPEN	Open Period Control	PL/SQL Stored Procedure
INVORGES	Organization Hierarchy Exceptions Report	Oracle Reports
INVORGES_XML	Organization Hierarchy Exceptions Report (XML)	Java Concurrent Program
INVSROPT	Organization parameters listing	Oracle Reports
INVSROPT_XML	Organization parameters listing (XML)	Java Concurrent Program
INVRCWSR	PAR Replenishment Count Worksheet	Oracle Reports
INVRCWSR_XML	PAR Replenishment Count Worksheet (XML)	Java Concurrent Program
INCAPA	Perform physical inventory Adjustments	Spawned
INVTRCLS	Period close value summary	Oracle Reports
INVTRCLS_XML	Period close value summary (XML)	Java Concurrent Program
INVARPTP	Physical Inventory Tags	Oracle Reports
INVARPTP_XML	Physical Inventory Tags (XML)	Java Concurrent Program
INVARPIA	Physical inventory accuracy analysis	Oracle Reports
INVARPIA_XML	Physical inventory accuracy analysis (XML)	Java Concurrent Program
INVARPAR	Physical inventory adjustments report	Oracle Reports
INVARPAR_XML	Physical inventory adjustments report (XML)	Java Concurrent Program
INVARPSL	Physical inventory counts report	Oracle Reports
INVARPSL_XML	Physical inventory counts report (XML)	Java Concurrent Program
INVARPMT	Physical inventory missing tag listing	Oracle Reports
INVARPMT_XML	Physical inventory missing tag listing (XML)	Java Concurrent Program
INVARPTG	Physical inventory tag listing	Oracle Reports
INVARPTG_XML	Physical inventory tag listing (XML)	Java Concurrent Program
INVARPTS	Physical inventory trend and summary analysis	Oracle Reports
INVARPTS_XML	Physical inventory trend and summary analysis (XML)	Java Concurrent Program
INCTPK	Pick Release Server	Spawned
INVSRPLN	Planner listing	Oracle Reports
INVSRPLN_XML	Planner listing (XML)	Java Concurrent Program
INVCCIER	Print Cycle Count Entries Open Interface data	Oracle Reports
INVCCIER_XML	Print Cycle Count Entries Open Interface data (XML)	Java Concurrent Program
INVKBCPR	Print Kanban Cards	Oracle Reports
INVKBCPR_XML	Print Kanban Cards (XML)	Java Concurrent Program
INCDCM	Process demand interface	Immediate
INCRPR	Process replenishment counts	Spawned
INCTCM	Process transaction interface	Immediate
INV_EBI_PUBLISH_ECO	Publish Engineering Change Order Updates	Java Concurrent Program
INV_EBI_PUBLISH_ITEM_ATTR	Publish Item Attributes Updates	Java Concurrent Program
INV_EBI_PUBLISH_ITEM_BAL	Publish Item Balance Updates	Java Concurrent Program
INVPOPSR	Purchasing Packing Slip	Oracle Reports
INVPOPSR_XML	Purchasing Packing Slip (XML)	Java Concurrent Program
INCAAP	Purge ABC information	Spawned
MTL_CCEOI_PURGE	Purge cycle count entries open interface	PL/SQL Stored Procedure
INCACP	Purge cycle count information	Spawned
INCAPP	Purge physical inventory information	Spawned
INCRPG	Purge replenishment counts	Spawned
INCTPG	Purge transaction history	Spawned
INCDSS	Reload safety stocks	Spawned
INVIRROP	Reorder point planning report	FlexRpt
INVGCORP	Report - Copy Inventory Organization	Oracle Reports
INVIOICRE	Request Set IOI CREATE Parallel Processing	PL/SQL Stored Procedure
INVIOIUPD	Request Set IOI UPDATE Parallel Processing	PL/SQL Stored Procedure
IOICREATE5	Request Set Stage IOICREATE5 - Request Set IOI CREATE Parallel Processing	PL/SQL Stored Procedure
IOIUPDATE5	Request Set Stage IOIUPDATE5 - Request Set IOI UPDATE Parallel Processing	PL/SQL Stored Procedure
INVRSVIN	Reservations Interface Manager	PL/SQL Stored Procedure
INV_RSV_UPGRADE	Reservations Upgrade Program	SQL*Plus
INCTSN_SRS	Serial Generation	PL/SQL Stored Procedure
INVIRSNO	Serial number detail	Oracle Reports
INVIRSNO_XML	Serial number detail (XML)	Java Concurrent Program
SERIAL_NUMBER_GENERATION	Serial number generation	PL/SQL Stored Procedure
INVTRSNT	Serial number transaction register	Oracle Reports
INVTRSNT_XML	Serial number transaction register (XML)	Java Concurrent Program
INVSRSHM	Ship Method Report	FlexRpt
INVSRSPT	Shortage Parameter report	Oracle Reports
INVSRSPT_XML	Shortage Parameter report (XML)	Java Concurrent Program
INVTRSHS	Shortages Summary report	Oracle Reports
INVTRSHS_XML	Shortages Summary report (XML)	Java Concurrent Program
INVIRDST	Status attributes listing	Oracle Reports
INVIRDST_XML	Status attributes listing (XML)	Java Concurrent Program
INVSRSUB	Subinventory listing	Oracle Reports
INVSRSUB_XML	Subinventory listing (XML)	Java Concurrent Program
INVIRSIQ	Subinventory quantities report	Oracle Reports
INVIRSIQ_XML	Subinventory quantities report (XML)	Java Concurrent Program
INVTURNS	Summarize Balances	PL/SQL Stored Procedure
INVTURNITMS	Summarize Balances at Item Level for Open Periods	PL/SQL Stored Procedure
INCFDH	Summarize demand histories	Spawned
INVTMLPR	Transaction Purge	PL/SQL Stored Procedure
INVTPGWB	Transaction Purge Worker	PL/SQL Stored Procedure
INVCCTCA	Transaction by CC and Account	Oracle Reports
INVTRHAN	Transaction historical summary	Oracle Reports
INVTRHAN_XML	Transaction historical summary (XML)	Java Concurrent Program
INVTRREG	Transaction register	Oracle Reports
INVTRREG_XML	Transaction register (XML)	Java Concurrent Program
INVTRSTS	Transaction source type summary	Oracle Reports
INVTRSTS_XML	Transaction source type summary (XML)	Java Concurrent Program
INVSRUOM	Unit of measure listing	Oracle Reports
INVSRUOM_XML	Unit of measure listing (XML)	Java Concurrent Program
INCIPS	Update item statuses with pending statuses	PL/SQL Stored Procedure
INCAPF	Upgrade Depreciation Detail	Spawned
INCTPG	Upgrade Encumbrance balances	Spawned
INVLSUPG	Upgrade Lot and Serial Attributes	PL/SQL Stored Procedure
INVONHSP	VMI Onhand by Supplier	Oracle Reports
INCRVL	Validate replenishment interface	Spawned
INVTRVLT	Vendor lot trace report	Oracle Reports
INVTRVLT_XML	Vendor lot trace report (XML)	Java Concurrent Program
INVMRMQT	View Multiple Organization Quantity Report	Oracle Reports
INVM2MQT	View Multiple Organization Quantity Report (180 col format)	Oracle Reports
INVMOQD	Warehouse Inventory (Onhand) Report Message	PL/SQL Stored Procedure
INVADJST	Warehouse Inventory Adjustment Advice	PL/SQL Stored Procedure
AZAPITESTER	iSetup API testing concurrent program	Java Concurrent Program

相关文章：How to use script to get all Oracle EBS Form name and corresponding fmb file name

===EOF===