APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_OVERVIEW_V

Line 74: 'JTF_TERR_OVERVIEW_V JTOV, ' ||

70: /* build initial part of FROM clause
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 ' ||

Line 3122: FROM JTF_TERR_OVERVIEW_V jtov

3118: , jtov.TEMPLATE_TERR_NAME
3119: , jtov.TERR_USG_ID
3120: , jtov.SOURCE_ID
3121: , jtov.TERR_USAGE
3122: FROM JTF_TERR_OVERVIEW_V jtov
3123: WHERE jtov.TERR_ID = p_terr_id;
3124:
3125: /* return territory type */
3126: CURSOR get_terr_type ( p_terr_type_id NUMBER ) IS

Line 3214: FROM JTF_TERR_OVERVIEW_V jtov

3210: , jtov.TEMPLATE_TERR_NAME
3211: , jtov.TERR_USG_ID
3212: , jtov.SOURCE_ID
3213: , jtov.TERR_USAGE
3214: FROM JTF_TERR_OVERVIEW_V jtov
3215: WHERE jtov.parent_territory_id = p_terr_id;
3216:
3217: /* return territory usages */
3218: CURSOR get_terr_usgs ( p_terr_id NUMBER) IS