现在的位置: 首页 > 综合 > 正文

How to use script to get all oracle EBS Form name and corresponding fmb file name

2013年07月10日 ⁄ 综合 ⁄ 共 10118字 ⁄ 字号 小 中 大 ⁄ 评论关闭

How to use script to get all Oracle EBS Form name and corresponding fmb file name

SELECT fff.function_name,
           ff.form_name,
           ffft.user_function_name,
           fff.function_id,
           ff.form_id,
           fff.application_id
FROM   fnd_form ff,
       fnd_form_functions fff,
       fnd_form_functions_tl ffft
WHERE  ff.form_id = fff.form_id
AND    fff.function_id = ffft.function_id
AND    ffft.language = 'US'
AND fff.application_id = 401   --Inventory Module
ORDER BY ffft.user_function_name;

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

Sample Output(Inventory Module)

FUNCTION_NAME FORM_NAME USER_FUNCTION_NAME FUNCTION_ID FORM_ID APPLICATION_ID
INV_INVADACA INVADACA ABC Assignment Updates 1167 53573 401
INV_INVADAAS INVADAAS ABC Assignments 1166 52853 401
INV_INVADACL INVADACL ABC Classes 1168 52835 401
INV_INVAAACP ARXPRGLP ABC Compiles 1165 20813 401
INV_INVAAACP INVAAACP ABC Compiles 1165 20813 401
INV_INVADAGR INVADAGR ABC Groups 1169 53675 401
INV_INVSDFAA INVSDFAA Account Aliases 1254 22098 401
INVACODE_F INVACODE Action Codes 1032535 60103 401
EAM_INVIDITM INVIDITM Asset Group/Asset Activity 1011578 20422 401
INV_CARRIER_ACCTS INVSDFCR Assign Carrier Distribution Accounts 1011698 53648 401
INV_INVIDCTL INVIDCTL Attribute Controls 1189 52848 401
INV_INVDDARL INVDDARL Available to Promise Rules 1183 52668 401
INV3PL_INVBLRUL_F INVBLRUL Billing Rules 1046831 60460 401
INV3PL_INVBLSRC_F INVBLSRC Billing Sources 1046830 60459 401
INV_INVTTMTX_BORROW_PAYBACK INVTTMTX Borrow Payback Transactions 1002820 52468 401
INV_INVIDICG INVIDICG Catalog Groups 1190 53627 401
ENG_INVIDICG INVIDICG Catalog Groups: Engineering 1467 53627 401
INV_INVSDCAS INVSDCAS Category Accounts 1253 54053 401
INV_INVIDCAT INVIDCAT Category Codes 1188 20463 401
INV_INVIDSCS INVIDSCS Category Sets 1194 52845 401
INV_INVDVATP POXPOEAC Check Available to Promise 1187 52665 401
INV_INVDVATP INVDVATP Check Available to Promise 1187 52665 401
INV_INVTTMTX_CONSXFER INVTTMTX Consigned Transactions 1014437 52468 401
INV_INVCNSUP INVCNSUP Consigned/VMI Consumption 1014641 59193 401
INV_INVGITMT INVGITMT Copy Item Attributes 1005950 57330 401
INV_INVTTGMP INVTTGPM Cost Periods 1286 54285 401
INV_INVTVTXN_COST_RESUBMISSION INVTVTXN Cost Transactions Resubmission 4389 52890 401
INV_INVIDXRT INVIDXRT Cross Reference Types 1241 20468 401
ENG_INVIDXRT INVIDXRT Cross References: Engineering 1466 20468 401
INV_INVSDICC INVSDICC Customer Item Commodity Codes 2234 54478 401
INV_INVICXRF INVICXRF Customer Item Cross References 2235 54479 401
INV_INVICITM INVICITM Customer Items 2227 54473 401
EGO_INVICITM_QUERY_ONLY INVICITM Customer Items Query Only 1026017 54473 401
INV_INVAMCAP INVAMCAP Cycle Count Adjustments 1177 53667 401
INV_INVATCEN INVATCEN Cycle Count Counts 1180 53652 401
INV_INVCCEOI INVCCEOI Cycle Count Entries in the Open Interface 5257 55941 401
INV_INVADCIT INVADCIT Cycle Count Items 1170 53628 401
INV_INVADCYC INVADCYC Cycle Counts 1172 53620 401
INV_INVISDST INVISDST Default Category Sets 1244 53665 401
CST_INVSDCAS INVSDCAS Define Category Accounts 3330 54053 401
INVCTDEF INVCTDEF Define Client Parameters 1047189 60475 401
INV_INVLSATT INVLSATT Define Desc Flex Context Mapping 1006909 58027 401
INV_INVMSDEF INVMSDEF Define Material Status 1006916 58033 401
INV_INVDVFDH INVDVFDH Demand History 1498 52843 401
INV_INVDVINT INVDVINT Demand Interface 1849 54395 401
INV_INVIDGRN INVIDGRN Edit Category People 1010442 58502 401
ENG_INVIVATT INVIVATT Engineering Item Attributes 1497 53610 401
INVPCKRL_F INVPCKRL Enhanced Inventory Picking Rule Setup 1032532 60101 401
INV_INVCCEXP INVCCEXP Export Cycle Count Entries 5258 55942 401
INV_INVADCYC_INVAMCAP_TXNHIS INVTVTXN Folder:Transaction History 1828 52890 401
INV_INVDDFRL INVDDFRL Forecast Rules 1184 53643 401
INVGENLT_F INVGENLT Generate Multiple Lots 1032496 60097 401
INVGRADE_F INVGRADE Grades 1032534 60102 401
INV_INVAMCAP_INVTVTXN INVTVTXN INV:Transaction History 1921 52890 401
INV_INVSDICR INVSDICR Intercompany Relations 1256 54166 401
INV_INVSICTF INVSICTF Intercompany Transaction Flows 1020872 59591 401
INV_INVTTMTX_INTERORG INVTTMTX Interorganization Transfer 1281 52468 401
INV_MGD_INVGIPBD INVGIPBD Inventory Position Build 1006595 57830 401
INV_MGD_INVGIPDP INVGIPDP Inventory Position Display 1006596 57831 401
INV_SHORTAGE_INQ INVSHINQ Inventory: View Potential Shortages Summary 1002822 55398 401
INV_INVISDRI INVISDRI Item Relationships 1243 53629 401
ENG_INVISDRI INVISDRI Item Relationships: Engineering 1465 53629 401
INV_INVDDFSS INVDDFSS Item Safety Stocks 1185 53645 401
OE_INVIVCSU INVIVCSU Item Search : OE 2030 53631 401
INV_INVISMPS INVISMPS Item Status 1245 52897 401
INV_INVISMPS POXSTDPC Item Status 1245 52897 401
INV_INVSDOIS INVSDOIS Item Status Codes 1261 20466 401
INV_INVIDSUB INVIDSUB Item/Subinventory 1195 53569 401
INV_INVIVCSU INVIVCSU Items Search 1249 53631 401
INV_INVKBCRD INVKBCRD Kanban Cards 3107 54873 401
INV_INVTMSMG INVTMSMG Launch Interface Managers 1605 52553 401
INV_INVTTELT INVTTELT Lot Number 1278 52470 401
INV_INVTDILT INVTDILT Lot Numbers 1271 52905 401
INVSDLUC_F INVSDLUC Lot Specific Conversion 1026207 59769 401
INV_MGD_INVGEZON INVGEZON Maintain Economic Zones 4633 55513 401
INV_INVADCSC INVADCSC Manual Schedule Requests 1171 53616 401
INV_INVIDMPN INVIDMPN Manufacturers' Part Number 1193 52903 401
INV_INVIDMPN_QUERY_ONLY INVIDMPN Manufacturers' Part Number Query-Only 1005002 52903 401
ENG_INVIDITM INVIDITM Master Engineering Items 733 20422 401
INV_INVIDITM INVIDITM Master Items 1191 20422 401
INV_INVMATWB INVMWBIV Material Workbench 1006901 60098 401
INV_INVTTMTX_MISC INVTTMTX Miscellaneous Transaction 1282 52468 401
INV_INVTOMAI ASXTSREC Move Orders 4512 55442 401
INV_INVTOMAI INVTOMAI Move Orders 4512 55442 401
INV_INVTTMVP INVTTMVP Movement Parameters 1287 54169 401
INV_INVTTMVT INVTTMVT Movement Statistics 1288 54168 401
INV_MGD_INVGMSTP INVGMSTP Movement Statistics Parameters 4634 55514 401
INV_MVT_VALIDATION_RULES INVGMVRS Movement Statistics Validation Rules 1004872 56931 401
INV_INVTRMQT INVTRMQT Multi-Organization Quantities Report 1275 53748 401
MYDEMO MYDEMO My Demo Form 1049588 60558 401
OPM_INV_INVSDOUC INVSDOUC OPM Units of Measure Conversions 1021945 52670 401
INV_INVINLOG INVINLOG Oracle Inventory Banner 1242 52676 401
INV_INVSDOIO_INVSDFAA INVSDFAA Org:Define Account Aliases 1988 22098 401
INV_INVSDOIO_INVSDFCR INVSDFCR Org:Define Freight Carriers 1987 53648 401
INV_INVSDOIO_INVSDOSI INVSDOSI Org:Define Inter-Organization Shipping Information 1926 20536 401
INV_INVSDOIO_INVSDSUB INVSDSUB Org:Define Subinventories 1922 20465 401
INV_INVSDORA INVSDORA Organization Access 1565 54181 401
EAM_INVIDITM_ORG INVIDITM Organization Activity 1011595 20422 401
INV_INVGCPOG INVGCPOG Organization Copy Interface 1006853 57997 401
ENG_INVIDITM_ORG INVIDITM Organization Engineering Items 1463 20422 401
INV_INVIDITM_ORG INVIDITM Organization Items 1192 20422 401
INV_INVSDOIO INVSDOIO Organization Parameters 1260 20464 401
INV_INVIDMPN_PART INVIDMPN Part Numbers' Manufacturers 1312 52903 401
INV_INVADPPI INVADPPI Physical Inventories 1174 20482 401
INV_INVADPAP INVADPAP Physical Inventory Adjustments 1173 52947 401
INV_INVADPTE INVADPTE Physical Inventory Counts 1175 20485 401
INV_INVARPGT INVARPGT Physical Inventory Tags 1179 52863 401
INV_INVPPRSU INVPPRSU Pick/Put Away Rule/Strategy Where Used 5512 56048 401
INV_INVPPRDF INVPPRDF Pick/Put Away Rules 5511 56047 401
INV_INVPPSDF INVPPSDF Pick/Put Away Strategy 5514 56050 401
INV_INVPPSAF INVPPSAF Pick/Put Away Strategy Assignments 5513 56049 401
INV_INVPPSOF INVPPSOF Pick/Put Away Strategy Search Order 5515 56051 401
INV_INVSDOPR INVSDOPR Picking Rules 1263 52656 401
INV_INVTTMTX_VMIXFER INVTTMTX Planning Transfer 1011510 52468 401
INV_INVIDITM_PROD_FAMILIES INVIDITM Product Family Items 3155 20422 401
PJM_INVTTMTX_BWPY INVTTMTX Project Transfer Transactions 4400 52468 401
INV_INVKBPSQ INVKBPSQ Pull Sequences 3106 54872 401
INV_INVTDILT_QUERY INVTDILT Query Lot Numbers 1006903 52905 401
INV_INVITSNU_QUERY INVITSNU Query Serial Numbers 1006904 52906 401
INV_INVTTRIN PAXSUDRT RMA Inspection 1600 53783 401
INV_INVTTRIN INVTTRIN RMA Inspection 1600 53783 401
INV_INVTTMTX_RMAISSUE INVTTMTX RMA Issue 1284 52468 401
INV_INVTTMTX_RMARECEIPT INVTTMTX RMA Receipt 1285 52468 401
INV_INVPTRPR INVPTRPR Replenishment Counts 1561 52891 401
INV_INVPTRPR OEXRPDRS Replenishment Counts 1561 52891 401
INV_INVRSVF2 INVRSVF2 Reservations Interface 5558 56080 401
INV_INVDRMRS INVDRMRS Reserve Inventory 1186 52662 401
INV_INVRSVF1 INVRSVF1 Reserve Supply 5557 56079 401
ENG_INVIVCSU INVIVCSU Search Catalog: Engineering Items 737 53631 401
INVPCKLT_F INVPCKLT Select Available Inventory 1032549 60104 401
INV_INVTTESR INVTTESR Serial Number 1279 52640 401
INV_INVITSNU INVITSNU Serial Numbers 1401 52906 401
INV_INVSDOSI INVSDOSI Shipping Networks 1262 20536 401
INV_INVSHDPA INVSHDPA Shortage Parameters 4372 55397 401
INV_INVSAFDH INVSAFDH Stock Locators 1252 20495 401
INV_INVSDSUB INVSDSUB Subinventories 1270 20465 401
INV_INVTTMTX_SUBINV INVTTMTX Subinventory Transfer 1283 52468 401
DEM01_DEM01EOR DEM01EOR Team 01 Demo Orders 1030077 60049 401
INV_INVIDTMP INVIDTMP Templates 1196 53638 401
ENG_INVIDTMP INVIDTMP Templates: Engineering 1464 53638 401
ZYORDERFUNC ZYORDERS Test Order Function Name 1049568 60538 401
INV_INVTOTRX INVTOTRX Transact Move Orders 4513 55445 401
INV_INVSDODL INVSDODL Transaction Default Locators 1258 52945 401
INV_INVSDODS INVSDODS Transaction Default Subinventories 1259 52946 401
INV_INVTMLPR INVTMLPR Transaction History Purge 1274 53663 401
INV_INVTVPTX INVTVPTX Transaction Interface 1604 53762 401
INV_INVTDTRS INVTDTRS Transaction Reasons 1272 53743 401
INV_INVTDTSR INVTDTSR Transaction Source Types 1276 53623 401
INV_INVTDTTY INVTDTTY Transaction Types 1273 52929 401
INV_INVSDUOM INVSDUOM Units of Measure 1277 54300 401
INV_INVSDOCL INVSDOCL Units of Measure Classes 1257 52659 401
INV_INVSDOUC INVSDOUC Units of Measure Conversions 1264 52670 401
INV_INVRSVF1_QUERY INVRSVF1 View Current Reservations 1006905 56079 401
INV_INVTTGGL INVTTGGL View General Ledger Transfers 1280 52533 401
INV_INVIVATT INVIVATT View Item Attributes 1247 53610 401
INV_INVIVSTI INVIVSTI View Item Information 1602 20441 401
INV_INVTVTXN INVTVTXN View Material Transactions 1293 52890 401
CST_INVTVTXN INVTVTXN View Material Trxns 4510 52890 401
INV_INVMSHST INVMSHST View Message History 1046721 60449 401
INV_INVTTMVT_QUERY INVTTMVT View Movement Statistics 1006906 54168 401
INV_INVTVPTX_COST_GROUP INVTVPTX View Pending Interface Activity 1004249 53762 401
INV_INVTVTMP_COST_GROUP INVTVTMP View Pending Transaction 1004248 54403 401
INV_INVTVTMP INVTVTMP View Pending Transactions 1946 54403 401
INV_INVSHINQ INVSHINQ View Potential Shortages 4373 55398 401
INV_INVTVQOH INVTVQOH View Quantities On-hand 1291 54308 401
INV_INVDVRIR POXSTDHC View Reservations 1499 52672 401
INV_INVDVRIR INVDVRIR View Reservations 1499 52672 401
INV_INVDVDSD INVDVDSD View Supply/Demand 1296 52654 401
INV_INVTVTUS INVTVTUS View Transaction Summaries 1292 20459 401
INV_INVTVTUS_COST_GROUP INVTVTUS View Transaction Summary 1004250 20459 401
INV_INVTVTXN_COST_GROUP INVTVTXN View Transactions 1004247 52890 401
WIP_INVTVTXN INVTVTXN View WIP Material Transactions 4630 52890 401
INV_INVADPVT INVADPVT Void Physical Inventory Tags 1178 20512 401
XLA_INVTVTXN INVTVTXN XLA: INV View Material Transactions 4658 52890 401

相关文章：How to use script to get all Oracle EBS Concurrent Program/Report name and corresponding execution file name

===EOF===

返回
【上篇】
【下篇】

作者:

抱歉!评论已关闭.

返回首页

Copyright © 2013-2018 学步园  保留所有权利.
软文销售 QQ客服：2265327166 点击这里给我发消息（其他合作也可洽谈）
必威体育
必威电竞