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_QUAL

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 2780: /* join jtf_terr_qualifiers with jtf_terr

2776: END IF;
2777:
2778: IF ( l_use_terr_values_flag = 'Y' ) THEN
2779:
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;

Line 2781: ** and then jtf_terr_values with jtf_terr_qualifiers

2777:
2778: IF ( l_use_terr_values_flag = 'Y' ) THEN
2779:
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 ';

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

Line 3304: FROM JTF_TERR_VALUES j1, JTF_TERR_QUAL j2, JTF_QUAL_USGS j3

3300: , j1.PRIMARY_INTEREST_CODE_ID
3301: , j1.SECONDARY_INTEREST_CODE_ID
3302: , j1.CURRENCY_CODE
3303: , j1.ORG_ID
3304: FROM JTF_TERR_VALUES j1, JTF_TERR_QUAL j2, JTF_QUAL_USGS j3
3305: WHERE j1.terr_qual_id = j2.terr_qual_id
3306: AND j2.terr_id = p_terr_id
3307: AND j3.qual_usg_id = j2.qual_usg_id;
3308: