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 )