Query to fetch the shipment history like item number, shipment date, Inventory, ship to site, ship to party, quantity , sales order number etc
Tag: Fusion Training
Vendor Site – Invoicing & Payments Query
Query to fetch the Vendor Site details such as payment method, default payment method, bank account, bank, branch in Oracle Fusion
Supplier Site Query ( SQL) – General in Fusion
SQL to fetch vendor site code, procurement BU, alternate site name, customer number, purchasing site flag, pay site flag, document category etc
Item Catalog Category Table Details
Table structure of item catalog categories table like egp_category_sets_b, egp_categories_tl, egp_item_categories, egp_categories_b etc
Item Catalog – Category Assignment in Fusion
Tables and queries needed to fetch item catalog and category & relationship between Catalog and categories.