DBA Data[Home] [Help]

APPS.WIP_UTILITIES dependencies on MTL_TRANSACTIONS_INTERFACE

Line 139: from mtl_transactions_interface

135: and transaction_source_type_id = 5
136: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
137: cursor get_mti(x_txn_header_id number) is
138: select transaction_interface_id, rowid
139: from mtl_transactions_interface
140: where transaction_header_id = x_txn_header_id
141: and transaction_source_type_id = 5
142: and transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION;
143: l_temp_id number;

Line 178: update mtl_transactions_interface

174: -- generate one
175:
176: select mtl_material_transactions_s.nextval into l_temp_id
177: from sys.dual;
178: update mtl_transactions_interface
179: set transaction_interface_id = l_temp_id
180: where rowid = inv_rec.rowid;
181: else
182: l_temp_id := inv_rec.transaction_interface_id;