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 201: jtf_terr_qual_all jtq

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)
205: AND jtq.org_id = p_org_id

Line 210: jtf_terr_qual_all jtq,

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
214: AND jtq.org_id = p_org_id

Line 727: jtf_terr_qual_all jtq

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
731: AND qgt.user_sequence = p_user_sequence