APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 3002: FROM mtl_system_items_kfv mtl,hr_organization_units hou,inv_organization_info_v org

2998: SELECT mtl.CONCATENATED_SEGMENTS,
2999: mtl.DESCRIPTION,
3000: mtl.organization_id INVENTORY_ORG_ID,
3001: hou.name organization_name
3002: FROM mtl_system_items_kfv mtl,hr_organization_units hou,inv_organization_info_v org
3003: WHERE mtl.organization_id = org.organization_id
3004: AND hou.organization_id = org.organization_id
3005: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) =mo_global.get_current_org_id()
3006: AND mtl.inventory_item_id=c_item_id