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_TERRITORY_PVT

Line 682: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

678: ORDER BY rownum) row_id,
679: jtva.terr_value_id,
680: qgt.qualifier_num,
681: decode(qgt.display_type, 'CHAR', decode(qgt.convert_to_id_flag, 'Y',
682: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
683: qgt.display_sql1, jtva.low_value_char_id, NULL), 'N',
684: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
685: qgt.display_sql1, jtva.low_value_char, NULL), NULL), 'CHAR_2IDS',
686: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 684: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

680: qgt.qualifier_num,
681: decode(qgt.display_type, 'CHAR', decode(qgt.convert_to_id_flag, 'Y',
682: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
683: qgt.display_sql1, jtva.low_value_char_id, NULL), 'N',
684: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
685: qgt.display_sql1, jtva.low_value_char, NULL), NULL), 'CHAR_2IDS',
686: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
687: qgt.display_sql1, jtva.value1_id, jtva.value2_id), 'DEP_2FIELDS',
688: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 686: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

682: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
683: qgt.display_sql1, jtva.low_value_char_id, NULL), 'N',
684: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
685: qgt.display_sql1, jtva.low_value_char, NULL), NULL), 'CHAR_2IDS',
686: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
687: qgt.display_sql1, jtva.value1_id, jtva.value2_id), 'DEP_2FIELDS',
688: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
689: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
690: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 688: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

684: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
685: qgt.display_sql1, jtva.low_value_char, NULL), NULL), 'CHAR_2IDS',
686: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
687: qgt.display_sql1, jtva.value1_id, jtva.value2_id), 'DEP_2FIELDS',
688: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
689: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
690: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
691: qgt.display_sql1, jtva.low_value_char, NULL), 'DEP_2FIELDS_CHAR_2IDS',
692: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 690: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

686: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
687: qgt.display_sql1, jtva.value1_id, jtva.value2_id), 'DEP_2FIELDS',
688: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
689: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
690: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
691: qgt.display_sql1, jtva.low_value_char, NULL), 'DEP_2FIELDS_CHAR_2IDS',
692: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
693: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS',
694: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 692: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

688: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
689: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
690: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
691: qgt.display_sql1, jtva.low_value_char, NULL), 'DEP_2FIELDS_CHAR_2IDS',
692: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
693: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS',
694: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
695: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
696: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 694: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

690: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
691: qgt.display_sql1, jtva.low_value_char, NULL), 'DEP_2FIELDS_CHAR_2IDS',
692: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
693: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS',
694: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
695: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
696: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
697: qgt.display_sql1, jtva.value1_id, -9999), 'INTEREST_TYPE',
698: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 696: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

692: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
693: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS',
694: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
695: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
696: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
697: qgt.display_sql1, jtva.value1_id, -9999), 'INTEREST_TYPE',
698: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
699: qgt.display_sql1, jtva.interest_type_id, NULL), 'NUMERIC', jtva.low_value_number, 'CURRENCY',
700: jtva.low_value_number, NULL) qual_value1,

Line 698: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

694: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
695: qgt.display_sql1, jtva.value1_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
696: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
697: qgt.display_sql1, jtva.value1_id, -9999), 'INTEREST_TYPE',
698: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
699: qgt.display_sql1, jtva.interest_type_id, NULL), 'NUMERIC', jtva.low_value_number, 'CURRENCY',
700: jtva.low_value_number, NULL) qual_value1,
701: decode(qgt.display_type, 'CHAR', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
702: qgt.display_type, NULL, qgt.display_sql2, jtva.high_value_char, NULL), 'CHAR_2IDS', NULL,

Line 701: decode(qgt.display_type, 'CHAR', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,

697: qgt.display_sql1, jtva.value1_id, -9999), 'INTEREST_TYPE',
698: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
699: qgt.display_sql1, jtva.interest_type_id, NULL), 'NUMERIC', jtva.low_value_number, 'CURRENCY',
700: jtva.low_value_number, NULL) qual_value1,
701: decode(qgt.display_type, 'CHAR', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
702: qgt.display_type, NULL, qgt.display_sql2, jtva.high_value_char, NULL), 'CHAR_2IDS', NULL,
703: 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
704: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
705: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 703: 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

699: qgt.display_sql1, jtva.interest_type_id, NULL), 'NUMERIC', jtva.low_value_number, 'CURRENCY',
700: jtva.low_value_number, NULL) qual_value1,
701: decode(qgt.display_type, 'CHAR', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
702: qgt.display_type, NULL, qgt.display_sql2, jtva.high_value_char, NULL), 'CHAR_2IDS', NULL,
703: 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
704: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
705: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
706: qgt.display_sql2, jtva.low_value_char_id, NULL), 'DEP_2FIELDS_CHAR_2IDS',
707: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 705: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

