APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_TERR_VALUES_ALL

Line 200: jtf_terr_values_all qv,

196: decode(l_qual_num, 23, geography_name, NULL) qual23_value1,
197: decode(l_qual_num, 24, geography_name, NULL) qual24_value1,
198: decode(l_qual_num, 25, geography_name, NULL) qual25_value1
199: FROM hz_geographies hzg,
200: jtf_terr_values_all qv,
201: jtf_terr_qual_all jtq
202: WHERE hzg.geography_type = l_qual_name
203: AND jtq.terr_qual_id = qv.terr_qual_id
204: AND qv.low_value_char IN(geography_element1_code, geography_element2_code, geography_element3_code, geography_element4_code, geography_element5_code)

Line 209: FROM jtf_terr_values_all qv,

205: AND jtq.org_id = p_org_id
206: AND jtq.terr_id = p_terr_id
207: AND NOT EXISTS
208: (SELECT 1
209: FROM jtf_terr_values_all qv,
210: jtf_terr_qual_all jtq,
211: jtf_terr_all terr
212: WHERE hzg.geography_name = qv.low_value_char
213: AND jtq.terr_qual_id = qv.terr_qual_id

Line 726: jtf_terr_values_all jtva,

722: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
723: qgt.display_sql2, jtva.currency_code, NULL), NULL) qual_value3,
724: NULL qual_value4
725: FROM jty_webadi_qual_header qgt,
726: jtf_terr_values_all jtva,
727: jtf_terr_qual_all jtq
728: WHERE qgt.qual_usg_id = jtq.qual_usg_id
729: AND jtq.terr_qual_id = jtva.terr_qual_id --AND qgt.qualifier_num = 1
730: AND jtq.org_id = p_org_id