APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_POSITION_ALTERNATES_V

Line 4009: -- new query uses view ahl_position_alternates_v

4005:
4006: CURSOR get_position_path ( c_position_path_id NUMBER , c_item_comp_detail_id NUMBER)
4007: IS
4008:
4009: -- new query uses view ahl_position_alternates_v
4010: --AMSRINIV. Bug 5208104. Replacing below commented query with a new query for better performance
4011: select distinct mtl.concatenated_segments,
4012: mtl.organization_code
4013: from (select kfv.inventory_item_id,

Line 4026: from ahl_position_alternates_v

4022: where mp1.master_organization_id = kfv.organization_id
4023: and mp1.eam_enabled_flag = 'Y')) mtl,
4024: (select inventory_item_id,
4025: inventory_org_id
4026: from ahl_position_alternates_v
4027: where relationship_id = c_position_path_id) pal,
4028: (select item_composition_id,
4029: item_comp_detail_id
4030: from ahl_item_comp_details

Line 4053: ahl_position_alternates_v pal,

4049: mtl.concatenated_segments ,
4050: mtl.organization_code
4051: from
4052: ahl_mtl_items_non_ou_v mtl,
4053: ahl_position_alternates_v pal,
4054: AHL_ITEM_COMP_V CD ,
4055: AHL_ITEM_COMP_DETAILS ICD
4056: where
4057: pal.relationship_id = nvl(c_position_path_id,'-1')