APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2613: UPDATE mtl_transaction_lots_interface

2609: IF (l_debug = 1) THEN
2610: print_debug('create_po_rcvtxn_intf_rec 65.3: serial_control_code IS 6, need TO NULL OUT mtli', 4);
2611: END IF;
2612: BEGIN
2613: UPDATE mtl_transaction_lots_interface
2614: SET serial_transaction_temp_id = NULL
2615: WHERE product_transaction_id = p_transaction_temp_id
2616: AND product_code = 'RCV';
2617: EXCEPTION

Line 2841: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE; --Bug 13400589

2837: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2838: l_msni_count NUMBER := 0;
2839: l_prim_uom_code VARCHAR2(3);
2840: l_rcvtxn_uom_code VARCHAR2(3);
2841: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE; --Bug 13400589
2842: BEGIN
2843: x_status := fnd_api.g_ret_sts_success;
2844:
2845: IF (l_debug = 1) THEN

Line 2913: FROM mtl_transaction_lots_interface

2909: --Bug 13400589
2910: IF(p_lot_number IS NULL) THEN
2911: BEGIN
2912: SELECT lot_number INTO l_lot_number
2913: FROM mtl_transaction_lots_interface
2914: WHERE product_transaction_id = p_transaction_temp_id ;
2915: EXCEPTION
2916: WHEN No_Data_Found THEN
2917: IF (l_debug = 1) THEN

Line 3344: UPDATE mtl_transaction_lots_interface

3340: IF (l_debug = 1) THEN
3341: print_debug('create_int_shp_rcvtxn_intf_rec 127.7: serial_control_code IS 6, need TO NULL OUT mtli', 4);
3342: END IF;
3343: IF l_msni_count <= 0 THEN
3344: UPDATE mtl_transaction_lots_interface
3345: SET serial_transaction_temp_id = NULL
3346: WHERE product_transaction_id = p_transaction_temp_id
3347: AND product_code = 'RCV';
3348: END IF;

Line 5737: FROM mtl_transaction_lots_interface

5733: SELECT SUM(primary_quantity)
5734: , SUM(transaction_quantity)
5735: INTO l_processed_lot_prim_qty
5736: , l_processed_lot_qty
5737: FROM mtl_transaction_lots_interface
5738: WHERE product_code = 'RCV'
5739: AND product_transaction_id
5740: IN (SELECT interface_transaction_id
5741: FROM rcv_transactions_interface

Line 5960: UPDATE mtl_transaction_lots_interface

5956: print_debug('QTY TO INSERT3: = ' || L_QTY_TO_INSERT , 1);
5957: END IF;
5958:
5959: IF (p_lot_control_code = 2) THEN
5960: UPDATE mtl_transaction_lots_interface
5961: SET product_transaction_id = l_new_intf_id
5962: WHERE product_transaction_id = p_transaction_temp_id
5963: AND product_code = 'RCV';
5964: END IF;

Line 6363: from mtl_transaction_lots_interface mtli

6359: -- CASE FOR BOTH LOT AND SERIAL CONTROLLED ITEM
6360: BEGIN
6361: select secondary_transaction_quantity
6362: into l_original_lot_sec_qty
6363: from mtl_transaction_lots_interface mtli
6364: where mtli.lot_number = p_lot_number
6365: and mtli.product_code = 'RCV'
6366: and mtli.product_transaction_id = p_transaction_temp_id ;
6367: EXCEPTION