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

Line 815: FROM MTL_SERIAL_NUMBERS

811:
812: --Get the reservation ID for the serial to be moved, if any
813: SELECT reservation_id
814: INTO l_old_rsrv_id
815: FROM MTL_SERIAL_NUMBERS
816: WHERE inventory_item_id = l_inv_item_id
817: AND serial_number = p_supply_tbl_type(i).Serial_Number;
818:
819: --Delete the reservation if it is there already, as Move Order is of high priority

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 4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;

4439: l_error_msg VARCHAR2(240);
4440: l_error_code VARCHAR2(240);
4441:
4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;
4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;
4444: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4445:
4446: -- Record Type variables
4447: l_x_mtltfr_rec Ahl_Mtltfr_Rec_Type; -- record type variable for storing each item record

Line 4459: MTL_SERIAL_NUMBERS_INTERFACE sni

4455: kfv.concatenated_segments,
4456: sni.FM_SERIAL_NUMBER
4457: FROM MTL_TRANSACTIONS_INTERFACE INTF,
4458: mtl_system_items_kfv kfv,
4459: MTL_SERIAL_NUMBERS_INTERFACE sni
4460: WHERE intf.TRANSACTION_INTERFACE_ID = p_txn_Id
4461: AND intf.inventory_item_id = kfv.inventory_item_id
4462: AND intf.organization_id = kfv.organization_id
4463: AND intf.TRANSACTION_INTERFACE_ID = sni.transaction_interface_id;

Line 4803: FROM mtl_serial_numbers

4799: N_ATTRIBUTE7,
4800: N_ATTRIBUTE8,
4801: N_ATTRIBUTE9,
4802: N_ATTRIBUTE10
4803: FROM mtl_serial_numbers
4804: WHERE inventory_item_id = p_inv_item_id
4805: AND serial_number = p_serial_number;
4806:
4807: l_serial_dff_rec get_serial_dff_attrib%ROWTYPE;

Line 4907: INTO MTL_SERIAL_NUMBERS_INTERFACE

4903: CLOSE get_serial_dff_attrib;
4904:
4905: G_DEBUG_LINE_NUM := 250;
4906: INSERT
4907: INTO MTL_SERIAL_NUMBERS_INTERFACE
4908: (
4909: TRANSACTION_INTERFACE_ID,
4910: SOURCE_CODE,
4911: SOURCE_LINE_ID,

Line 5191: FROM MTL_SERIAL_NUMBERS

5187: -- Reservation validation
5188: CURSOR RESERVATION_VALID_CUR (p_org_id NUMBER, p_item NUMBER, p_serial_num VARCHAR2)
5189: IS
5190: SELECT 1
5191: FROM MTL_SERIAL_NUMBERS
5192: WHERE INVENTORY_ITEM_ID = p_item
5193: AND CURRENT_ORGANIZATION_ID = p_org_id
5194: AND SERIAL_NUMBER = p_serial_num
5195: AND RESERVATION_ID IS NOT NULL;

Line 5654: ' mtl_serial_numbers SERIALS' ||

5650: ' INSERT INTO AHL_APPLICABLE_INSTANCES(CSI_ITEM_INSTANCE_ID, POSITION_ID)' ||
5651: ' SELECT UNIQUE INST.instance_id, -1' ||
5652: ' FROM mtl_system_items_b ITEMS,' ||
5653: ' csi_item_instances INST,' ||
5654: ' mtl_serial_numbers SERIALS' ||
5655: ' WHERE ITEMS.inventory_item_id = INST.inventory_item_id' ||
5656: ' AND ITEMS.organization_id = INST.inv_master_organization_id' ||
5657: ' AND INST.serial_number = SERIALS.serial_number' ||
5658: ' AND INST.inventory_item_id = SERIALS.inventory_item_id' ||

Line 5918: || ' MTL_SERIAL_NUMBERS MSN,'

5914: --Base criteria for existing reservations
5915: l_base_query := l_base_query || ' AND SERIALS.serial_number IN'
5916: || ' (SELECT UNIQUE NVL(MSN.SERIAL_NUMBER, NVL(WO_RESERV.SERIAL_NUMBER, ISO_RESERV.SERIAL_NUMBER))'
5917: || ' FROM MTL_RESERVATIONS MR,'
5918: || ' MTL_SERIAL_NUMBERS MSN,'
5919: || ' (SELECT CSIII.serial_number,'
5920: || ' WO.WIP_ENTITY_ID'
5921: || ' FROM AHL_WORKORDERS WO,'
5922: || ' AHL_VISIT_TASKS_B ATSK,'

Line 5933: || ' MTL_SERIAL_NUMBERS MSN,'

5929: || ' AND CSIII.instance_id = NVL(ATSK.instance_id, AVST.item_instance_id)) WO_RESERV,'
5930: || ' (SELECT CSIII.SERIAL_NUMBER, CSIII.INVENTORY_ITEM_ID, PRHA.REQUISITION_HEADER_ID, AMTI.RESERVATION_ID'
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,'

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'