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_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_USGS_ALL

Line 779: jtf_qual_usgs_all jqua,

775: FROM jtf_terr_all jta,
776: jtf_terr_denorm_rules_all jtdr,
777: jtf_terr_qual_all jtqa,
778: jtf_terr_values_all jtva,
779: jtf_qual_usgs_all jqua,
780: jtf_qual_type_usgs_all jqtu,
781: jtf_qual_type_denorm_v inlv
782: WHERE jta.terr_id = cl_terr_id
783: AND jtdr.terr_id = jta.terr_id

Line 836: jtf_qual_usgs_all jqua,

832: FROM jtf_terr_all jta,
833: jtf_terr_denorm_rules_all jtdr,
834: jtf_terr_qual_all jtqa,
835: jtf_terr_values_all jtva,
836: jtf_qual_usgs_all jqua,
837: jtf_qual_type_usgs_all jqtu,
838: jtf_qual_type_denorm_v inlv,
839: jtf_terr_cnr_groups cnrg,
840: jtf_terr_cnr_group_values cnrgv

Line 899: jtf_qual_usgs_all jqua,

895: FROM jtf_terr_all jta,
896: jty_denorm_dea_rules_all jtdr,
897: jtf_terr_qual_all jtqa,
898: jtf_terr_values_all jtva,
899: jtf_qual_usgs_all jqua,
900: jtf_qual_type_usgs_all jqtu,
901: jtf_qual_type_denorm_v inlv
902: WHERE jta.terr_id = cl_terr_id
903: AND jtdr.terr_id = jta.terr_id

Line 953: jtf_qual_usgs_all jqua,

949: FROM jtf_terr_all jta,
950: jty_denorm_dea_rules_all jtdr,
951: jtf_terr_qual_all jtqa,
952: jtf_terr_values_all jtva,
953: jtf_qual_usgs_all jqua,
954: jtf_qual_type_usgs_all jqtu,
955: jtf_qual_type_denorm_v inlv,
956: jtf_terr_cnr_groups cnrg,
957: jtf_terr_cnr_group_values cnrgv

Line 1001: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;

997: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
998: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
999:
1000: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
1001: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;
1002: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;
1003: TYPE l_cop_tbl_type IS TABLE OF jtf_terr_values_all.comparison_operator%TYPE;
1004: TYPE l_lvc_id_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char_id%TYPE;
1005: TYPE l_lvc_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char%TYPE;

Line 1002: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;

998: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
999:
1000: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
1001: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;
1002: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;
1003: TYPE l_cop_tbl_type IS TABLE OF jtf_terr_values_all.comparison_operator%TYPE;
1004: TYPE l_lvc_id_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char_id%TYPE;
1005: TYPE l_lvc_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char%TYPE;
1006: TYPE l_hvc_tbl_type IS TABLE OF jtf_terr_values_all.high_value_char%TYPE;

Line 1018: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;

1014: TYPE l_value2_id_tbl_type IS TABLE OF jtf_terr_values_all.value2_id%TYPE;
1015: TYPE l_value3_id_tbl_type IS TABLE OF jtf_terr_values_all.value3_id%TYPE;
1016: TYPE l_value4_id_tbl_type IS TABLE OF jtf_terr_values_all.value4_id%TYPE;
1017: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1018: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1020: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1021: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1022: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;

Line 1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;

1015: TYPE l_value3_id_tbl_type IS TABLE OF jtf_terr_values_all.value3_id%TYPE;
1016: TYPE l_value4_id_tbl_type IS TABLE OF jtf_terr_values_all.value4_id%TYPE;
1017: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1018: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1019: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1020: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1021: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1022: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1023: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;

Line 2126: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3

2122: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
2123: WHERE o.terr_qual_id IN (
2124: SELECT /*+ INDEX (i2 jtf_qual_usgs_n3) */
2125: i1.terr_qual_id
2126: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
2127: WHERE i1.qual_usg_id = i2.qual_usg_id
2128: AND i2.display_type = 'CHAR'
2129: AND i2.lov_sql IS NULL
2130: AND i2.org_id = -3113