Item Against Sub inventory and locatory

/* Get Item Against Primary Subinv and locator */
  SELECT   SEGMENT1 PART_NUM,
           (SELECT   SECONDARY_INVENTORY
              FROM   MTL_ITEM_SUB_INVENTORIES_ALL_V
             WHERE       INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
                     AND ORGANIZATION_ID = MSI.ORGANIZATION_ID
                     AND ROWNUM = 1)
              PRIMARY_SUB_INV,
           (SELECT   CONCATENATED_SEGMENTS
              FROM   MTL_ITEM_LOCATIONS_KFV
             WHERE   INVENTORY_LOCATION_ID IN
                           (SELECT   MIN (SECONDARY_LOCATOR)
                              FROM   MTL_SECONDARY_LOCATORS_ALL_V
                             WHERE   INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
                                     AND ORGANIZATION_ID = MSI.ORGANIZATION_ID))
              LOCATOR
    FROM   MTL_SYSTEM_ITEMS_B MSI
   WHERE   ORGANIZATION_ID = :P_ORG_ID
ORDER BY   1