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

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===

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics