APPS.WIP_SUBS_MERGE dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 16: delete from mtl_serial_numbers_interface

12:
13: delete from mtl_transaction_lots_interface
14: where transaction_interface_id = Interface_Id ;
15:
16: delete from mtl_serial_numbers_interface
17: where transaction_interface_id = Interface_Id ;
18:
19: delete from mtl_serial_numbers_interface msni
20: where msni.transaction_interface_id in

Line 19: delete from mtl_serial_numbers_interface msni

15:
16: delete from mtl_serial_numbers_interface
17: where transaction_interface_id = Interface_Id ;
18:
19: delete from mtl_serial_numbers_interface msni
20: where msni.transaction_interface_id in
21: (select serial_transaction_temp_id
22: from mtl_transaction_lots_interface mtli
23: where mtli.transaction_interface_id = Interface_Id);