APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_MR_ROUTES_V

Line 148: FROM ahl_mr_routes_v mr, ahl_mr_headers_v mh

144:
145: -- AnRaj: Query changed for fixing performance bug 4919475
146: -- Get Billing item id for the associated mr
147: /* SELECT mh.billing_item_id,mh.billing_item, mh.title
148: FROM ahl_mr_routes_v mr, ahl_mr_headers_v mh
149: WHERE mr.mr_header_id = mh.mr_header_id
150: AND mr.mr_header_id =C_MR_ID;*/
151: CURSOR Get_billing_item_cur (C_MR_ID IN NUMBER)
152: IS

Line 154: FROM ahl_mr_routes_v mr, AHL_MR_HEADERS_VL mh,MTL_SYSTEM_ITEMS_KFV mtl

150: AND mr.mr_header_id =C_MR_ID;*/
151: CURSOR Get_billing_item_cur (C_MR_ID IN NUMBER)
152: IS
153: SELECT mh.billing_item_id,mtl.CONCATENATED_SEGMENTS billing_item, mh.title
154: FROM ahl_mr_routes_v mr, AHL_MR_HEADERS_VL mh,MTL_SYSTEM_ITEMS_KFV mtl
155: WHERE mr.mr_header_id = mh.mr_header_id
156: AND mtl.INVENTORY_ITEM_ID= MH.BILLING_ITEM_ID
157: AND mr.mr_header_id = C_MR_ID
158: AND mh.APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;

Line 2044: FROM ahl_mr_routes_v

2040: IF (l_cost_price_rec.mr_id IS NOT NULL AND l_visit_task_dtls_rec.mr_route_id IS NOT NULL )THEN
2041:
2042: -- Retrieve route id
2043: SELECT ROUTE_ID INTO l_route_id
2044: FROM ahl_mr_routes_v
2045: WHERE mr_route_id = l_visit_task_dtls_rec.mr_route_id;
2046:
2047: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2048: fnd_log.string

Line 3684: From ahl_mr_Routes_v

3680:
3681: Cursor c_mr_route_csr(c_mr_route_id in number)
3682: Is
3683: Select mr_route_id,route_id
3684: From ahl_mr_Routes_v
3685: where mr_route_id=c_mr_route_id;
3686:
3687: l_mr_route_rec c_mr_route_csr%rowtype;
3688: