APPS.JTF_TERRITORY_GET_PUB dependencies on JTF_TERR_TRANSACTIONS_V

Line 2734: -- l_from_clause := 'JTF_TERR_TRANSACTIONS_V JTTV, ' || l_from_clause;

2730: -- END LOOP;
2731: --END IF;
2732: --
2733: --IF ( l_use_terr_qtype_usg_flag = 'Y' ) THEN
2734: -- l_from_clause := 'JTF_TERR_TRANSACTIONS_V JTTV, ' || l_from_clause;
2735: -- l_where_clause := l_where_clause || ' AND JTTV.TERR_ID = JTOV.TERR_ID ';
2736: --END IF;
2737:
2738: --dbms_output.put_line('[5] l_where_clause = '|| l_where_clause);

Line 3250: FROM JTF_TERR_TRANSACTIONS_V jttv

3246: , jttv.SOURCE_ID
3247: , jttv.QUAL_TYPE_ID
3248: , jttv.QUALIFIER_TYPE_NAME
3249: , jttv.QUALIFIER_TYPE_DESCRIPTION
3250: FROM JTF_TERR_TRANSACTIONS_V jttv
3251: WHERE jttv.terr_id = p_terr_id;
3252:
3253:
3254: /* return territory qualifiers and descriptions */