Tables and queries needed to fetch item catalog and category & relationship between Catalog and categories.
Tag: Oracle Training
Subinventory Query in Oracle Fusion
Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure
Supplier Details Query in Oracle Fusion
Query to fetch the details of a supplier such as Supplier Name, number, DUNS number, tax payer id, contact address, supplier type
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