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

===EOF===

ITPub博客

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

最新文章