1512: IS
1513: SELECT 'Cmp does not exist'
1514: FROM SYS.DUAL
1515: WHERE EXISTS (SELECT NULL
1516: FROM WIP_DISCRETE_JOBS wdj
1517: WHERE (wdj.status_type <> 1
1518: OR
1519: NOT EXISTS(SELECT NULL
1520: FROM WIP_REQUIREMENT_OPERATIONS wro
1533: IS
1534: SELECT 'Cmp does not exist'
1535: FROM SYS.DUAL
1536: WHERE EXISTS (SELECT NULL
1537: FROM WIP_DISCRETE_JOBS wdj
1538: , WIP_ENTITIES we
1539: , WIP_ENTITIES we1
1540: , WIP_ENTITIES we2
1541: WHERE (wdj.status_type <> 1
1559: IS
1560: SELECT 'Cmp does not exist'
1561: FROM SYS.DUAL
1562: WHERE EXISTS (SELECT NULL
1563: FROM WIP_DISCRETE_JOBS wdj
1564: WHERE (wdj.status_type <> 1
1565: OR
1566: NOT EXISTS(SELECT NULL
1567: FROM WIP_REQUIREMENT_OPERATIONS wro