APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 829: mtl_transaction_lots_temp mtlt

825: ,mtlt.attribute13
826: ,mtlt.attribute14
827: ,mtlt.attribute15
828: FROM
829: mtl_transaction_lots_temp mtlt
830: ,rcv_transactions_interface rti
831: WHERE
832: mtlt.product_transaction_id = p_prod_txn_tmp_id AND
833: mtlt.product_code = 'RCV' AND

Line 1051: DELETE FROM mtl_transaction_lots_temp

1047: print_debug('CREATE_LOT_SERIAL_HISTORY: Deleting MTLI/MSNT',1);
1048: END IF;
1049:
1050: --Delete MTLT/MSNT here
1051: DELETE FROM mtl_transaction_lots_temp
1052: WHERE product_code = 'RCV'
1053: AND product_transaction_id = p_prod_txn_tmp_id;
1054:
1055: l_progress := 'WMSINB-10883';

Line 1725: FROM mtl_transaction_lots_temp

1721: BEGIN
1722: l_progress := 'WMSINB-11306';
1723: SELECT Nvl(SUM(transaction_quantity),0)
1724: INTO l_total_lot_qty
1725: FROM mtl_transaction_lots_temp
1726: WHERE product_code = p_product_code
1727: AND product_transaction_id = p_product_txn_id;
1728: END;
1729: End if;

Line 1762: from mtl_transaction_lots_temp mtlt

1758: l_progress := 'WMSINB-11342';
1759: For l_lot_rec in ( select Ltrim(Rtrim(lot_number)) lot_number
1760: , primary_quantity
1761: , serial_transaction_temp_id
1762: from mtl_transaction_lots_temp mtlt
1763: where mtlt.product_transaction_id = p_product_txn_id
1764: and mtlt.product_code = 'RCV'
1765: )
1766: Loop

Line 1830: from mtl_transaction_lots_temp mtlt

1826: -- R12
1827: -- OPMConvergence
1828: , secondary_quantity
1829: -- OPMConvergence
1830: from mtl_transaction_lots_temp mtlt
1831: where mtlt.product_transaction_id = p_product_txn_id
1832: and mtlt.product_code = 'RCV'
1833: )
1834: Loop

Line 7427: FROM mtl_transaction_lots_temp

7423: primary_quantity,
7424: -- OPMConvergence
7425: secondary_quantity
7426: -- OPMConvergence
7427: FROM mtl_transaction_lots_temp
7428: WHERE product_code = 'RCV'
7429: AND product_transaction_id = p_product_txn_id;
7430:
7431: l_mtlt_rec c_mtlt%ROWTYPE;

Line 8418: FROM mtl_transaction_lots_temp

8414: -- Get total lot qty
8415: l_progress := 'WMSINB-14431';
8416: SELECT Nvl(SUM(transaction_quantity),0)
8417: INTO l_total_lot_qty
8418: FROM mtl_transaction_lots_temp
8419: WHERE product_code = 'RCV'
8420: AND product_transaction_id = l_rti_rec.interface_transaction_id;
8421:
8422: -- GET the TOTAL SERIAL QTY

Line 17289: INSERT INTO mtl_transaction_lots_temp (TRANSACTION_TEMP_ID,

17285: BEGIN
17286:
17287: x_return_status := g_ret_sts_success;
17288:
17289: INSERT INTO mtl_transaction_lots_temp (TRANSACTION_TEMP_ID,
17290: LAST_UPDATE_DATE,
17291: LAST_UPDATED_BY,
17292: CREATION_DATE,
17293: CREATED_BY,

Line 17531: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_temp (move_lot_serial_info)', 1);

17527: IF (l_debug = 1) THEN
17528: print_debug('move_lot_serial_info - Number of MTLT Inserted =: '||SQL%ROWCOUNT ||
17529: ' with product transaction_id = ' || p_rti_id, 1);
17530: /*INVCONV*/
17531: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_temp (move_lot_serial_info)', 1);
17532: /*end , INVCONV*/
17533:
17534: END IF;
17535:

Line 17867: FROM MTL_TRANSACTION_LOTS_TEMP

17863: , attribute12
17864: , attribute13
17865: , attribute14
17866: , attribute15
17867: FROM MTL_TRANSACTION_LOTS_TEMP
17868: WHERE PRODUCT_CODE = 'RCV'
17869: AND PRODUCT_TRANSACTION_ID = L_RTI_ID;
17870:
17871: L_MTLT_REC C_MTLT%ROWTYPE;

Line 18349: FROM mtl_transaction_lots_temp

18345: SELECT '1'
18346: INTO l_dummy
18347: FROM dual
18348: WHERE exists (SELECT 1
18349: FROM mtl_transaction_lots_temp
18350: WHERE product_code = 'RCV'
18351: AND product_transaction_id = l_rti_id);
18352:
18353: --Fail transaction