SELECT MPI.ORGANIZATION_ID , MPI.PHYSICAL_INVENTORY_ID , MSUB.SECONDARY_INVENTORY_NAME SUBINVENTORY , MSUB.LOCATOR_TYPE , MSUB.DESCRIPTION FROM MTL_PHYSICAL_INVENTORIES MPI , MTL_SECONDARY_INVENTORIES MSUB WHERE MPI.ORGANIZATION_ID = MSUB.ORGANIZATION_ID AND ((MPI.ALL_SUBINVENTORIES_FLAG = 1 AND MSUB.QUANTITY_TRACKED = 1) OR (MPI.ALL_SUBINVENTORIES_FLAG = 2 AND EXISTS (SELECT 'X' FROM MTL_PHYSICAL_SUBINVENTORIES MPS WHERE MPS.ORGANIZATION_ID = MSUB.ORGANIZATION_ID AND MPS.SUBINVENTORY = MSUB.SECONDARY_INVENTORY_NAME AND MPS.PHYSICAL_INVENTORY_ID = MPI.PHYSICAL_INVENTORY_ID))) AND (MSUB.SUBINVENTORY_TYPE = 1 OR MSUB.SUBINVENTORY_TYPE IS NULL)