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_IDAND 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_NAMEUSER_CONCURRENT_PROGRAM_NAMEMEANINGINVTRREG@Tax Preference ReportOracle ReportsINVARAASABC assignments reportOracle ReportsINVARAAS_XMLABC assignments report (XML)Java Concurrent ProgramINVARADVABC descending value reportOracle ReportsINVARADV_XMLABC descending value report (XML)Java Concurrent ProgramINVSRAALAccount alias listingOracle ReportsINVSRAAL_XMLAccount alias listing (XML)Java Concurrent ProgramINVUPMSTActivate Onhand Level Material Status TrackingPL/SQL Stored ProcedureINVLOTAGAge Update For Lot AttributesPL/SQL Stored ProcedureINV3PLBILLINGUNITSCalculate Billing UnitsPL/SQL Stored ProcedureMRPATPRSCalculate Resource Supply for ATPPL/SQL Stored ProcedureINVCPCLOSClose Period ControlPL/SQL Stored ProcedureINCAACCompile ABC analysisSpawnedINCFIFCompile item forecastSpawnedINVCCIDPConsigned Inventory DiagnosticsPL/SQL Stored ProcedureINV_CONSOLIDATE_ONHANDConsolidate Inventory Onhand QuantitesPL/SQL Stored ProcedureINVISCORCopy Inventory OrganizationJava Concurrent ProgramINVISCORPCopy Inventory Organization Interface Data PurgePL/SQL Stored ProcedureINVCORPPCopy Inventory Organization Report Data PurgePL/SQL Stored ProcedureINVCGUGBCostgroup upgrade for closed periodsPL/SQL Stored ProcedureINVCTXNMCreate Consumption AdvicePL/SQL Stored ProcedureINVCTXCWCreate Consumption Advice WorkerPL/SQL Stored ProcedureINV_CREATE_DEF_TXNSCreate Deferred Logical TransactionsPL/SQL Stored ProcedureINCIAPCreate Intercompany AP InvoicesSpawnedINCIARCreate Intercompany AR InvoicesSpawnedINCIDVCreate item flexfield viewSpawnedINVIRCOCCustomer Item Commodity Codes ListingOracle ReportsINVIRCOC_XMLCustomer Item Commodity Codes Listing (XML)Java Concurrent ProgramINVIRCXRCustomer Item Cross References ReportOracle ReportsINVIRCXR_XMLCustomer Item Cross References Report (XML)Java Concurrent ProgramINVIRCITCustomer Items ReportOracle ReportsINVIRCIT_XMLCustomer Items Report (XML)Java Concurrent ProgramMTL_CCEOI_WORKERCycle Count Entries Open Interface WorkerPL/SQL Stored ProcedureINVARCTACycle count entries and adjustments reportOracle ReportsINVARCTA_XMLCycle count entries and adjustments report (XML)Java Concurrent ProgramINVARHMACycle count hit/miss analysisOracle ReportsINVARHMA_XMLCycle count hit/miss analysis (XML)Java Concurrent ProgramINVARCLICycle count listingOracle ReportsINVARCLI_XMLCycle count listing (XML)Java Concurrent ProgramINVARORECycle count open requests listingOracle ReportsINVARORE_XMLCycle count open requests listing (XML)Java Concurrent ProgramINVARRTACycle count schedule requests reportOracle ReportsINVARRTA_XMLCycle count schedule requests report (XML)Java Concurrent ProgramINVARUIRCycle count unscheduled items reportOracle ReportsINVARUIR_XMLCycle count unscheduled items report (XML)Java Concurrent ProgramINVARCPACycle counts pending approval reportOracle ReportsINVARCPA_XMLCycle counts pending approval report (XML)Java Concurrent ProgramINCAAADefine ABC assignmentsSpawnedINCACSDelete Concurrent RequestSpawnedBOMRDDELGDelete Items Report GUIOracle ReportsBOMRDDELG_XMLDelete Items Report GUI (XML)Java Concurrent ProgramBOMRDDELDelete items reportOracle ReportsBOMRDDEL_XMLDelete items report (XML)Java Concurrent ProgramINVTRELTExpired lots reportOracle ReportsINVTRELT_XMLExpired lots report (XML)Java Concurrent ProgramMTL_CCEOI_EXPORTExport cycle count entries to open interfacePL/SQL Stored ProcedureINVPRFRLForecast rule listingOracle ReportsINVPRFRL_XMLForecast rule listing (XML)Java Concurrent ProgramINCAPFFreeze physical inventorySpawnedINVSRFRTFreight carrier listingOracle ReportsINVSRFRT_XMLFreight carrier listing (XML)Java Concurrent ProgramINVLTGENGenealogy ReportsPL/SQL Stored ProcedureINVKBCGNGenerate Kanban CardsPL/SQL Stored ProcedureINVLOCGenerate Stock Locator Flexfield definition for Mobile TransactionsPL/SQL Stored ProcedureINCACSGenerate automatic schedule requestsSpawnedINCACGGenerate cycle count requestsSpawnedINCAPTGenerate physical inventory tagsSpawnedINVGTPGGlobal Transaction PurgePL/SQL Stored ProcedureINVGRACHGGrade Change History ReportPL/SQL Stored ProcedureINVHVTPGHigh Volume Transaction PurgePL/SQL Stored ProcedureINVMBTRXINV Transaction WorkerPL/SQL Stored ProcedureINXATPINXATPImmediateINXDSDINXDSDImmediateINXGRPINXGRPImmediateINXTCWINXTCWImmediateINXTPUINXTPUImmediateINVCIINTXImport Customer Item Cross ReferencesPL/SQL Stored ProcedureINVCIINTImport Customer ItemsPL/SQL Stored ProcedureINCOINImport ItemsPL/SQL Stored ProcedureMTL_CCEOI_IMPORTImport cycle count entries from open interfacePL/SQL Stored ProcedureINVIRSLOInactive items reportOracle ReportsINVIRSLO_XMLInactive items report (XML)Java Concurrent ProgramINCACIInitialize cycle count itemsSpawnedINVSRIOSInter-organization shipping information listingOracle ReportsINVSRIOS_XMLInter-organization shipping information listing (XML)Java Concurrent ProgramINVCHGPUInventory Charges and Product Usage ReportOracle ReportsINVGIAUPInventory Item Update ProcessorPL/SQL Stored ProcedureINVAOPRInventory Option Report -DISABLEDOracle ReportsINVINPSRInventory Packing SlipOracle ReportsINVINPSR_XMLInventory Packing Slip (XML)Java Concurrent ProgramINVGIPPRInventory Position ProcessorPL/SQL Stored ProcedureINVGIPPGInventory Position PurgePL/SQL Stored ProcedureINVGIPPAInventory Position Purge AllPL/SQL Stored ProcedureINCTCWInventory transaction workerImmediateINV_ITEM_CAT_GRP_ELE_OIItem Catalog Group Element Open InterfacePL/SQL Stored ProcedureINV_ITEM_CAT_ASSIGN_OIItem Category Assignment Open InterfacePL/SQL Stored ProcedureINVITEMORG_ASSIGNItem Organization AssignmentPL/SQL Stored ProcedureINVIRCATItem categories reportOracle ReportsINVIRCAT_XMLItem categories report (XML)Java Concurrent ProgramINVIRXRFItem cross-references listingOracle ReportsINVIRXRF_XMLItem cross-references listing (XML)Java Concurrent ProgramINVIRITDItem definition detailOracle ReportsINVIRITD_XMLItem definition detail (XML)Java Concurrent ProgramINVIRITSItem definition summaryOracle ReportsINVIRITS_XMLItem definition summary (XML)Java Concurrent ProgramINVPRFDHItem demand history reportOracle ReportsINVPRFDH_XMLItem demand history report (XML)Java Concurrent ProgramINVIRISQItem quantities summaryOracle ReportsINVIRISQ_XMLItem quantities summary (XML)Java Concurrent ProgramINVIRRITItem relationships listingOracle ReportsINVIRRIT_XMLItem relationships listing (XML)Java Concurrent ProgramINVIRRCRItem replenishment count reportOracle ReportsINVIRRCR_XMLItem replenishment count report (XML)Java Concurrent ProgramINVDRRSVItem reservations reportOracle ReportsINVDRRSV_XMLItem reservations report (XML)Java Concurrent ProgramINVIRDISItem statuses reportOracle ReportsINVIRDIS_XMLItem statuses report (XML)Java Concurrent ProgramINVIRTMPItem template listingOracle ReportsINVIRTMP_XMLItem template listing (XML)Java Concurrent ProgramINVSRISAItem-subinventory reportOracle ReportsINVSRISA_XMLItem-subinventory report (XML)Java Concurrent ProgramINVIDSEPItems Data Scripts ExecutionPL/SQL Stored ProcedureINVSRLOCLocator listingOracle ReportsINVSRLOC_XMLLocator listing (XML)Java Concurrent ProgramINVIRILCLocator quantities reportOracle ReportsINVIRILC_XMLLocator quantities report (XML)Java Concurrent ProgramINVLSDATLot And Serial Date NotificationPL/SQL Stored ProcedureINVLOTINVLot Inventory ReportPL/SQL Stored ProcedureINVLOTMASLot Master ReportPL/SQL Stored ProcedureINVTRLNTLot transaction registerOracle ReportsINVTRLNT_XMLLot transaction register (XML)Java Concurrent ProgramINVSHPRCMaterial Shortage Check ProcessorPL/SQL Stored ProcedureINVMSCHRMaterial Status Change History ReportOracle ReportsINVMSCHR_XMLMaterial Status Change History Report (XML)Java Concurrent ProgramINVMATSTAMaterial Status Definition ReportPL/SQL Stored ProcedureINVMSWHUMaterial Status Where-Used ReportOracle ReportsINVMSWHU_XMLMaterial Status Where-Used Report (XML)Java Concurrent ProgramINVTRDSTMaterial account distribution detailOracle ReportsINVTRDST_XMLMaterial account distribution detail (XML)Java Concurrent ProgramINVTRACSMaterial account distribution summaryOracle ReportsINVTRACS_XMLMaterial account distribution summary (XML)Java Concurrent ProgramINCTCCMaterial cost transaction processorSpawnedINVISMMXMin-max planning reportOracle ReportsINVISMMX_XMLMin-max planning report (XML)Java Concurrent ProgramINVIRMMXMin-max planning report - supercededFlexRptINVTOPKLMove Order Pick SlipOracle ReportsINVTOPKL_XMLMove Order Pick Slip (XML)Java Concurrent ProgramINVMOPGMove Order PurgePL/SQL Stored ProcedureINVGIDEPMovement Statistics Data ExportPL/SQL Stored ProcedureINVMVTEXMovement Statistics Exception ReportOracle ReportsINVMVTEX_XMLMovement Statistics Exception Report (XML)Java Concurrent ProgramINVCMVTMovement Statistics ProcessorPL/SQL Stored ProcedureINVSTMVTMovement Statistics ReportOracle ReportsINVSTMVT_XMLMovement Statistics Report (XML)Java Concurrent ProgramINVCMVTSTMovement Statistics Reset StatusPL/SQL Stored ProcedureINVCPRGMovement Statistics Transaction PurgingPL/SQL Stored ProcedureINVIRMOQMultiple organization item quantities summaryFlexRptINVCPOPENOpen Period ControlPL/SQL Stored ProcedureINVORGESOrganization Hierarchy Exceptions ReportOracle ReportsINVORGES_XMLOrganization Hierarchy Exceptions Report (XML)Java Concurrent ProgramINVSROPTOrganization parameters listingOracle ReportsINVSROPT_XMLOrganization parameters listing (XML)Java Concurrent ProgramINVRCWSRPAR Replenishment Count WorksheetOracle ReportsINVRCWSR_XMLPAR Replenishment Count Worksheet (XML)Java Concurrent ProgramINCAPAPerform physical inventory AdjustmentsSpawnedINVTRCLSPeriod close value summaryOracle ReportsINVTRCLS_XMLPeriod close value summary (XML)Java Concurrent ProgramINVARPTPPhysical Inventory TagsOracle ReportsINVARPTP_XMLPhysical Inventory Tags (XML)Java Concurrent ProgramINVARPIAPhysical inventory accuracy analysisOracle ReportsINVARPIA_XMLPhysical inventory accuracy analysis (XML)Java Concurrent ProgramINVARPARPhysical inventory adjustments reportOracle ReportsINVARPAR_XMLPhysical inventory adjustments report (XML)Java Concurrent ProgramINVARPSLPhysical inventory counts reportOracle ReportsINVARPSL_XMLPhysical inventory counts report (XML)Java Concurrent ProgramINVARPMTPhysical inventory missing tag listingOracle ReportsINVARPMT_XMLPhysical inventory missing tag listing (XML)Java Concurrent ProgramINVARPTGPhysical inventory tag listingOracle ReportsINVARPTG_XMLPhysical inventory tag listing (XML)Java Concurrent ProgramINVARPTSPhysical inventory trend and summary analysisOracle ReportsINVARPTS_XMLPhysical inventory trend and summary analysis (XML)Java Concurrent ProgramINCTPKPick Release ServerSpawnedINVSRPLNPlanner listingOracle ReportsINVSRPLN_XMLPlanner listing (XML)Java Concurrent ProgramINVCCIERPrint Cycle Count Entries Open Interface dataOracle ReportsINVCCIER_XMLPrint Cycle Count Entries Open Interface data (XML)Java Concurrent ProgramINVKBCPRPrint Kanban CardsOracle ReportsINVKBCPR_XMLPrint Kanban Cards (XML)Java Concurrent ProgramINCDCMProcess demand interfaceImmediateINCRPRProcess replenishment countsSpawnedINCTCMProcess transaction interfaceImmediateINV_EBI_PUBLISH_ECOPublish Engineering Change Order UpdatesJava Concurrent ProgramINV_EBI_PUBLISH_ITEM_ATTRPublish Item Attributes UpdatesJava Concurrent ProgramINV_EBI_PUBLISH_ITEM_BALPublish Item Balance UpdatesJava Concurrent ProgramINVPOPSRPurchasing Packing SlipOracle ReportsINVPOPSR_XMLPurchasing Packing Slip (XML)Java Concurrent ProgramINCAAPPurge ABC informationSpawnedMTL_CCEOI_PURGEPurge cycle count entries open interfacePL/SQL Stored ProcedureINCACPPurge cycle count informationSpawnedINCAPPPurge physical inventory informationSpawnedINCRPGPurge replenishment countsSpawnedINCTPGPurge transaction historySpawnedINCDSSReload safety stocksSpawnedINVIRROPReorder point planning reportFlexRptINVGCORPReport - Copy Inventory OrganizationOracle ReportsINVIOICRERequest Set IOI CREATE Parallel ProcessingPL/SQL Stored ProcedureINVIOIUPDRequest Set IOI UPDATE Parallel ProcessingPL/SQL Stored ProcedureIOICREATE5Request Set Stage IOICREATE5 -  Request Set IOI CREATE Parallel ProcessingPL/SQL Stored ProcedureIOIUPDATE5Request Set Stage IOIUPDATE5 -  Request Set IOI UPDATE Parallel ProcessingPL/SQL Stored ProcedureINVRSVINReservations Interface ManagerPL/SQL Stored ProcedureINV_RSV_UPGRADEReservations Upgrade ProgramSQL*PlusINCTSN_SRSSerial GenerationPL/SQL Stored ProcedureINVIRSNOSerial number detailOracle ReportsINVIRSNO_XMLSerial number detail (XML)Java Concurrent ProgramSERIAL_NUMBER_GENERATIONSerial number generationPL/SQL Stored ProcedureINVTRSNTSerial number transaction registerOracle ReportsINVTRSNT_XMLSerial number transaction register (XML)Java Concurrent ProgramINVSRSHMShip Method ReportFlexRptINVSRSPTShortage Parameter reportOracle ReportsINVSRSPT_XMLShortage Parameter report (XML)Java Concurrent ProgramINVTRSHSShortages Summary reportOracle ReportsINVTRSHS_XMLShortages Summary report (XML)Java Concurrent ProgramINVIRDSTStatus attributes listingOracle ReportsINVIRDST_XMLStatus attributes listing (XML)Java Concurrent ProgramINVSRSUBSubinventory listingOracle ReportsINVSRSUB_XMLSubinventory listing (XML)Java Concurrent ProgramINVIRSIQSubinventory quantities reportOracle ReportsINVIRSIQ_XMLSubinventory quantities report (XML)Java Concurrent ProgramINVTURNSSummarize BalancesPL/SQL Stored ProcedureINVTURNITMSSummarize Balances at Item Level for Open PeriodsPL/SQL Stored ProcedureINCFDHSummarize demand historiesSpawnedINVTMLPRTransaction PurgePL/SQL Stored ProcedureINVTPGWBTransaction Purge WorkerPL/SQL Stored ProcedureINVCCTCATransaction by CC and AccountOracle ReportsINVTRHANTransaction historical summaryOracle ReportsINVTRHAN_XMLTransaction historical summary (XML)Java Concurrent ProgramINVTRREGTransaction registerOracle ReportsINVTRREG_XMLTransaction register (XML)Java Concurrent ProgramINVTRSTSTransaction source type summaryOracle ReportsINVTRSTS_XMLTransaction source type summary (XML)Java Concurrent ProgramINVSRUOMUnit of measure listingOracle ReportsINVSRUOM_XMLUnit of measure listing (XML)Java Concurrent ProgramINCIPSUpdate item statuses with pending statusesPL/SQL Stored ProcedureINCAPFUpgrade Depreciation DetailSpawnedINCTPGUpgrade Encumbrance balancesSpawnedINVLSUPGUpgrade Lot and Serial AttributesPL/SQL Stored ProcedureINVONHSPVMI Onhand by SupplierOracle ReportsINCRVLValidate replenishment interfaceSpawnedINVTRVLTVendor lot trace reportOracle ReportsINVTRVLT_XMLVendor lot trace report (XML)Java Concurrent ProgramINVMRMQTView Multiple  Organization  Quantity ReportOracle ReportsINVM2MQTView Multiple Organization Quantity Report (180 col format)Oracle ReportsINVMOQDWarehouse Inventory (Onhand) Report MessagePL/SQL Stored ProcedureINVADJSTWarehouse Inventory Adjustment AdvicePL/SQL Stored ProcedureAZAPITESTERiSetup API  testing concurrent programJava Concurrent Program

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

===EOF===