152: IS
153: SELECT 'Op Seq does not exist'
154: FROM SYS.DUAL
155: WHERE EXISTS (SELECT NULL
156: FROM WIP_DISCRETE_JOBS wdj
157: WHERE (wdj.status_type <> 1
158: OR
159: NOT EXISTS(SELECT NULL
160: FROM WIP_OPERATIONS wo
173: IS
174: SELECT 'Op Seq does not exist'
175: FROM SYS.DUAL
176: WHERE EXISTS (SELECT NULL
177: FROM WIP_DISCRETE_JOBS wdj
178: , WIP_ENTITIES we
179: , WIP_ENTITIES we1
180: , WIP_ENTITIES we2
181: WHERE (wdj.status_type <> 1
198: IS
199: SELECT 'Op Seq does not exist'
200: FROM SYS.DUAL
201: WHERE EXISTS (SELECT NULL
202: FROM WIP_DISCRETE_JOBS wdj
203: WHERE (wdj.status_type <> 1
204: OR
205: NOT EXISTS(SELECT NULL
206: FROM WIP_OPERATIONS wo