APPS.INV_REPLENISH_DETAIL_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 225: from mtl_transaction_lots_temp

221:
222: -- MUOM Fulfillment Project
223: cursor c_mtlt is
224: select primary_quantity, secondary_quantity, lot_number
225: from mtl_transaction_lots_temp
226: where transaction_temp_id = l_transaction_temp_id;
227:
228: l_detailed_uom VARCHAR2(10);
229: l_txn_uom VARCHAR2(10);

Line 721: FROM mtl_transaction_lots_temp WHERE

717: ELSIF l_detailed_uom = l_secondary_uom THEN
718: l_detailed_qty := l_detailed_qty + ABS(l_transaction_quantity2);
719: ELSE
720: SELECT Count(*) INTO l_mtlt_count
721: FROM mtl_transaction_lots_temp WHERE
722: transaction_temp_id = l_transaction_temp_id;
723:
724: IF l_mtlt_count > 0 THEN
725: l_transaction_quantity := 0;

Line 828: FROM mtl_transaction_lots_temp

824: -- set output variables
825: IF p_move_order_type <> 3 THEN
826: BEGIN
827: SELECT COUNT(*) INTO l_cnt_lot
828: FROM mtl_transaction_lots_temp
829: WHERE transaction_temp_id = l_transaction_temp_id;
830:
831: IF l_cnt_lot = 1 THEN
832: SELECT lot_number

Line 834: FROM mtl_transaction_lots_temp

830:
831: IF l_cnt_lot = 1 THEN
832: SELECT lot_number
833: INTO l_lot_number
834: FROM mtl_transaction_lots_temp
835: WHERE transaction_temp_id = l_transaction_temp_id;
836: END IF;
837: EXCEPTION
838: WHEN OTHERS THEN

Line 1212: DELETE mtl_transaction_lots_temp

1208: -- Delete lot and serial records from temp tables
1209: DELETE mtl_serial_numbers_temp
1210: WHERE group_header_id = p_trx_header_id;
1211:
1212: DELETE mtl_transaction_lots_temp
1213: WHERE group_header_id = p_trx_header_id;
1214:
1215: DELETE mtl_material_transactions_temp
1216: WHERE transaction_header_id = p_trx_header_id;

Line 1234: FROM mtl_transaction_lots_temp

1230: unmarked_value NUMBER := -1;
1231:
1232: CURSOR lot_temp_csr(trx_temp_id NUMBER) IS
1233: SELECT serial_transaction_temp_id
1234: FROM mtl_transaction_lots_temp
1235: WHERE transaction_temp_id = trx_temp_id;
1236:
1237: CURSOR serial_temp_csr(trx_temp_id NUMBER) IS
1238: SELECT fm_serial_number

Line 1255: FROM mtl_transaction_lots_temp

1251: p_success := TRUE;
1252:
1253: SELECT COUNT(*)
1254: INTO l_lot_count
1255: FROM mtl_transaction_lots_temp
1256: WHERE transaction_temp_id = p_trx_tmp_id;
1257:
1258: --inv_debug.message('ssia', 'after lot_count = ' || l_lot_count);
1259: --inv_debug.message('ssia', 'p_trx_tmp_id is ' || p_trx_tmp_id);

Line 1314: DELETE mtl_transaction_lots_temp

1310: END LOOP;
1311:
1312: CLOSE lot_temp_csr;
1313:
1314: DELETE mtl_transaction_lots_temp
1315: WHERE transaction_temp_id = p_trx_tmp_id;
1316: ELSE
1317: --inv_debug.message('ssia', 'lot_count = ' || l_lot_count);
1318: SELECT COUNT(*)

Line 1585: FROM mtl_transaction_lots_temp

1581: SELECT lot_number
1582: , primary_quantity
1583: , transaction_quantity
1584: , serial_transaction_temp_id
1585: FROM mtl_transaction_lots_temp
1586: WHERE transaction_temp_id = l_transaction_temp_id;
1587:
1588: CURSOR serial_csr(l_transaction_id NUMBER, l_lot_control_code NUMBER, l_serial_trx_id NUMBER) IS
1589: SELECT serial_number

Line 1688: FROM mtl_transaction_lots_temp

1684: END IF;
1685:
1686: SELECT COUNT(transaction_temp_id)
1687: INTO l_lot_count
1688: FROM mtl_transaction_lots_temp
1689: WHERE transaction_temp_id = l_mmtt_rec.transaction_temp_id;
1690:
1691: IF (l_lot_count > 0) THEN
1692: l_transaction_temp_id := l_mmtt_rec.transaction_temp_id;

Line 3372: FROM mtl_transaction_lots_temp

3368: END IF;
3369: -- Get sum of txn qty of all mtlt's for this mmtt
3370: SELECT nvl(SUM(transaction_quantity),0), nvl(SUM(SECONDARY_QUANTITY),0)
3371: INTO l_all_mtlt, l_all_mtlt2
3372: FROM mtl_transaction_lots_temp
3373: WHERE transaction_temp_id = l_transaction_temp_id;
3374:
3375: --/* Bug 9448490 Lot Substitution Project */ start
3376: BEGIN

Line 3380: FROM mtl_transaction_lots_temp

3376: BEGIN
3377: -- Get this mtlt
3378: SELECT nvl(SUM(transaction_quantity),0), nvl(SUM(SECONDARY_QUANTITY),0)
3379: INTO l_this_mtlt, l_this_mtlt2
3380: FROM mtl_transaction_lots_temp
3381: WHERE transaction_temp_id = l_transaction_temp_id
3382: AND lot_number = l_lot_num;
3383: EXCEPTION
3384: WHEN OTHERS THEN