eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1000: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - START

996:
997: END IF; --IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error)
998: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - END
999:
1000: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - START
1001: SELECT MSNT.transaction_temp_id, MSNT.fm_serial_number, MSNT.to_serial_number
1002: INTO l_temp_txn_id, l_fm_serial, l_to_serial
1003: FROM mtl_material_transactions_temp MMTT, mtl_serial_numbers_temp MSNT
1004: WHERE MMTT.transaction_temp_id = MSNT.transaction_temp_id

Line 1003: FROM mtl_material_transactions_temp MMTT, mtl_serial_numbers_temp MSNT

999:
1000: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - START
1001: SELECT MSNT.transaction_temp_id, MSNT.fm_serial_number, MSNT.to_serial_number
1002: INTO l_temp_txn_id, l_fm_serial, l_to_serial
1003: FROM mtl_material_transactions_temp MMTT, mtl_serial_numbers_temp MSNT
1004: WHERE MMTT.transaction_temp_id = MSNT.transaction_temp_id
1005: AND MMTT.move_order_line_id = l_to_line_tbl(i).line_id;
1006:
1007: IF (l_log_statement >= l_log_current_level) THEN

Line 1029: 'Deleting mtl_serial_numbers_temp with temp_txn_id: ' || l_temp_txn_id);

1025: );
1026:
1027: IF (l_log_statement >= l_log_current_level) THEN
1028: FND_LOG.string(l_log_statement, L_DEBUG,
1029: 'Deleting mtl_serial_numbers_temp with temp_txn_id: ' || l_temp_txn_id);
1030: END IF;
1031:
1032: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_temp_txn_id;
1033:

Line 1032: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_temp_txn_id;

1028: FND_LOG.string(l_log_statement, L_DEBUG,
1029: 'Deleting mtl_serial_numbers_temp with temp_txn_id: ' || l_temp_txn_id);
1030: END IF;
1031:
1032: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_temp_txn_id;
1033:
1034: IF (l_log_statement >= l_log_current_level) THEN
1035: FND_LOG.string(l_log_statement, L_DEBUG,
1036: 'Rows deleted from mtl_serial_numbers_temp: ' || SQL%ROWCOUNT);

Line 1036: 'Rows deleted from mtl_serial_numbers_temp: ' || SQL%ROWCOUNT);

1032: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_temp_txn_id;
1033:
1034: IF (l_log_statement >= l_log_current_level) THEN
1035: FND_LOG.string(l_log_statement, L_DEBUG,
1036: 'Rows deleted from mtl_serial_numbers_temp: ' || SQL%ROWCOUNT);
1037: END IF;
1038:
1039: IF (l_log_statement >= l_log_current_level) THEN
1040: FND_LOG.string(l_log_statement, L_DEBUG,

Line 1065: 'Inserting into mtl_serial_numbers_temp for Serial: '

1061: IF(l_mark_serial_success = 3) THEN
1062:
1063: IF (l_log_statement >= l_log_current_level) THEN
1064: FND_LOG.string(l_log_statement, L_DEBUG,
1065: 'Inserting into mtl_serial_numbers_temp for Serial: '
1066: || p_supply_tbl_type(i).Serial_Number);
1067: END IF;
1068:
1069: INSERT INTO mtl_serial_numbers_temp(transaction_temp_id

Line 1069: INSERT INTO mtl_serial_numbers_temp(transaction_temp_id

1065: 'Inserting into mtl_serial_numbers_temp for Serial: '
1066: || p_supply_tbl_type(i).Serial_Number);
1067: END IF;
1068:
1069: INSERT INTO mtl_serial_numbers_temp(transaction_temp_id
1070: , last_update_date
1071: , last_updated_by
1072: , creation_date
1073: , created_by

Line 1099: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - END

1095: || ' with return status: ' || l_mark_serial_success);
1096: END IF;
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: --Update mtl_serial_numbers_temp with the required Serial Instead of auto assigend serial - END
1100:
1101: --Get the new MO Header ID for this serial
1102: x_mo_lines_tbl(i) := l_trolin_tbl(i).line_id;
1103:

Line 3038: select FM_SERIAL_NUMBER, TO_SERIAL_NUMBER from MTL_SERIAL_NUMBERS_TEMP

3034: RELEASE_BATCH EXCEPTION;
3035: ALLOCATION_ERROR EXCEPTION;
3036:
3037: cursor GET_INIT_SERIAL_ALLOC(P_MMTT_TEMP_ID number) is
3038: select FM_SERIAL_NUMBER, TO_SERIAL_NUMBER from MTL_SERIAL_NUMBERS_TEMP
3039: where transaction_temp_id = p_mmtt_temp_id;
3040:
3041: BEGIN
3042: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 3414: FROM mtl_serial_numbers_temp

3410:
3411: SELECT fm_serial_number, to_serial_number
3412: BULK COLLECT INTO
3413: l_fm_serial_number, l_to_serial_number
3414: FROM mtl_serial_numbers_temp
3415: WHERE transaction_temp_id = l_mmtt_temp_id;
3416:
3417: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3418: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME, ' after allocation details');

Line 3454: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_mmtt_temp_id;

3450: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3451: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'Deleting from MSNT for transaction_temp_id='||l_mmtt_temp_id);
3452: END IF;
3453:
3454: DELETE FROM mtl_serial_numbers_temp WHERE transaction_temp_id = l_mmtt_temp_id;
3455:
3456: -- mark the newly passed serials. And insert them into MSNT.
3457: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3458: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'Marking the newly entered serial ranges');

Line 3484: INSERT INTO mtl_serial_numbers_temp

3480: if (L_LOG_STATEMENT >= L_LOG_CURRENT_LEVEL) then
3481: FND_LOG.STRING( L_LOG_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'|| L_API_NAME,'Inserting into msnt='||l_mmtt_temp_id);
3482: END IF;
3483:
3484: INSERT INTO mtl_serial_numbers_temp
3485: (transaction_temp_id,
3486: last_update_date,
3487: last_updated_by,
3488: creation_date,

Line 5935: || ' MTL_SERIAL_NUMBERS_TEMP MSNT,'

5931: || ' FROM PO_REQUISITION_HEADERS_ALL PRHA,'
5932: || ' OE_ORDER_HEADERS_ALL OOHA,'
5933: || ' MTL_SERIAL_NUMBERS MSN,'
5934: || ' CSI_ITEM_INSTANCES CSIII,'
5935: || ' MTL_SERIAL_NUMBERS_TEMP MSNT,'
5936: || ' WSH_DELIVERY_DETAILS WDD,'
5937: || ' WSH_SERIAL_NUMBERS WSN,'
5938: || ' AHL_MM_TXN_INTERFACE AMTI'
5939: || ' WHERE PRHA.REQUISITION_HEADER_ID = OOHA.SOURCE_DOCUMENT_ID'