Query to fetch the price, price list and charges of an item and the tables behind it in Oracle Fusion. Also the usage of various tables.
Tag: sql
Item Detail Query in Oracle Fusion Finance
query to fetch the Item Details in Oracle Fusion Finance like Planner, Lead Time, status, minimum Order quantity, Unit Length, lot multiplier etc
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
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
Payment Process Request Query in Fusion
How to fetch the payment details in Fusion Finance i.e. Payment Process Profile, Payment Method and other selection criteria of the invoices.