Item Master Query

/* Formatted on 11/15/2016 1:35:09 PM (QP5 v5.126.903.23003) */
SELECT   ORGANIZATION_CODE,
         ORGANIZATION_NAME,
         MTL_SYSTEM_ITEMS_B.LAST_UPDATE_DATE,
         --MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY,
         MTL_SYSTEM_ITEMS_B.CREATION_DATE,
         -- MTL_SYSTEM_ITEMS_B.CREATED_BY,
         MTL_SYSTEM_ITEMS_B.DESCRIPTION,
         MTL_SYSTEM_ITEMS_TL.LONG_DESCRIPTION,
         MTL_SYSTEM_ITEMS_B.SEGMENT1,
         MTL_SYSTEM_ITEMS_B.SHELF_LIFE_CODE,
         --         MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT,
         --         MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE,
         --         MTL_SYSTEM_ITEMS_B.VOLUME_UOM_CODE,
         --         MTL_SYSTEM_ITEMS_B.UNIT_VOLUME,
         MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE,
         MTL_SYSTEM_ITEMS_B.ITEM_TYPE,
         MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE,
         MTL_SYSTEM_ITEMS_B.PLANNING_MAKE_BUY_CODE,
         MTL_SYSTEM_ITEMS_B.START_DATE_ACTIVE,
         MTL_SYSTEM_ITEMS_B.RETURNABLE_FLAG,
         MTL_SYSTEM_ITEMS_B.PURCHASING_ENABLED_FLAG,
         MTL_SYSTEM_ITEMS_B.SERVICEABLE_PRODUCT_FLAG,
         MTL_SYSTEM_ITEMS_B.END_DATE_ACTIVE,
         MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_FLAG,
         MTL_SYSTEM_ITEMS_B.CUSTOMER_ORDER_ENABLED_FLAG,
         MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_STATUS_CODE,
         MTL_SYSTEM_ITEMS_B.MIN_MINMAX_QUANTITY,
         MTL_SYSTEM_ITEMS_B.MAX_MINMAX_QUANTITY,
         MTL_SYSTEM_ITEMS_B.ATTRIBUTE1 INS_GROUP,
         MTL_SYSTEM_ITEMS_B.ATTRIBUTE2 INS_GRP_DESC,
         STOCK_ENABLED_FLAG,
         INSPECTION_REQUIRED_FLAG,
         RECEIPT_REQUIRED_FLAG,
         RCV_ROUTING_HEADERS.ROUTING_NAME,
         BUYER_ID
  FROM   MTL_SYSTEM_ITEMS_B,
         org_organization_definitions,
         RCV_ROUTING_HEADERS,
         MTL_SYSTEM_ITEMS_TL
 WHERE   org_organization_definitions.ORGANIZATION_ID =
            MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID
         AND ROUTING_HEADER_ID = RECEIVING_ROUTING_ID
         AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID =
               MTL_SYSTEM_ITEMS_TL.ORGANIZATION_ID
         AND MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID =
               MTL_SYSTEM_ITEMS_TL.INVENTORY_ITEM_ID