Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure
Category: BI Report, Business Intelligence Report,
Inv_Org_Parameters: Inventory Table In Fusion
Inv_org_parameters table is one of the most important table if you have implemented inventory module in Oracle Fusion. Anywhere there has to be a linkage with inventory org, this table will come into the game. Example is querying egp_system_items_b table for a particular item_number. In the image below you can see the place of inventory… Continue reading Inv_Org_Parameters: Inventory Table In Fusion
Sales Order Table Linkage in Oracle Fusion
Implemented O2C cycle? In this post I'll mention the Sales Order Table Linkage with various tables to find important information of the Sales Order. Alias I have given to the table is dha i.e. if I have to connect any column of doo_headers_all table, join statement will look like dha.<column_name> Entity NameTable NameJoin Condition(s)Select columnCustomer… Continue reading Sales Order Table Linkage in Oracle Fusion
EGP_SYSTEM_ITEMS_B : Item Table in Fusion
Oracle Fusion item master table: Structure, indexes and constraints
How To Fetch (Query) The Payment Details In Fusion
To illustrate the data base structure of Oracle Fusion Payment system i.e. how the different entities like Payment Process Request, Payment, Checks and Invoices are connected to each other and the basic Payment Query.