Skip to main content

Posts

Showing posts from April, 2024

Query to Get Current Onhand Qty & Cost of Inventory Items

On-hand quantity represents the actual quantity of an item available in inventory at a specific location and point in time. SELECT     ood.organization_id,     ood.organization_code,     msi.inventory_item_id,     msi.segment1 item_code,     msi.description,     msi.primary_uom_code,     msi.creation_date item_creation_date,     nvl(SUM(moq.primary_transaction_quantity),0) onhand_qty,     (         SELECT             item_cost         FROM             cst_item_costs cst         WHERE                 cst.cost_type_id = 2             AND msi.inventory_item_id = cst.inventory_item_id             AND ood.organization_id = cst.organization_id     )        ...