APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_POSITION_ALTERNATES_V

Line 3710: -- new query uses view ahl_position_alternates_v

3706:
3707: CURSOR get_position_path ( c_position_path_id NUMBER , c_item_comp_detail_id NUMBER)
3708: IS
3709:
3710: -- new query uses view ahl_position_alternates_v
3711: --AMSRINIV. Bug 5208104. Replacing below commented query with a new query for better performance
3712: select distinct mtl.concatenated_segments,
3713: mtl.organization_code
3714: from (select kfv.inventory_item_id,

Line 3727: from ahl_position_alternates_v

3723: where mp1.master_organization_id = kfv.organization_id
3724: and mp1.eam_enabled_flag = 'Y')) mtl,
3725: (select inventory_item_id,
3726: inventory_org_id
3727: from ahl_position_alternates_v
3728: where relationship_id = c_position_path_id) pal,
3729: (select item_composition_id,
3730: item_comp_detail_id
3731: from ahl_item_comp_details

Line 3754: ahl_position_alternates_v pal,

3750: mtl.concatenated_segments ,
3751: mtl.organization_code
3752: from
3753: ahl_mtl_items_non_ou_v mtl,
3754: ahl_position_alternates_v pal,
3755: AHL_ITEM_COMP_V CD ,
3756: AHL_ITEM_COMP_DETAILS ICD
3757: where
3758: pal.relationship_id = nvl(c_position_path_id,'-1')