Oracle EBS-SQL (WIP-2):检查非标任务没挂自己本身.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_JOBSWDJ,
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
AND wro.inventory_item_id = wdj.PRIMARY_ITEM_ID)
页:
[1]