701: decode(qgt.display_type, 'CHAR', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
702: qgt.display_type, NULL, qgt.display_sql2, jtva.high_value_char, NULL), 'CHAR_2IDS', NULL,
703: 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
704: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
705: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
706: qgt.display_sql2, jtva.low_value_char_id, NULL), 'DEP_2FIELDS_CHAR_2IDS',
707: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
708: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS',
709: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 707: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

703: 'DEP_2FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
704: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_2FIELDS_1CHAR_1ID',
705: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
706: qgt.display_sql2, jtva.low_value_char_id, NULL), 'DEP_2FIELDS_CHAR_2IDS',
707: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
708: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS',
709: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
710: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
711: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 709: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

705: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
706: qgt.display_sql2, jtva.low_value_char_id, NULL), 'DEP_2FIELDS_CHAR_2IDS',
707: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
708: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS',
709: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
710: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
711: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
712: qgt.display_sql2, jtva.value2_id, -9999), 'INTEREST_TYPE',
713: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 711: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

707: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
708: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS',
709: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
710: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
711: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
712: qgt.display_sql2, jtva.value2_id, -9999), 'INTEREST_TYPE',
713: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
714: qgt.display_sql2, jtva.primary_interest_code_id, NULL), 'NUMERIC', jtva.high_value_number,
715: 'CURRENCY', jtva.high_value_number, NULL) qual_value2,

Line 713: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

709: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
710: qgt.display_sql2, jtva.value2_id, -9999), 'DEP_3FIELDS_CHAR_3IDS',
711: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
712: qgt.display_sql2, jtva.value2_id, -9999), 'INTEREST_TYPE',
713: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
714: qgt.display_sql2, jtva.primary_interest_code_id, NULL), 'NUMERIC', jtva.high_value_number,
715: 'CURRENCY', jtva.high_value_number, NULL) qual_value2,
716: decode(qgt.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
717: qgt.display_type, NULL, qgt.display_sql3, jtva.value3_id, NULL), 'DEP_3FIELDS_CHAR_3IDS',

Line 716: decode(qgt.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,

712: qgt.display_sql2, jtva.value2_id, -9999), 'INTEREST_TYPE',
713: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
714: qgt.display_sql2, jtva.primary_interest_code_id, NULL), 'NUMERIC', jtva.high_value_number,
715: 'CURRENCY', jtva.high_value_number, NULL) qual_value2,
716: decode(qgt.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
717: qgt.display_type, NULL, qgt.display_sql3, jtva.value3_id, NULL), 'DEP_3FIELDS_CHAR_3IDS',
718: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
719: qgt.display_sql3, jtva.value3_id, jtva.value4_id), 'INTEREST_TYPE',
720: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 718: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

714: qgt.display_sql2, jtva.primary_interest_code_id, NULL), 'NUMERIC', jtva.high_value_number,
715: 'CURRENCY', jtva.high_value_number, NULL) qual_value2,
716: decode(qgt.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
717: qgt.display_type, NULL, qgt.display_sql3, jtva.value3_id, NULL), 'DEP_3FIELDS_CHAR_3IDS',
718: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
719: qgt.display_sql3, jtva.value3_id, jtva.value4_id), 'INTEREST_TYPE',
720: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
721: qgt.display_sql3, jtva.secondary_interest_code_id, NULL), 'CURRENCY',
722: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

Line 720: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

716: decode(qgt.display_type, 'DEP_3FIELDS', jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag,
717: qgt.display_type, NULL, qgt.display_sql3, jtva.value3_id, NULL), 'DEP_3FIELDS_CHAR_3IDS',
718: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
719: qgt.display_sql3, jtva.value3_id, jtva.value4_id), 'INTEREST_TYPE',
720: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
721: qgt.display_sql3, jtva.secondary_interest_code_id, NULL), 'CURRENCY',
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

Line 722: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,

718: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
719: qgt.display_sql3, jtva.value3_id, jtva.value4_id), 'INTEREST_TYPE',
720: jtf_territory_pvt.get_terr_value_desc(qgt.convert_to_id_flag, qgt.display_type, NULL,
721: qgt.display_sql3, jtva.secondary_interest_code_id, NULL), 'CURRENCY',
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,