SELECT A.ORGANIZATION_ID , A.INVENTORY_ITEM_ID , A.REVISION , B.DESCRIPTION , B.REVISION_QTY_CONTROL_CODE , B.PRIMARY_UOM_CODE FROM MTL_ONHAND_QUANTITIES_DETAIL A , MTL_SYSTEM_ITEMS B WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND A.ORGANIZATION_ID = B.ORGANIZATION_ID UNION SELECT C.ORGANIZATION_ID , C.INVENTORY_ITEM_ID , C.REVISION , D.DESCRIPTION , D.REVISION_QTY_CONTROL_CODE , D.PRIMARY_UOM_CODE FROM MTL_MATERIAL_TRANSACTIONS_TEMP C , MTL_SYSTEM_ITEMS D WHERE C.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID AND C.ORGANIZATION_ID = D.ORGANIZATION_ID