query to fetch the Purchase Order Details like shipment number, receipt number, buyer, Variance Default Account, Accrual Default Account, Inventory Expense Account, shipped quantity etc
Tag: Oracle Training
Item Shipment History Query in Fusion
Query to fetch the shipment history like item number, shipment date, Inventory, ship to site, ship to party, quantity , sales order number etc
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