2662: IS
2663: SELECT 'Cmp does not exist'
2664: FROM SYS.DUAL
2665: WHERE EXISTS (SELECT NULL
2666: FROM WIP_DISCRETE_JOBS wdj
2667: WHERE (wdj.status_type <> 1
2668: OR
2669: NOT EXISTS(SELECT NULL
2670: FROM WIP_REQUIREMENT_OPERATIONS wro
2686: IS
2687: SELECT 'Cmp does not exist'
2688: FROM SYS.DUAL
2689: WHERE EXISTS (SELECT NULL
2690: FROM WIP_DISCRETE_JOBS wdj
2691: , WIP_ENTITIES we
2692: , WIP_ENTITIES we1
2693: , WIP_ENTITIES we2
2694: WHERE (wdj.status_type <> 1
2715: IS
2716: SELECT 'Cmp does not exist'
2717: FROM SYS.DUAL
2718: WHERE EXISTS (SELECT NULL
2719: FROM WIP_DISCRETE_JOBS wdj
2720: WHERE (wdj.status_type <> 1
2721: OR
2722: NOT EXISTS(SELECT NULL
2723: FROM WIP_REQUIREMENT_OPERATIONS wro