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 )