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.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_TERR_QUAL_ALL

Line 208: jtf_terr_qual_all jtq

204: decode(l_qual_num, 24, geography_name, NULL) qual24_value1,
205: decode(l_qual_num, 25, geography_name, NULL) qual25_value1
206: FROM hz_geographies hzg,
207: jtf_terr_values_all qv,
208: jtf_terr_qual_all jtq
209: WHERE hzg.geography_type = l_qual_name
210: AND jtq.terr_qual_id = qv.terr_qual_id
211: AND qv.low_value_char IN(geography_element1_code, geography_element2_code, geography_element3_code, geography_element4_code, geography_element5_code)
212: AND jtq.org_id = p_org_id

Line 217: jtf_terr_qual_all jtq,

213: AND jtq.terr_id = p_terr_id
214: AND NOT EXISTS
215: (SELECT 1
216: FROM jtf_terr_values_all qv,
217: jtf_terr_qual_all jtq,
218: jtf_terr_all terr
219: WHERE hzg.geography_name = qv.low_value_char
220: AND jtq.terr_qual_id = qv.terr_qual_id
221: AND jtq.org_id = p_org_id

Line 1182: jtf_terr_qual_all jtq

1178: qgt.display_sql2, jtva.currency_code, NULL), NULL) qual_value3,
1179: NULL qual_value4
1180: FROM jty_webadi_qual_header qgt,
1181: jtf_terr_values_all jtva,
1182: jtf_terr_qual_all jtq
1183: WHERE qgt.qual_usg_id = jtq.qual_usg_id
1184: AND jtq.terr_qual_id = jtva.terr_qual_id --AND qgt.qualifier_num = 1
1185: AND jtq.org_id = p_org_id
1186: AND qgt.user_sequence = p_user_sequence