-- 訂單號 型號，單價
 SELECT DISTINCT OOH.ORDER_NUMBER,OOL.ORDERED_ITEM,MSI.DESCRIPTION ,OOL.UNIT_SELLING_PRICE
    FROM APPS.OE_ORDER_HEADERS_ALL OOH ,
     APPS.OE_ORDER_LINES_ALL OOL ,
     APPS.MTL_SYSTEM_ITEMS  MSI
     WHERE OOH.HEADER_ID=OOL.HEADER_ID
      -- AND MSI.ORGANIZATION_ID = 425
       AND MSI.ORGANIZATION_ID = OOL.SHIP_FROM_ORG_ID
      -- AND OOL.ORDERED_ITEM= MSI.SEGMENT1
       AND OOL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
       AND OOH.ORDER_NUMBER IN
  ('511003116','511003117','511003118','511003119','511003120','511003121'
  ,'511003122','511003123','511003124','511003125','511003126','511003127'
  ,'511003128','511003129','511003130','511005635','511005637','511005638'
  ,'511005640','511005641','511005642','511005643','511005644','511005645'
  ,'511005646','511005647','511005648','511005649','511005650','511005651')