ITPub博客

首页 > Linux操作系统 > Linux操作系统 > OM_訂單號, 型號,單價

OM_訂單號, 型號,單價

原创 Linux操作系统 作者:zaorv 时间:2019-05-24 22:30:07 0 删除 编辑
-- 訂單號 型號,單價
 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')
  

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/729024/viewspace-670937/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-12

  • 博文量
    152
  • 访问量
    110317