APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_VALUES

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 2788: l_from_clause := 'JTF_TERR_VALUES JTV, ' || l_from_clause;

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;
2789: l_where_clause := l_where_clause || ' AND JTV.TERR_QUAL_ID = JTQV.TERR_QUAL_ID ';
2790: END IF;
2791:
2792: --dbms_output.put_line('[7] l_where_clause = '|| l_where_clause);

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: