[Home] [Help]
698: --Bug #3405320
699: --If the document is RMA, do not change serial_transaction_temp_od
700: --For other documents, check if serials are populated in MSNI
701: --If there are none, NULL out serial_temp_id in MTLI else retain it
702: UPDATE mtl_transaction_lots_interface
703: SET product_transaction_id = l_interface_txn_id
704: , serial_transaction_temp_id = DECODE(p_doc_type, 'RMA', serial_transaction_temp_id,
705: decode(l_msni_count, 0, NULL, serial_transaction_temp_id))
706: WHERE product_code = 'RCV'
706: WHERE product_code = 'RCV'
707: AND product_transaction_id = p_original_rti_id;
708: ELSE
709: --First update the lot interface records
710: UPDATE mtl_transaction_lots_interface
711: SET product_transaction_id = l_interface_txn_id
712: WHERE product_code = 'RCV'
713: AND product_transaction_id = p_original_rti_id;
714: END IF;
3206: SELECT SUM(primary_quantity)
3207: , SUM(transaction_quantity)
3208: INTO l_processed_lot_prim_qty
3209: , l_processed_lot_qty
3210: FROM mtl_transaction_lots_interface
3211: WHERE product_code = 'RCV'
3212: AND product_transaction_id
3213: IN (SELECT interface_transaction_id
3214: FROM rcv_transactions_interface
3416: print_debug('QTY TO INSERT3: = ' || L_QTY_TO_INSERT , 1);
3417: END IF;
3418:
3419: IF (p_lot_control_code = 2) THEN
3420: UPDATE mtl_transaction_lots_interface
3421: SET product_transaction_id = l_new_intf_id
3422: WHERE product_transaction_id = p_original_rti_id
3423: AND product_code = 'RCV';
3424: END IF;
3778: -- CASE FOR BOTH LOT AND SERIAL CONTROLLED ITEM
3779: BEGIN
3780: select secondary_transaction_quantity
3781: into l_original_lot_sec_qty
3782: from mtl_transaction_lots_interface mtli
3783: where mtli.lot_number = p_lot_number
3784: and mtli.product_code = 'RCV'
3785: and mtli.product_transaction_id = p_original_rti_id ;
3786: EXCEPTION