APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_MR_HEADERS_VL

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 2979: ahl_mr_headers_vl mrh,

2975: mrh.description mr_description,
2976: visit_task_number task_number,
2977: visit_task_name task_name
2978: from ahl_visit_tasks_vl tsk,
2979: ahl_mr_headers_vl mrh,
2980: AHL_VISITS_VL AVTS
2981: where MRH.MR_HEADER_ID = TSK.MR_ID
2982: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'
2983: AND AVTS.VISIT_ID = TSK.VISIT_ID