A high level overview of Order to Cash Cycle in Oracle Fusion.
Category: sales Order
Work Order – Sales Order Connecting Query
Query to get the Sales Order - Work Order Relationship in Oracle Fusion.
DOO_LINES_ALL: Sales Order Lines Table
DOO_LINES_ALL: table structure, constraints and indexes on the table used by Oracle Fusion to store the sales order line data.
DOO_FULFILL_LINES_ALL: Columns, Indexes & Imp Points
doo_fulfill_lines_all: column, index and constraint details : the table which holds the fulfilment details of Sales Order Line
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