APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_TXN_REQUEST_LINES

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 948: --Data from MTL_TXN_REQUEST_LINES table

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
947:
948: --Data from MTL_TXN_REQUEST_LINES table
949: l_trolin_rec := inv_trolin_util.query_row (l_trolin_tbl(i).line_id);
950: l_trolin_tbl(i) := l_trolin_rec;
951:
952: --Quantity which has detailed sourcing location

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 3286: mtl_txn_request_lines mtrl,

3282: INTO l_move_order_hdr_id,l_mmtt_temp_id,
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

Line 3371: mtl_txn_request_lines mtrl

3367: msi.organization_id
3368: INTO l_reservable_flag,l_item_id,
3369: l_org_id
3370: FROM mtl_system_items_b msi,
3371: mtl_txn_request_lines mtrl
3372: WHERE mtrl.inventory_item_id = msi.inventory_item_id
3373: AND mtrl.organization_id = msi.organization_id
3374: AND mtrl.line_id = l_move_order_line_id;
3375: