Table structure, constraints & indexes on table inv_secondary_inventories to help the fine tune the queries.
Category: Oracle Fusion
Subinventory Query in Oracle Fusion
Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure
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
Oracle Fusion Sales Order Table – DOO_HEADERS_ALL
To provide the table structure & indexes of DOO_HEADERS_ALL table in Oracle Fusion which holds the Sales Order Header Data in Oracle Fusion.