APPS.AHL_REPORT_UTILS_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1062: SELECT concatenated_segments INTO x_position FROM mtl_item_locations_kfv k WHERE inventory_location_id = (SELECT INV_LOCATOR_ID FROM csi_item_instances WHERE instance_id = P_INSTANCE_ID);

1058: IF(l_position_ref_cd IS NOT NULL) THEN
1059: SELECT meaning INTO x_position FROM fnd_lookups fnd WHERE fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND fnd.lookup_code = l_position_ref_cd;
1060: END IF;
1061: IF(x_position IS NULL) THEN
1062: SELECT concatenated_segments INTO x_position FROM mtl_item_locations_kfv k WHERE inventory_location_id = (SELECT INV_LOCATOR_ID FROM csi_item_instances WHERE instance_id = P_INSTANCE_ID);
1063: END IF;
1064: RETURN x_position;
1065: END Get_Position;
1066: