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
AND wro.inventory_item_id = wdj.PRIMARY_ITEM_ID)