110: SELECT 'Sub Res does not exist'
111: FROM SYS.DUAL
112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1
116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR
111: FROM SYS.DUAL
112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1
116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR
119: NOT EXISTS (SELECT NULL
112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1
116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR
119: NOT EXISTS (SELECT NULL
120: FROM WIP_SUB_OPERATION_RESOURCES wsor