[Home] [Help]
622:
623:
624: /*Start - Fix for bug #6216695, which is an FP of 6082623 :
625: Insert records into MTLT and MSNT also. Need to create records in
626: mtl_transaction_lots_temp and mtl_serial_numbers_temp based on data
627: in wip_lpn_completions_lots and wip_lpn_completions_serials.
628: This is done so that the data is available for label printing. */
629:
630: insert into mtl_transaction_lots_temp(
808: from wip_lpn_completions_serials
809: where header_id = flowRec.header_id) ;
810:
811:
812: insert into mtl_serial_numbers_temp(
813: transaction_temp_id,
814: fm_serial_number,
815: to_serial_number,
816: serial_prefix,
955: where wlcs.header_id = flowRec.header_id;
956:
957: for serial_rec in get_serial_txn loop
958:
959: update mtl_serial_numbers_temp
960: set transaction_temp_id = serial_rec.serial_transaction_temp_id
961: where fm_serial_number = serial_rec.fm_serial_number
962: and to_serial_number = serial_rec.to_serial_number
963: and transaction_temp_id = l_txnTmpID;