APPS.INV_REPLENISH_DETAIL_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 198: FROM mtl_serial_numbers_temp

194: WHERE move_order_line_id = p_line_id;
195:
196: CURSOR serial_number_csr IS
197: SELECT fm_serial_number, to_serial_number
198: FROM mtl_serial_numbers_temp
199: WHERE transaction_temp_id = l_transaction_temp_id;
200:
201: CURSOR c_mtrh IS
202: SELECT request_number, grouping_rule_id

Line 1209: DELETE mtl_serial_numbers_temp

1205: , lot_line_mark_id = NULL
1206: WHERE group_mark_id = p_trx_header_id;
1207:
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;

Line 1241: FROM mtl_serial_numbers_temp

1237: CURSOR serial_temp_csr(trx_temp_id NUMBER) IS
1238: SELECT fm_serial_number
1239: , to_serial_number
1240: , group_header_id
1241: FROM mtl_serial_numbers_temp
1242: WHERE transaction_temp_id = trx_temp_id;
1243:
1244: l_fm_serial_number VARCHAR2(30);
1245: l_to_serial_number VARCHAR2(30);

Line 1279: FROM mtl_serial_numbers_temp

1275: EXIT WHEN lot_temp_csr%NOTFOUND;
1276:
1277: SELECT COUNT(*)
1278: INTO l_serial_count
1279: FROM mtl_serial_numbers_temp
1280: WHERE transaction_temp_id = l_serial_temp_id;
1281:
1282: IF (l_serial_count > 0) THEN
1283: OPEN serial_temp_csr(l_serial_temp_id);

Line 1308: DELETE mtl_serial_numbers_temp

1304: AND LENGTH(serial_number) = LENGTH(NVL(l_fm_serial_number, serial_number));
1305: END LOOP;
1306: END IF;
1307:
1308: DELETE mtl_serial_numbers_temp
1309: WHERE transaction_temp_id = l_serial_temp_id;
1310: END LOOP;
1311:
1312: CLOSE lot_temp_csr;

Line 1320: FROM mtl_serial_numbers_temp

1316: ELSE
1317: --inv_debug.message('ssia', 'lot_count = ' || l_lot_count);
1318: SELECT COUNT(*)
1319: INTO l_serial_count
1320: FROM mtl_serial_numbers_temp
1321: WHERE transaction_temp_id = p_trx_tmp_id;
1322:
1323: print_debug('serial count: ' || l_serial_count);
1324:

Line 1351: DELETE mtl_serial_numbers_temp

1347:
1348: CLOSE serial_temp_csr;
1349: END IF;
1350:
1351: DELETE mtl_serial_numbers_temp
1352: WHERE transaction_temp_id = p_trx_tmp_id;
1353: END IF;
1354: EXCEPTION
1355: WHEN NO_DATA_FOUND THEN