71: ** (smallest tables first from right-hand side)
72: */
73: x_from_clause := 'JTF_TERR_USGS JTUA, ' ||
74: 'JTF_TERR_OVERVIEW_V JTOV, ' ||
75: 'JTF_SOURCES JSE ';
76:
77: /* build WHERE clause */
78: x_where_clause := ' WHERE JTUA.TERR_ID = JTOV.TERR_ID ' ||
79: ' AND JTUA.SOURCE_ID = JSE.SOURCE_ID ';
3226: , jtua.TERR_ID
3227: , jtua.SOURCE_ID
3228: , jtua.ORG_ID
3229: , jse.MEANING USAGE
3230: FROM JTF_TERR_USGS jtua, JTF_SOURCES jse
3231: WHERE jtua.terr_id = p_terr_id
3232: AND jtua.SOURCE_ID = jse.SOURCE_ID;
3233:
3234: /* return territory qualifier type usages and descriptions */