Tag: Oracle Fusion Online Training

Oracle Fusion Finance, sales Order, shipment

Item Shipment History Query in Fusion

Mohit Saxena

Query to fetch the shipment history like item number, shipment date, Inventory, ship to site, ship to party, quantity , sales order number etc

Constraints, indexes, Oracle Fusion, Table Structure

Item Catalog Category Table Details

Mohit Saxena

Table structure of item catalog categories table like egp_category_sets_b, egp_categories_tl, egp_item_categories, egp_categories_b etc

BI Report, Business Intelligence Report,, Oracle Fusion, Oracle Fusion Finance

Item Catalog – Category Assignment in Fusion

Mohit Saxena

Tables and queries needed to fetch item catalog and category & relationship between Catalog and categories.

BI Report, Business Intelligence Report,, Enterprise structure, Oracle Fusion

Subinventory Query in Oracle Fusion

Mohit Saxena

Query to fetch the subinventory details like inventory, picking Order, material status, depreciable, locator control, locator structure