APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2711: UPDATE mtl_transaction_lots_interface

2707: --WHERE transaction_interface_id = l_wlpnci_rec.interface_transaction_id;
2708: WHERE transaction_interface_id = l_wlpnci_rec.serial_transaction_intf_id;
2709:
2710:
2711: UPDATE mtl_transaction_lots_interface
2712: SET serial_transaction_temp_id = l_serial_txn_intf_id
2713: WHERE product_code = 'RCV'
2714: AND product_transaction_id = l_wlpnci_rec.interface_transaction_id;
2715:

Line 10178: insert into mtl_transaction_lots_interface (

10174: print_debug('p_transaction_quantity = '|| p_transaction_quantity , 4);
10175: print_debug('p_primary_quantity = '|| p_primary_quantity , 4);
10176: END IF;
10177:
10178: insert into mtl_transaction_lots_interface (
10179: TRANSACTION_INTERFACE_ID,
10180: SOURCE_CODE,
10181: SOURCE_LINE_ID,
10182: LAST_UPDATE_DATE,

Line 13102: , mtl_transaction_lots_interface mtli

13098: ELSE --IF l_lpn_contents.lot_number IS NULL THEN
13099: select sum(mtli.primary_quantity)
13100: into l_rti_qty
13101: from rcv_transactions_interface rti
13102: , mtl_transaction_lots_interface mtli
13103: where rti.lpn_group_id = p_lpn_group_id
13104: and (rti.lpn_id = l_lpn_contents.lpn_id
13105: OR rti.license_plate_number = l_lpn_contents.license_plate_number)
13106: -- 3397823

Line 15914: INSERT INTO mtl_transaction_lots_interface

15910: IF (l_debug = 1) THEN
15911: print_debug('insert_mtli_rowid:010: Entry Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
15912: END If;
15913:
15914: INSERT INTO mtl_transaction_lots_interface
15915: (TRANSACTION_INTERFACE_ID,
15916: SOURCE_CODE,
15917: SOURCE_LINE_ID,
15918: LAST_UPDATE_DATE,

Line 16116: FROM mtl_transaction_lots_interface

16112: reason_code,
16113: NULL,
16114: PRODUCT_CODE,
16115: p_product_txn_id
16116: FROM mtl_transaction_lots_interface
16117: WHERE ROWID = p_rowid);
16118:
16119: IF (l_debug = 1) THEN
16120: print_debug('insert_mtli_rowid:020: Exit Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 16122: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_interface (insert_mtli_rowid)', 1);

16118:
16119: IF (l_debug = 1) THEN
16120: print_debug('insert_mtli_rowid:020: Exit Stamp :' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
16121: /* INVCONV*/
16122: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_interface (insert_mtli_rowid)', 1);
16123: /*end , INVCONV*/
16124:
16125: END If;
16126: EXCEPTION

Line 16377: FROM mtl_transaction_lots_interface

16373: transaction_quantity,
16374: primary_quantity,
16375: serial_transaction_temp_id,
16376: ROWID
16377: FROM mtl_transaction_lots_interface
16378: WHERE product_code = 'RCV'
16379: AND product_transaction_id = l_old_rti_id;
16380:
16381: l_mtli_rec mtli_recs%ROWTYPE;

Line 16458: FROM mtl_transaction_lots_interface

16454:
16455: BEGIN
16456: SELECT SUM(transaction_quantity)
16457: INTO l_total_lot_qty
16458: FROM mtl_transaction_lots_interface
16459: WHERE product_code = 'RCV'
16460: AND product_transaction_id = l_orig_interface_trx_id;
16461: EXCEPTION
16462: WHEN no_data_found THEN

Line 16573: FROM mtl_transaction_lots_interface mtli

16569:
16570: BEGIN
16571: SELECT SUM(mtli.transaction_quantity)
16572: INTO l_lot_ser_qty
16573: FROM mtl_transaction_lots_interface mtli
16574: WHERE mtli.product_code = 'RCV'
16575: AND mtli.product_transaction_id = l_orig_interface_trx_id
16576: AND (mtli.serial_transaction_temp_id IS NULL
16577: OR nvl(mtli.primary_quantity,

Line 16678: FROM mtl_transaction_lots_interface

16674:
16675: BEGIN
16676: SELECT SUM(transaction_quantity)
16677: INTO l_total_lot_qty
16678: FROM mtl_transaction_lots_interface
16679: WHERE product_code = 'RCV'
16680: AND product_transaction_id = l_orig_interface_trx_id;
16681: EXCEPTION
16682: WHEN no_data_found THEN

Line 16745: FROM mtl_transaction_lots_interface mtli

16741:
16742: BEGIN
16743: SELECT SUM(mtli.transaction_quantity)
16744: INTO l_lot_ser_qty
16745: FROM mtl_transaction_lots_interface mtli
16746: WHERE mtli.product_code = 'RCV'
16747: AND mtli.product_transaction_id = l_orig_interface_trx_id
16748: AND (mtli.serial_transaction_temp_id IS NULL
16749: OR nvl(mtli.primary_quantity,

Line 16873: UPDATE mtl_transaction_lots_interface

16869: l_primary_rem_qty := (l_remaining_quantity*l_mtli_rec.primary_quantity)/l_mtli_rec.transaction_quantity;
16870:
16871: IF (l_mtli_rec.transaction_quantity <= l_remaining_quantity) THEN
16872: -- update the mtli with new rti id.
16873: UPDATE mtl_transaction_lots_interface
16874: SET product_transaction_id = p_rti_tb(newrti).new_interface_trx_id
16875: WHERE ROWID = l_mtli_rec.ROWID;
16876:
16877: IF (l_debug = 1) THEN

Line 16949: UPDATE mtl_transaction_lots_interface

16945: END If;
16946:
16947: -- update the original row
16948: -- For OPM null out the secondary_transaction_quantity
16949: UPDATE mtl_transaction_lots_interface
16950: SET transaction_quantity = transaction_quantity -
16951: l_remaining_quantity,
16952: primary_quantity = primary_quantity - l_primary_rem_qty,
16953: secondary_transaction_quantity = NULL

Line 17522: FROM mtl_transaction_lots_interface

17518: REASON_ID ,
17519: /* end INVCONV */
17520: secondary_transaction_quantity,
17521: reason_code
17522: FROM mtl_transaction_lots_interface
17523: WHERE product_code = 'RCV'
17524: AND product_transaction_id = p_rti_id;
17525:
17526:

Line 17727: DELETE FROM mtl_transaction_lots_interface

17723: ' with product transaction_id =' || p_rti_id, 1);
17724: END IF;
17725:
17726: --delete mtli and msni
17727: DELETE FROM mtl_transaction_lots_interface
17728: WHERE product_code = 'RCV'
17729: AND product_transaction_id = p_rti_id;
17730:
17731: DELETE FROM mtl_serial_numbers_interface