diff -r 1adc9a58e28a src-db/database/model/functions/C_LOCATION_IDENTIFIER.xml
--- a/src-db/database/model/functions/C_LOCATION_IDENTIFIER.xml	Fri Jan 22 14:10:36 2016 +0000
+++ b/src-db/database/model/functions/C_LOCATION_IDENTIFIER.xml	Mon Feb 22 13:02:04 2016 +0100
@@ -64,11 +64,9 @@
     END
     )
   INTO v_description
-  FROM C_REGION R
-  LEFT JOIN C_COUNTRY C
-    ON R.C_COUNTRY_ID = C.C_COUNTRY_ID
-  RIGHT JOIN C_LOCATION L
-    ON L.C_REGION_ID = R.C_REGION_ID
+  FROM  C_LOCATION L
+	  LEFT JOIN C_COUNTRY C ON C.C_COUNTRY_ID = L.C_COUNTRY_ID
+	  LEFT JOIN C_REGION R ON R.C_REGION_ID = L.C_REGION_ID
   WHERE L.C_LOCATION_ID = p_C_Location_ID;
   RETURN v_description;
 END C_LOCATION_IDENTIFIER