APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 702: UPDATE mtl_transaction_lots_interface

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'

Line 710: UPDATE mtl_transaction_lots_interface

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;

Line 3042: mtl_transaction_lots_interface mtli

3038: rcv_transactions rt,
3039: rcv_shipment_lines rsl,
3040: rcv_shipment_headers rsh,
3041: mtl_serial_numbers_interface msni,
3042: mtl_transaction_lots_interface mtli
3043: WHERE rs.item_id = p_item_id
3044: AND nvl(p_revision, '@@@@') = decode(p_revision,null,'@@@@',rs.item_revision)
3045: AND rs.to_organization_id = p_organization_id
3046: AND (rt.subinventory = v_from_sub OR v_from_sub IS NULL ) -- modified for bug 14269755

Line 3304: FROM mtl_transaction_lots_interface

3300: SELECT SUM(primary_quantity)
3301: , SUM(transaction_quantity)
3302: INTO l_processed_lot_prim_qty
3303: , l_processed_lot_qty
3304: FROM mtl_transaction_lots_interface
3305: WHERE product_code = 'RCV'
3306: AND product_transaction_id
3307: IN (SELECT interface_transaction_id
3308: FROM rcv_transactions_interface

Line 3514: UPDATE mtl_transaction_lots_interface

3510: print_debug('QTY TO INSERT3: = ' || L_QTY_TO_INSERT , 1);
3511: END IF;
3512:
3513: IF (p_lot_control_code = 2) THEN
3514: UPDATE mtl_transaction_lots_interface
3515: SET product_transaction_id = l_new_intf_id
3516: WHERE product_transaction_id = p_original_rti_id
3517: AND product_code = 'RCV';
3518: END IF;

Line 4016: from mtl_transaction_lots_interface mtli

4012: -- CASE FOR BOTH LOT AND SERIAL CONTROLLED ITEM
4013: BEGIN
4014: select secondary_transaction_quantity
4015: into l_original_lot_sec_qty
4016: from mtl_transaction_lots_interface mtli
4017: where mtli.lot_number = p_lot_number
4018: and mtli.product_code = 'RCV'
4019: and mtli.product_transaction_id = p_original_rti_id ;
4020: EXCEPTION