Featured post

General Ledger Revaluation

General Ledger Revaluation Account balances denominated in foreign currencies are adjusted through the revaluation procedure. Revaluat...

Saturday, 4 February 2017

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  where application_id=401

Sample Output(Inventory Module)

FUNCTION_NAMEFORM_NAMEUSER_FUNCTION_NAMEFUNCTION_IDFORM_IDAPPLICATION_ID
INV_INVADACAINVADACAABC Assignment Updates
1167
53573
401
INV_INVADAASINVADAASABC Assignments
1166
52853
401
INV_INVADACLINVADACLABC Classes
1168
52835
401
INV_INVAAACPARXPRGLPABC Compiles
1165
20813
401
INV_INVAAACPINVAAACPABC Compiles
1165
20813
401
INV_INVADAGRINVADAGRABC Groups
1169
53675
401
INV_INVSDFAAINVSDFAAAccount Aliases
1254
22098
401
INVACODE_FINVACODEAction Codes
1032535
60103
401
EAM_INVIDITMINVIDITMAsset Group/Asset Activity
1011578
20422
401
INV_CARRIER_ACCTSINVSDFCRAssign Carrier Distribution Accounts
1011698
53648
401
INV_INVIDCTLINVIDCTLAttribute Controls
1189
52848
401
INV_INVDDARLINVDDARLAvailable to Promise Rules
1183
52668
401
INV3PL_INVBLRUL_FINVBLRULBilling Rules
1046831
60460
401
INV3PL_INVBLSRC_FINVBLSRCBilling Sources
1046830
60459
401
INV_INVTTMTX_BORROW_PAYBACKINVTTMTXBorrow Payback Transactions
1002820
52468
401
INV_INVIDICGINVIDICGCatalog Groups
1190
53627
401
ENG_INVIDICGINVIDICGCatalog Groups: Engineering
1467
53627
401
INV_INVSDCASINVSDCASCategory Accounts
1253
54053
401
INV_INVIDCATINVIDCATCategory Codes
1188
20463
401
INV_INVIDSCSINVIDSCSCategory Sets
1194
52845
401
INV_INVDVATPPOXPOEACCheck Available to Promise
1187
52665
401
INV_INVDVATPINVDVATPCheck Available to Promise
1187
52665
401
INV_INVTTMTX_CONSXFERINVTTMTXConsigned Transactions
1014437
52468
401
INV_INVCNSUPINVCNSUPConsigned/VMI Consumption
1014641
59193
401
INV_INVGITMTINVGITMTCopy Item Attributes
1005950
57330
401
INV_INVTTGMPINVTTGPMCost Periods
1286
54285
401
INV_INVTVTXN_COST_RESUBMISSIONINVTVTXNCost Transactions Resubmission
4389
52890
401
INV_INVIDXRTINVIDXRTCross Reference Types
1241
20468
401
ENG_INVIDXRTINVIDXRTCross References: Engineering
1466
20468
401
INV_INVSDICCINVSDICCCustomer Item Commodity Codes
2234
54478
401
INV_INVICXRFINVICXRFCustomer Item Cross References
2235
54479
401
INV_INVICITMINVICITMCustomer Items
2227
54473
401
EGO_INVICITM_QUERY_ONLYINVICITMCustomer Items Query Only
1026017
54473
401
INV_INVAMCAPINVAMCAPCycle Count Adjustments
1177
53667
401
INV_INVATCENINVATCENCycle Count Counts
1180
53652
401
INV_INVCCEOIINVCCEOICycle Count Entries in the Open Interface
5257
55941
401
INV_INVADCITINVADCITCycle Count Items
1170
53628
401
INV_INVADCYCINVADCYCCycle Counts
1172
53620
401
INV_INVISDSTINVISDSTDefault Category Sets
1244
53665
401
CST_INVSDCASINVSDCASDefine Category Accounts
3330
54053
401
INVCTDEFINVCTDEFDefine Client Parameters
1047189
60475
401
INV_INVLSATTINVLSATTDefine Desc Flex Context Mapping
1006909
58027
401
INV_INVMSDEFINVMSDEFDefine Material Status
1006916
58033
401
INV_INVDVFDHINVDVFDHDemand History
1498
52843
401
INV_INVDVINTINVDVINTDemand Interface
1849
54395
401
INV_INVIDGRNINVIDGRNEdit Category People
1010442
58502
401
ENG_INVIVATTINVIVATTEngineering Item Attributes
1497
53610
401
INVPCKRL_FINVPCKRLEnhanced Inventory Picking Rule Setup
1032532
60101
401
INV_INVCCEXPINVCCEXPExport Cycle Count Entries
5258
55942
401
INV_INVADCYC_INVAMCAP_TXNHISINVTVTXNFolder:Transaction History
1828
52890
401
INV_INVDDFRLINVDDFRLForecast Rules
1184
53643
401
INVGENLT_FINVGENLTGenerate Multiple Lots
1032496
60097
401
INVGRADE_FINVGRADEGrades
1032534
60102
401
INV_INVAMCAP_INVTVTXNINVTVTXNINV:Transaction History
1921
52890
401
INV_INVSDICRINVSDICRIntercompany Relations
1256
54166
401
INV_INVSICTFINVSICTFIntercompany Transaction Flows
1020872
59591
401
INV_INVTTMTX_INTERORGINVTTMTXInterorganization Transfer
1281
52468
401
INV_MGD_INVGIPBDINVGIPBDInventory Position Build
1006595
57830
401
INV_MGD_INVGIPDPINVGIPDPInventory Position Display
1006596
57831
401
INV_SHORTAGE_INQINVSHINQInventory: View Potential Shortages Summary
1002822
55398
401
INV_INVISDRIINVISDRIItem Relationships
1243
53629
401
ENG_INVISDRIINVISDRIItem Relationships: Engineering
1465
53629
401
INV_INVDDFSSINVDDFSSItem Safety Stocks
1185
53645
401
OE_INVIVCSUINVIVCSUItem Search : OE
2030
53631
401
INV_INVISMPSINVISMPSItem Status
1245
52897
401
INV_INVISMPSPOXSTDPCItem Status
1245
52897
401
INV_INVSDOISINVSDOISItem Status Codes
1261
20466
401
INV_INVIDSUBINVIDSUBItem/Subinventory
1195
53569
401
INV_INVIVCSUINVIVCSUItems Search
1249
53631
401
INV_INVKBCRDINVKBCRDKanban Cards
3107
54873
401
INV_INVTMSMGINVTMSMGLaunch Interface Managers
1605
52553
401
INV_INVTTELTINVTTELTLot Number
1278
52470
401
INV_INVTDILTINVTDILTLot Numbers
1271
52905
401
INVSDLUC_FINVSDLUCLot Specific Conversion
1026207
59769
401
INV_MGD_INVGEZONINVGEZONMaintain Economic Zones
4633
55513
401
INV_INVADCSCINVADCSCManual Schedule Requests
1171
53616
401
INV_INVIDMPNINVIDMPNManufacturers' Part Number
1193
52903
401
INV_INVIDMPN_QUERY_ONLYINVIDMPNManufacturers' Part Number Query-Only
1005002
52903
401
ENG_INVIDITMINVIDITMMaster Engineering Items
733
20422
401
INV_INVIDITMINVIDITMMaster Items
1191
20422
401
INV_INVMATWBINVMWBIVMaterial Workbench
1006901
60098
401
INV_INVTTMTX_MISCINVTTMTXMiscellaneous Transaction
1282
52468
401
INV_INVTOMAIASXTSRECMove Orders
4512
55442
401
INV_INVTOMAIINVTOMAIMove Orders
4512
55442
401
INV_INVTTMVPINVTTMVPMovement Parameters
1287
54169
401
INV_INVTTMVTINVTTMVTMovement Statistics
1288
54168
401
INV_MGD_INVGMSTPINVGMSTPMovement Statistics Parameters
4634
55514
401
INV_MVT_VALIDATION_RULESINVGMVRSMovement Statistics Validation Rules
1004872
56931
401
INV_INVTRMQTINVTRMQTMulti-Organization Quantities Report
1275
53748
401
MYDEMOMYDEMOMy Demo Form
1049588
60558
401
OPM_INV_INVSDOUCINVSDOUCOPM Units of Measure Conversions
1021945
52670
401
INV_INVINLOGINVINLOGOracle Inventory Banner
1242
52676
401
INV_INVSDOIO_INVSDFAAINVSDFAAOrgefine Account Aliases
1988
22098
401
INV_INVSDOIO_INVSDFCRINVSDFCROrgefine Freight Carriers
1987
53648
401
INV_INVSDOIO_INVSDOSIINVSDOSIOrgefine Inter-Organization Shipping Information
1926
20536
401
INV_INVSDOIO_INVSDSUBINVSDSUBOrgefine Subinventories
1922
20465
401
INV_INVSDORAINVSDORAOrganization Access
1565
54181
401
EAM_INVIDITM_ORGINVIDITMOrganization Activity
1011595
20422
401
INV_INVGCPOGINVGCPOGOrganization Copy Interface
1006853
57997
401
ENG_INVIDITM_ORGINVIDITMOrganization Engineering Items
1463
20422
401
INV_INVIDITM_ORGINVIDITMOrganization Items
1192
20422
401
INV_INVSDOIOINVSDOIOOrganization Parameters
1260
20464
401
INV_INVIDMPN_PARTINVIDMPNPart Numbers' Manufacturers
1312
52903
401
INV_INVADPPIINVADPPIPhysical Inventories
1174
20482
401
INV_INVADPAPINVADPAPPhysical Inventory Adjustments
1173
52947
401
INV_INVADPTEINVADPTEPhysical Inventory Counts
1175
20485
401
INV_INVARPGTINVARPGTPhysical Inventory Tags
1179
52863
401
INV_INVPPRSUINVPPRSUPick/Put Away Rule/Strategy Where Used
5512
56048
401
INV_INVPPRDFINVPPRDFPick/Put Away Rules
5511
56047
401
INV_INVPPSDFINVPPSDFPick/Put Away Strategy
5514
56050
401
INV_INVPPSAFINVPPSAFPick/Put Away Strategy Assignments
5513
56049
401
INV_INVPPSOFINVPPSOFPick/Put Away Strategy Search Order
5515
56051
401
INV_INVSDOPRINVSDOPRPicking Rules
1263
52656
401
INV_INVTTMTX_VMIXFERINVTTMTXPlanning Transfer
1011510
52468
401
INV_INVIDITM_PROD_FAMILIESINVIDITMProduct Family Items
3155
20422
401
PJM_INVTTMTX_BWPYINVTTMTXProject Transfer Transactions
4400
52468
401
INV_INVKBPSQINVKBPSQPull Sequences
3106
54872
401
INV_INVTDILT_QUERYINVTDILTQuery Lot Numbers
1006903
52905
401
INV_INVITSNU_QUERYINVITSNUQuery Serial Numbers
1006904
52906
401
INV_INVTTRINPAXSUDRTRMA Inspection
1600
53783
401
INV_INVTTRININVTTRINRMA Inspection
1600
53783
401
INV_INVTTMTX_RMAISSUEINVTTMTXRMA Issue
1284
52468
401
INV_INVTTMTX_RMARECEIPTINVTTMTXRMA Receipt
1285
52468
401
INV_INVPTRPRINVPTRPRReplenishment Counts
1561
52891
401
INV_INVPTRPROEXRPDRSReplenishment Counts
1561
52891
401
INV_INVRSVF2INVRSVF2Reservations Interface
5558
56080
401
INV_INVDRMRSINVDRMRSReserve Inventory
1186
52662
401
INV_INVRSVF1INVRSVF1Reserve Supply
5557
56079
401
ENG_INVIVCSUINVIVCSUSearch Catalog: Engineering Items
737
53631
401
INVPCKLT_FINVPCKLTSelect Available Inventory
1032549
60104
401
INV_INVTTESRINVTTESRSerial Number
1279
52640
401
INV_INVITSNUINVITSNUSerial Numbers
1401
52906
401
INV_INVSDOSIINVSDOSIShipping Networks
1262
20536
401
INV_INVSHDPAINVSHDPAShortage Parameters
4372
55397
401
INV_INVSAFDHINVSAFDHStock Locators
1252
20495
401
INV_INVSDSUBINVSDSUBSubinventories
1270
20465
401
INV_INVTTMTX_SUBINVINVTTMTXSubinventory Transfer
1283
52468
401
DEM01_DEM01EORDEM01EORTeam 01 Demo Orders
1030077
60049
401
INV_INVIDTMPINVIDTMPTemplates
1196
53638
401
ENG_INVIDTMPINVIDTMPTemplates: Engineering
1464
53638
401
ZYORDERFUNCZYORDERSTest Order Function Name
1049568
60538
401
INV_INVTOTRXINVTOTRXTransact Move Orders
4513
55445
401
INV_INVSDODLINVSDODLTransaction Default Locators
1258
52945
401
INV_INVSDODSINVSDODSTransaction Default Subinventories
1259
52946
401
INV_INVTMLPRINVTMLPRTransaction History Purge
1274
53663
401
INV_INVTVPTXINVTVPTXTransaction Interface
1604
53762
401
INV_INVTDTRSINVTDTRSTransaction Reasons
1272
53743
401
INV_INVTDTSRINVTDTSRTransaction Source Types
1276
53623
401
INV_INVTDTTYINVTDTTYTransaction Types
1273
52929
401
INV_INVSDUOMINVSDUOMUnits of Measure
1277
54300
401
INV_INVSDOCLINVSDOCLUnits of Measure Classes
1257
52659
401
INV_INVSDOUCINVSDOUCUnits of Measure Conversions
1264
52670
401
INV_INVRSVF1_QUERYINVRSVF1View Current Reservations
1006905
56079
401
INV_INVTTGGLINVTTGGLView General Ledger Transfers
1280
52533
401
INV_INVIVATTINVIVATTView Item Attributes
1247
53610
401
INV_INVIVSTIINVIVSTIView Item Information
1602
20441
401
INV_INVTVTXNINVTVTXNView Material Transactions
1293
52890
401
CST_INVTVTXNINVTVTXNView Material Trxns
4510
52890
401
INV_INVMSHSTINVMSHSTView Message History
1046721
60449
401
INV_INVTTMVT_QUERYINVTTMVTView Movement Statistics
1006906
54168
401
INV_INVTVPTX_COST_GROUPINVTVPTXView Pending Interface Activity
1004249
53762
401
INV_INVTVTMP_COST_GROUPINVTVTMPView Pending Transaction
1004248
54403
401
INV_INVTVTMPINVTVTMPView Pending Transactions
1946
54403
401
INV_INVSHINQINVSHINQView Potential Shortages
4373
55398
401
INV_INVTVQOHINVTVQOHView Quantities On-hand
1291
54308
401
INV_INVDVRIRPOXSTDHCView Reservations
1499
52672
401
INV_INVDVRIRINVDVRIRView Reservations
1499
52672
401
INV_INVDVDSDINVDVDSDView Supply/Demand
1296
52654
401
INV_INVTVTUSINVTVTUSView Transaction Summaries
1292
20459
401
INV_INVTVTUS_COST_GROUPINVTVTUSView Transaction Summary
1004250
20459
401
INV_INVTVTXN_COST_GROUPINVTVTXNView Transactions
1004247
52890
401
WIP_INVTVTXNINVTVTXNView WIP Material Transactions
4630
52890
401
INV_INVADPVTINVADPVTVoid Physical Inventory Tags
1178
20512
401
XLA_INVTVTXNINVTVTXNXLA: INV View Material Transactions
4658
52890
401

No comments:

Post a Comment

Please review my topic and update your comments

Note: only a member of this blog may post a comment.