Oracle Fusion Finance Archives - Page 5 of 9

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

SQL to fetch vendor site code, procurement BU, alternate site name, customer number, purchasing site flag, pay site flag, document category etc

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

Query to fetch the details of a supplier such as Supplier Name, number, DUNS number, tax payer id, contact address, supplier type