513: cursor get_serial_txn is
514: select mtlt.serial_transaction_temp_id,
515: wlcs.fm_serial_number,
516: wlcs.to_serial_number
517: from mtl_transaction_lots_temp mtlt,
518: wip_lpn_completions_serials wlcs
519: where mtlt.lot_number = wlcs.lot_number
520: and wlcs.header_id = flowRec.header_id
521: and mtlt.transaction_temp_id = l_txnTmpID;
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(
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(
631: transaction_temp_id,
632: serial_transaction_temp_id,
633: creation_date,
634: created_by,
799: wlcl.last_updated_by
800: from wip_lpn_completions_lots wlcl
801: where wlcl.header_id = flowRec.header_id;
802:
803: update mtl_transaction_lots_temp
804: set serial_transaction_temp_id = mtl_material_transactions_s.nextval
805: where transaction_temp_id=l_txnTmpID
806: and lot_number in
807: (select lot_number