In Oracle Inventory, the table INV_ONHAND_QUANTITIES_DETAIL stores the current on-hand quantity of items available in inventory . This table is commonly used when we want to verify how much quantity is available for a specific item after receiving goods. To trace inventory quantities related to a particular receipt, we can join the Receiving tables with the inventory on-hand table. In the example below, we retrieve the on-hand quantity information for items that were receiv

SELECT dha.order_number, dla.line_number, dfl.fulfill_line_id, dfl.status_code FROM doo_headers_all dha JOIN doo_lines_all dla ON dha.header_id = dla.header_id JOIN doo_fulfill_lines_all dfl ON dfl.line_id = dla.line_id WHERE dha.order_number = 'YOUR_ORDER_NUMBER' -- Replace with order number from UI AND dla.line_number = 1 -- Replace with line number from UI ORDER BY dha.order_number, dla.line_number;