- 浏览: 6157038 次
文章分类
最新评论
-
vb2005xu:
这样你跑一个1000试试,卡不死你
PHP实现斐波那契数列 -
ykbj117:
你们知道刘绍华么?就是北邮的一个教授,专门研究WebRTC的资 ...
WebRTC体系结构 -
huangbye:
其实这也没什么卵用!
thinkphp自定义标签,view直接标签连接数据 -
cofftech:
opencv源码:http://www.eyesourceco ...
opencv资料和文档 -
langke93:
wangzhengyi_nopass.key这个怎么生成没写
nginx搭建https服务器
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===
相关推荐
Oracle EBS开发文档(form, report), 写得很不错
Oracle EBS 操作手册
Integrating_EBS_with_Oracle_Internet_Directory_and_Oracle_Single_Sign-On Oracle EBS 单点登录 方案
Oracle EBS中文数据字典.pdf
此针对于oracle ebs的值集进行详细的讲解
该文档 主要介绍 AP模块 下面表字段的描述 以及表与表之间的关系 AP_INVOICES_ALL AP_PAYMENT_SCHEDULES_ALL AP_INVOICE_DISTRIBUTIONS_ALL AP_HOLDS_ALL AP_HOLD_CODES ...AP_EXPENSE_REPORT_PARAMS_ALL
win7 ORACLE ebs 需要的文件和具体设置步骤 详细
这是一份完整的Oracle ebs 项目制造模块培训文档,可以了解Oracle ebs 项目制造模块(PJM)的所有功能及流程。
ORACLE EBS R12 安装步骤详解,讲述ORACLE EBS R12的详细安装步骤,感觉不错,和大家一块分享
Oracle EBS 各模块详解 01采购培训 02库存培训 03销售培训 04应付培训 05总帐培训 06应收培训
ORACLE ebs 各个模块的表之间的关联关系,方便大家熟悉ebs系统的表结构
Oracle EBS Student guide -inventory module, teach you how to use it step by step.
Oracle EBS 采购请购单接口示例,亲测可用 个人网站 http://a66.site 公众号:LXFIMJ
主要内容是oracle EBS财务模块,就学习ERP挺好的材料,分为五个部分 Oracle EBS财务模块(一)基本功能 Oracle EBS财务模块(二)基本组成模块 Oracle EBS财务模块(三)总账功能 Oracle EBS财务模块(四)账套 ...
ORACLEEBS财务全模块操作手册中文版收集.pdf
oralce ebs report MD070文档模板
本文主要整理了Oracle EBS(11.5.0.10) 中常用的表结构以供开发维护查询。
Oracle EBS R12中的配置文件及中文说明
Oracle EBS中费用性采购的介绍
oracle ebs之http通用接口开发