Oracle EBS-SQL (WIP-1):检查非标任务没挂需求.sql

SELECT WE.WIP_ENTITY_NAME,

            MSI.SEGMENT1,

            MSI.DESCRIPTION,

            WDJ.CLASS_CODE,

            WDJ.START_QUANTITY,

            WDJ.SCHEDULED_START_DATE  

FROM    WIP.WIP_ENTITIES WE,

            WIP.WIP_DISCRETE_JOBS WDJ,

            INV.MTL_SYSTEM_ITEMS_B MSI

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 WDJ.ORGANIZATION_ID=X 

    AND WDJ.JOB_TYPE=3

    AND WDJ.STATUS_TYPE IN (1,3)

    AND NOT EXISTS (SELECT 'X'

                                  FROM WIP.WIP_REQUIREMENT_OPERATIONS WRO

                                WHERE WRO.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID )