Oracle EBS-SQL (WIP-3):检查非标任务子件没选MRP净值.sql

SELECT WE.WIP_ENTITY_NAME,
           MSI.SEGMENT1,
           MSI.DESCRIPTION,
           WDJ.CLASS_CODE,
           msi2.segment1,
           WDJ.START_QUANTITY,
           WDJ.SCHEDULED_START_DATE       
FROM   WIP.WIP_ENTITIES                               WE,
           WIP.WIP_DISCRETE_JO                        WDJ,
           INV.MTL_SYSTEM_ITEMS_B                   MSI,
           WIP.WIP_REQUIREMENT_OPERATIONS WRO,
           INV.MTL_SYSTEM_ITEMS_B                  msi2
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
    AND MSI.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
    AND MSI.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
    AND WRO.WIP_ENTITY_ID=WE.WIP_ENTITY_ID
    AND msi2.inventory_item_id=wro.inventory_item_id
    AND msi2.organization_id=wro.organization_id
    AND msi2.organization_id=X
    AND WDJ.ORGANIZATION_ID = X
    AND WDJ.JOB_TYPE = 3
    AND WDJ.STATUS_TYPE IN (1, 3)
    AND WRO.MRP_NET_FLAG!=1
   AND WDJ.PRIMARY_ITEM_ID!=WRO.INVENTORY_ITEM_ID

转载于:https://www.cnblogs.com/st-sun/p/3780065.html