APPS.INV_RCV_STD_RCPT_APIS dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2376: UPDATE mtl_transaction_lots_interface

2372: IF (l_debug = 1) THEN
2373: print_debug('create_po_rcpt_intf_rec 130.6: serial_control_code IS 6, need TO NULL OUT mtli', 4);
2374: END IF;
2375: BEGIN
2376: UPDATE mtl_transaction_lots_interface
2377: SET serial_transaction_temp_id = NULL
2378: WHERE product_transaction_id = p_original_rti_id
2379: AND product_code = 'RCV';
2380: EXCEPTION

Line 2854: FROM mtl_transaction_lots_interface

2850:
2851: --9229228-starts
2852: BEGIN
2853: SELECT lot_number INTO l_lot_number
2854: FROM mtl_transaction_lots_interface
2855: WHERE product_transaction_id = p_original_rti_id ;
2856: EXCEPTION
2857: WHEN No_Data_Found THEN
2858: IF (l_debug = 1) THEN

Line 3178: UPDATE mtl_transaction_lots_interface

3174: AND product_code = 'RCV';
3175: END IF;
3176:
3177: IF l_msni_count = 0 THEN
3178: UPDATE mtl_transaction_lots_interface
3179: SET serial_transaction_temp_id = NULL
3180: WHERE product_transaction_id = p_original_rti_id
3181: AND product_code = 'RCV';
3182: END IF;

Line 4392: FROM mtl_transaction_lots_interface

4388:
4389: --12339922-starts
4390: BEGIN
4391: SELECT lot_number INTO l_lot_number
4392: FROM mtl_transaction_lots_interface
4393: WHERE product_transaction_id = p_original_rti_id ;
4394: EXCEPTION
4395: WHEN No_Data_Found THEN
4396: IF (l_debug = 1) THEN

Line 4923: UPDATE mtl_transaction_lots_interface

4919: AND product_code = 'RCV';
4920: END IF;
4921:
4922: IF l_msni_count = 0 THEN
4923: UPDATE mtl_transaction_lots_interface
4924: SET serial_transaction_temp_id = NULL
4925: WHERE product_transaction_id = p_original_rti_id
4926: AND product_code = 'RCV';
4927: END IF;

Line 9661: FROM mtl_transaction_lots_interface mtli,

9657:
9658: BEGIN
9659: SELECT NVL(SUM(mtli.primary_quantity),0)
9660: INTO l_mtli_primary_quantity
9661: FROM mtl_transaction_lots_interface mtli,
9662: rcv_transactions_interface rti
9663: WHERE rti.processing_status_code <> 'ERROR'
9664: AND rti.transaction_status_code <> 'ERROR'
9665: AND rti.to_organization_id = p_rcv_org_id

Line 9683: FROM mtl_transaction_lots_interface

9679: IF (p_product_txn_id IS NOT NULL) THEN
9680: BEGIN
9681: SELECT Nvl(SUM(primary_quantity),0)
9682: INTO l_current_grp_prim_qty
9683: FROM mtl_transaction_lots_interface
9684: WHERE product_transaction_id = p_product_txn_id
9685: AND lot_number = p_lot_number
9686: AND product_code = 'RCV';
9687: EXCEPTION

Line 9812: FROM mtl_transaction_lots_interface mtli,

9808:
9809: BEGIN
9810: SELECT NVL(SUM(mtli.primary_quantity),0)
9811: INTO l_mtli_primary_quantity
9812: FROM mtl_transaction_lots_interface mtli,
9813: rcv_transactions_interface rti
9814: WHERE rti.processing_status_code <> 'ERROR'
9815: AND rti.transaction_status_code <> 'ERROR'
9816: AND rti.to_organization_id = p_rcv_org_id

Line 9835: FROM mtl_transaction_lots_interface

9831: IF (p_product_txn_id IS NOT NULL) THEN
9832: BEGIN
9833: SELECT Nvl(SUM(primary_quantity),0)
9834: INTO l_current_grp_prim_qty
9835: FROM mtl_transaction_lots_interface
9836: WHERE product_transaction_id = p_product_txn_id
9837: AND lot_number = p_lot_number
9838: AND product_code = 'RCV';
9839: EXCEPTION