How to set up and query the purchasing org of an operating unit in Oracle R12.
Tag: query
inv_material_txns Sample Queries
Sample queries related to inv_material_txns table.
Price List: Query the price of an item
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.
Work Order Details Query in Oracle Fusion
Query to fetch the work order details such as WO Number, Completion Date, WO Type, Subtype, Status, Planned Start Date, Actual Start Date 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