125: progress := 20;
126:
127: PJM_DEBUG.Debug('Creating Transaction Header');
128:
129: INSERT INTO mtl_transactions_interface
130: ( transaction_header_id
131: , transaction_interface_id
132: , source_code
133: , source_header_id
271: , mti.last_update_login
272: , mti.transaction_quantity
273: , mti.primary_quantity
274: , P_Lot_Number
275: FROM mtl_transactions_interface mti
276: WHERE mti.transaction_interface_id = txn_xface_id;
277:
278: END IF;
279:
315: , mti.created_by
316: , mti.last_update_login
317: , msn.serial_number
318: , msn.serial_number
319: FROM mtl_transactions_interface mti
320: , mtl_serial_numbers msn
321: WHERE mti.transaction_interface_id = txn_xface_id
322: AND msn.inventory_item_id = mti.inventory_item_id
323: AND msn.current_organization_id = mti.organization_id