The current application as designed will not allow customer to delete the
routing if it is used referencing any WIP Discrete Jobs that are not Closed (status_type=12)
1. In order to delete the routings all the WIP Discrete Jobs that reference the routing have to be closed.
2. The other option is to disable the RTG_CON3 delete constraint and create your own similar to the RTG_CON3 with the addition of the