APPS.INV_RCV_INTEGRATION_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 853: mtl_transaction_lots_temp mtlt

849: ,mtlt.attribute13
850: ,mtlt.attribute14
851: ,mtlt.attribute15
852: FROM
853: mtl_transaction_lots_temp mtlt
854: ,rcv_transactions_interface rti
855: WHERE
856: mtlt.product_transaction_id = p_prod_txn_tmp_id AND
857: mtlt.product_code = 'RCV' AND

Line 1075: DELETE FROM mtl_transaction_lots_temp

1071: print_debug('CREATE_LOT_SERIAL_HISTORY: Deleting MTLI/MSNT',1);
1072: END IF;
1073:
1074: --Delete MTLT/MSNT here
1075: DELETE FROM mtl_transaction_lots_temp
1076: WHERE product_code = 'RCV'
1077: AND product_transaction_id = p_prod_txn_tmp_id;
1078:
1079: l_progress := 'WMSINB-10883';

Line 1751: FROM mtl_transaction_lots_temp

1747: BEGIN
1748: l_progress := 'WMSINB-11306';
1749: SELECT Nvl(SUM(transaction_quantity),0)
1750: INTO l_total_lot_qty
1751: FROM mtl_transaction_lots_temp
1752: WHERE product_code = p_product_code
1753: AND product_transaction_id = p_product_txn_id;
1754: END;
1755: End if;

Line 1788: from mtl_transaction_lots_temp mtlt

1784: l_progress := 'WMSINB-11342';
1785: For l_lot_rec in ( select Ltrim(Rtrim(lot_number)) lot_number
1786: , primary_quantity
1787: , serial_transaction_temp_id
1788: from mtl_transaction_lots_temp mtlt
1789: where mtlt.product_transaction_id = p_product_txn_id
1790: and mtlt.product_code = 'RCV'
1791: )
1792: Loop

Line 1857: from mtl_transaction_lots_temp mtlt

1853: -- R12
1854: -- OPMConvergence
1855: , secondary_quantity
1856: -- OPMConvergence
1857: from mtl_transaction_lots_temp mtlt
1858: where mtlt.product_transaction_id = p_product_txn_id
1859: and mtlt.product_code = 'RCV'
1860: )
1861: Loop

Line 7702: FROM mtl_transaction_lots_temp

7698: Sum(primary_quantity) primary_quantity,
7699: -- OPMConvergence
7700: Sum(secondary_quantity) secondary_quantity
7701: -- OPMConvergence
7702: FROM mtl_transaction_lots_temp
7703: WHERE product_code = 'RCV'
7704: AND product_transaction_id = p_product_txn_id
7705: GROUP BY lot_number;
7706:

Line 8802: FROM mtl_transaction_lots_temp

8798: -- Get total lot qty
8799: l_progress := 'WMSINB-14431';
8800: SELECT Nvl(SUM(transaction_quantity),0)
8801: INTO l_total_lot_qty
8802: FROM mtl_transaction_lots_temp
8803: WHERE product_code = 'RCV'
8804: AND product_transaction_id = l_rti_rec.interface_transaction_id;
8805:
8806: -- GET the TOTAL SERIAL QTY

Line 10335: FROM mtl_transaction_lots_temp

10331: if l_wms_lot = 2 then
10332: print_debug('This is a lot controlled item ',1);
10333: begin
10334: SELECT lot_number into l_wms_lot_number
10335: FROM mtl_transaction_lots_temp
10336: WHERE PRODUCT_TRANSACTION_ID = p_txn_id;
10337:
10338: print_debug('Lot number is := '||l_wms_lot_number,1);
10339: exception

Line 18232: INSERT INTO mtl_transaction_lots_temp (TRANSACTION_TEMP_ID,

18228: RAISE fnd_api.g_exc_error;
18229: END;
18230: END IF;
18231:
18232: INSERT INTO mtl_transaction_lots_temp (TRANSACTION_TEMP_ID,
18233: LAST_UPDATE_DATE,
18234: LAST_UPDATED_BY,
18235: CREATION_DATE,
18236: CREATED_BY,

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

18471: IF (l_debug = 1) THEN
18472: print_debug('move_lot_serial_info - Number of MTLT Inserted =: '||SQL%ROWCOUNT ||
18473: ' with product transaction_id = ' || p_rti_id, 1);
18474: /*INVCONV*/
18475: print_debug('INVCONV, removed sublot_num, Added some more parameters in INSERT INTO mtl_transaction_lots_temp (move_lot_serial_info)', 1);
18476: /*end , INVCONV*/
18477:
18478: END IF;
18479:

Line 18692: UPDATE mtl_transaction_lots_temp mtlt

18688: -- Bug 13886318 need to revert bug 12329840
18689: -- END IF; -- Bug 12329840
18690:
18691: /* Added By Bug#9713930 */
18692: UPDATE mtl_transaction_lots_temp mtlt
18693: set mtlt.serial_transaction_temp_id =
18694: (Select msni.transaction_interface_id
18695: from mtl_serial_numbers_interface msni where
18696: msni.product_code = 'RCV'

Line 18844: FROM MTL_TRANSACTION_LOTS_TEMP

18840: , attribute12
18841: , attribute13
18842: , attribute14
18843: , attribute15
18844: FROM MTL_TRANSACTION_LOTS_TEMP
18845: WHERE PRODUCT_CODE = 'RCV'
18846: AND PRODUCT_TRANSACTION_ID = L_RTI_ID;
18847:
18848: L_MTLT_REC C_MTLT%ROWTYPE;

Line 19366: FROM mtl_transaction_lots_temp

19362: SELECT '1'
19363: INTO l_dummy
19364: FROM dual
19365: WHERE exists (SELECT 1
19366: FROM mtl_transaction_lots_temp
19367: WHERE product_code = 'RCV'
19368: AND product_transaction_id = l_rti_id);
19369:
19370: --Fail transaction