DBA Data[Home] [Help]

APPS.WIP_SUBS_MERGE dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 13: delete from mtl_transaction_lots_interface

9: function Delete_Children(Interface_id in number)
10: return number is
11: begin
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 ;

Line 22: from mtl_transaction_lots_interface mtli

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);
24:
25: return 1;
26: