SELECT DISTINCT A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.REVISION , A.TOTAL_QOH , A.RESERVED_QOH , A.AVAILABLE_QOH , A.SUBINVENTORY_CODE , B.DESCRIPTION ITEM_DESCRIPTION , A.PRIMARY_UOM_CODE , C.ORGANIZATION_CODE , E.NAME ORGANIZATION_NAME , D.AVAILABILITY_TYPE NET , D.RESERVABLE_TYPE RSV , D.INVENTORY_ATP_CODE ATP , D.LOCATOR_TYPE FROM MTL_QOH_SUB_TMP A , MTL_SYSTEM_ITEMS B , MTL_PARAMETERS C , MTL_SECONDARY_INVENTORIES D , HR_ORGANIZATION_UNITS E WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND A.SUBINVENTORY_CODE = D.SECONDARY_INVENTORY_NAME AND A.ORGANIZATION_ID = B.ORGANIZATION_ID AND A.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.ORGANIZATION_ID = D.ORGANIZATION_ID AND A.ORGANIZATION_ID = E.ORGANIZATION_ID AND (D.SUBINVENTORY_TYPE = 1 OR D.SUBINVENTORY_TYPE IS NULL)