Query To Find On-Hand Inventory Information In EBS R12

How to find On-hand inventory information?

Execute below query to see the on-hand inventory information in oracle applications.


SELECT NVL(substr(org.organization_code, 1,3), ' ') orgcode , NVL(substr(msi.segment1, 1, 8), ' ') seg11 , NVL(substr(msi.segment1, 9, 8), ' ') seg12 , NVL(substr(msi.segment1, 17, 4), ' ') seg13 , NVL(moq.subinventory_code, ' ') sub_inv_code , NVL(to_char(round(sum(moq.transaction_quantity))), ' ') trans_qnty FROM mtL_system_items msi , org_organization_definitions org , mtl_onhand_quantities moq , hr_organization_units hou WHERE moq.inventory_iteM_id = msi.inventory_item_id AND moq.organizatioN_id = msi.organizatioN_id AND moq.organizatioN_id = org.organizatioN_id AND moq.organization_id = hou.organization_id GROUP BY org.organization_code , moq.subinventory_code , msi.segment1;