如何消掉重

jiawu8000

select  WE.WIP_ENTITY_NAME 工单,
       MSI.SEGMENT1 物料,
           wdj.START_QUANTITY 批量 ,
           wro.REQUIRED_QUANTITY 本批数量,
           DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID,5,DECODE(MMT.TRANSACTION_TYPE_ID,43,DECODE(MMT.REASON_ID,21,MMT.TRANSACTION_QUANTITY,NULL),NULL),NULL) 制程不良,
           DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID,5,DECODE(MMT.TRANSACTION_TYPE_ID,43,DECODE(MMT.REASON_ID,1,MMT.TRANSACTION_QUANTITY,NULL),NULL),NULL) 来料不良
from  WIP_DISCRETE_JOBS WDJ ,
      WIP_ENTITIES WE,
          wip_requirement_operations wro,
          MTL_SYSTEM_ITEMS_B MSI,
          MTL_MATERIAL_TRANSACTIONS MMT
          
WHERE WDJ.WIP_ENTITY_ID=WE.WIP_ENTITY_ID
      AND WDJ.ORGANIZATION_ID=WE.ORGANIZATION_ID
      and we.WIP_ENTITY_ID=wro.WIP_ENTITY_ID
          and we.ORGANIZATION_ID=wro.ORGANIZATION_ID
          and MMT.TRANSACTION_SOURCE_ID=WE.WIP_ENTITY_ID
          AND MMT.ORGANIZATION_ID=WE.ORGANIZATION_ID
          and MMT.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
          and MMT.ORGANIZATION_ID=MSI.ORGANIZATION_ID