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 863: jtf_qual_usgs_all jqua,

859: FROM jtf_terr_all jta,
860: jtf_terr_denorm_rules_all jtdr,
861: jtf_terr_qual_all jtqa,
862: jtf_terr_values_all jtva,
863: jtf_qual_usgs_all jqua,
864: jtf_qual_type_usgs_all jqtu,
865: jtf_qual_type_denorm_v inlv
866: WHERE jta.terr_id = cl_terr_id
867: AND jtdr.terr_id = jta.terr_id

Line 920: jtf_qual_usgs_all jqua,

916: FROM jtf_terr_all jta,
917: jtf_terr_denorm_rules_all jtdr,
918: jtf_terr_qual_all jtqa,
919: jtf_terr_values_all jtva,
920: jtf_qual_usgs_all jqua,
921: jtf_qual_type_usgs_all jqtu,
922: jtf_qual_type_denorm_v inlv,
923: jtf_terr_cnr_groups cnrg,
924: jtf_terr_cnr_group_values cnrgv

Line 983: jtf_qual_usgs_all jqua,

979: FROM jtf_terr_all jta,
980: jty_denorm_dea_rules_all jtdr,
981: jtf_terr_qual_all jtqa,
982: jtf_terr_values_all jtva,
983: jtf_qual_usgs_all jqua,
984: jtf_qual_type_usgs_all jqtu,
985: jtf_qual_type_denorm_v inlv
986: WHERE jta.terr_id = cl_terr_id
987: AND jtdr.terr_id = jta.terr_id

Line 1037: jtf_qual_usgs_all jqua,

1033: FROM jtf_terr_all jta,
1034: jty_denorm_dea_rules_all jtdr,
1035: jtf_terr_qual_all jtqa,
1036: jtf_terr_values_all jtva,
1037: jtf_qual_usgs_all jqua,
1038: jtf_qual_type_usgs_all jqtu,
1039: jtf_qual_type_denorm_v inlv,
1040: jtf_terr_cnr_groups cnrg,
1041: jtf_terr_cnr_group_values cnrgv

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

1094: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
1095: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
1096:
1097: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
1098: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;
1099: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;
1100: TYPE l_cop_tbl_type IS TABLE OF jtf_terr_values_all.comparison_operator%TYPE;
1101: TYPE l_lvc_id_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char_id%TYPE;
1102: TYPE l_lvc_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char%TYPE;

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

1095: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
1096:
1097: TYPE l_qual_type_id_tbl_type IS TABLE OF jtf_qual_type_usgs_all.qual_type_id%TYPE;
1098: TYPE l_qual_usg_id_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_usg_id%TYPE;
1099: TYPE l_qual_rel_fac_tbl_type IS TABLE OF jtf_qual_usgs_all.qual_relation_factor%TYPE;
1100: TYPE l_cop_tbl_type IS TABLE OF jtf_terr_values_all.comparison_operator%TYPE;
1101: TYPE l_lvc_id_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char_id%TYPE;
1102: TYPE l_lvc_tbl_type IS TABLE OF jtf_terr_values_all.low_value_char%TYPE;
1103: TYPE l_hvc_tbl_type IS TABLE OF jtf_terr_values_all.high_value_char%TYPE;

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

1111: TYPE l_value2_id_tbl_type IS TABLE OF jtf_terr_values_all.value2_id%TYPE;
1112: TYPE l_value3_id_tbl_type IS TABLE OF jtf_terr_values_all.value3_id%TYPE;
1113: TYPE l_value4_id_tbl_type IS TABLE OF jtf_terr_values_all.value4_id%TYPE;
1114: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1115: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1116: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;

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

1112: TYPE l_value3_id_tbl_type IS TABLE OF jtf_terr_values_all.value3_id%TYPE;
1113: TYPE l_value4_id_tbl_type IS TABLE OF jtf_terr_values_all.value4_id%TYPE;
1114: TYPE l_fc_tbl_type IS TABLE OF jtf_terr_values_all.first_char%TYPE;
1115: TYPE l_update_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.update_attr_val_stmt%TYPE;
1116: TYPE l_insert_stmt_tbl_type IS TABLE OF jtf_qual_usgs_all.insert_attr_val_stmt%TYPE;
1117: TYPE l_top_lvl_terr_id_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.top_level_terr_id%TYPE;
1118: TYPE l_abs_rank_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.absolute_rank%TYPE;
1119: TYPE l_start_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.start_date%TYPE;
1120: TYPE l_end_date_tbl_type IS TABLE OF jtf_terr_denorm_rules_all.end_date%TYPE;

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

2247: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
2248: WHERE o.terr_qual_id IN (
2249: SELECT /*+ INDEX (i2 jtf_qual_usgs_n3) */
2250: i1.terr_qual_id
2251: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
2252: WHERE i1.qual_usg_id = i2.qual_usg_id
2253: AND i2.display_type = 'CHAR'
2254: AND i2.lov_sql IS NULL
2255: AND i2.org_id = -3113