Inventory On Hand details report
Shows on-hand quantity by item, organization (code/name), subinventory, and locator, with date received and create/update transaction IDs—useful to validate stock.
SCM Inventory
Back to Vault
SQL Query for Inventory On Hand details report
SELECT
esi.item_number item_number,
iod.organization_code organization_code,
iod.organization_name organization_name,
ioqd.transaction_quantity onhand_quantity,
ioqd.subinventory_code subinventory_name,
inv_loc.segment1 locators,
to_char(ioqd.date_received, 'dd-mon-rrrr', 'nls_date_language=american') date_received,
ioqd.create_transaction_id create_transaction_id,
ioqd.update_transaction_id update_transaction_id
FROM
inv_onhand_quantities_detail ioqd,
egp_system_items_b_v esi,
inv_item_locations inv_loc,
inv_organization_definitions_v iod
WHERE
ioqd.organization_id = iod.organization_id
AND esi.inventory_item_id = ioqd.inventory_item_id
AND esi.organization_id = ioqd.organization_id
AND ioqd.locator_id = inv_loc.inventory_location_id (+)
ORDER BY
esi.item_numberInventory On Hand details report in BI Connector
