[Home] [Help]
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;
522: /* End - Fix for bug #6216695, which is an FP of 6082623 */
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(
631: transaction_temp_id,
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
808: from wip_lpn_completions_serials
809: where header_id = flowRec.header_id) ;
810:
811:
812: insert into mtl_serial_numbers_temp(
950: wlcs.program_update_date,
951: wlcs.serial_attribute_category,
952: wlcs.status_id,
953: wlcs.origination_date
954: from wip_lpn_completions_serials wlcs
955: where wlcs.header_id = flowRec.header_id;
956:
957: for serial_rec in get_serial_txn loop
958: