APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 942: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - START

938: END IF;
939: RAISE FND_API.G_EXC_ERROR;
940: END IF;
941:
942: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - START
943: l_trolin_tbl := l_to_line_tbl;
944:
945: IF (l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_unexp_error
946: AND l_trolin_tbl(i).return_status <> fnd_api.g_ret_sts_error) THEN

Line 958: --Data from MTL_MATERIAL_TRANSACTIONS_TEMP table

954:
955: IF NVL (l_qty_detailed, 0) = 0
956: THEN
957:
958: --Data from MTL_MATERIAL_TRANSACTIONS_TEMP table
959: l_mo_line_dtl_tbl := inv_mo_line_detail_util.query_rows (p_line_id => l_trolin_tbl(i).line_id);
960:
961: /*
962: Indicates if it has to be processed or just saved.

Line 982: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

978: inv_mo_line_detail_util.update_row (l_return_status, l_mo_line_dtl_tbl(i));
979:
980: SELECT transaction_header_id, transaction_quantity
981: INTO l_trolin_tbl(i).transaction_header_id, l_trolin_tbl(i).quantity_detailed
982: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
983: WHERE move_order_line_id = l_trolin_tbl(i).line_id;
984:
985: l_trolin_tbl(i).last_update_date := SYSDATE;
986: l_trolin_tbl(i).last_update_login := fnd_global.login_id;

Line 998: --Update MTL_TXN_REQUEST_LINES and MTL_MATERIAL_TRANSACTIONS_TEMP tables - END

994:
995: END IF; --IF NVL (l_qty_detailed, 0) = 0
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

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 3287: mtl_material_transactions_temp mmtt

3283: l_move_order_line_id,G_DELIVERY_DETAIL_ID
3284: FROM wsh_delivery_details wdd,
3285: mtl_txn_request_headers mtrh,
3286: mtl_txn_request_lines mtrl,
3287: mtl_material_transactions_temp mmtt
3288: WHERE wdd.source_header_id = p_order_header_id
3289: AND wdd.move_order_line_id = mtrl.line_id
3290: AND mtrl.header_id = mtrh.header_id
3291: AND MTRL.LINE_ID = MMTT.MOVE_ORDER_LINE_ID(+)