eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_QUALIFIERS_V

Line 2757: l_from_clause := 'JTF_TERR_QUALIFIERS_V JTQV, ' || l_from_clause;

2753: END LOOP;
2754: END IF;
2755:
2756: IF ( l_use_terr_qual_flag = 'Y' ) THEN
2757: l_from_clause := 'JTF_TERR_QUALIFIERS_V JTQV, ' || l_from_clause;
2758: l_where_clause := l_where_clause || ' AND JTQV.TERR_ID = JTOV.TERR_ID ';
2759: END IF;
2760:
2761:

Line 2784: l_from_clause := 'JTF_TERR_QUALIFIERS_V JTQV, ' || l_from_clause;

2780: /* join jtf_terr_qualifiers with jtf_terr
2781: ** and then jtf_terr_values with jtf_terr_qualifiers
2782: */
2783: IF ( l_use_terr_qual_flag <> 'Y' ) THEN
2784: l_from_clause := 'JTF_TERR_QUALIFIERS_V JTQV, ' || l_from_clause;
2785: l_where_clause := l_where_clause || ' AND JTQV.TERR_ID = JTOV.TERR_ID ';
2786: END IF;
2787:
2788: l_from_clause := 'JTF_TERR_VALUES JTV, ' || l_from_clause;

Line 3277: FROM JTF_TERR_QUALIFIERS_V jtqv

3273: , jtqv.QUAL_TYPE_ID
3274: , jtqv.QUALIFIER_TYPE_NAME
3275: , jtqv.QUALIFIER_TYPE_DESCRIPTION
3276: , jtqv.QUALIFIER_NAME
3277: FROM JTF_TERR_QUALIFIERS_V jtqv
3278: WHERE jtqv.terr_id = p_terr_id;
3279:
3280: /* return territory qualifier values */
3281: CURSOR get_terr_values ( p_terr_id NUMBER) IS