31: /* Delete the lot rows that were not processed */
32: DELETE FROM rcv_lots_interface rli
33: WHERE NOT EXISTS
34: (SELECT rti.interface_transaction_id
35: FROM rcv_transactions_interface rti
36: WHERE rti.interface_transaction_id =
37: rli.interface_transaction_id);
38:
39:
42: /* Delete the lot rows that were not processed */
43: DELETE FROM rcv_serials_interface rsi
44: WHERE NOT EXISTS
45: (SELECT rti.interface_transaction_id
46: FROM rcv_transactions_interface rti
47: WHERE rti.interface_transaction_id =
48: rsi.interface_transaction_id);
49:
50: