The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT qual_type_usg_id
INTO l_qual_type_usg_id
FROM jtf_qual_type_usgs_all
WHERE source_id = p_source_id
AND qual_type_id = p_trans_id;
SELECT count(*)
INTO l_no_of_records
FROM jty_terr_values_idx_header
WHERE source_id = p_source_id
AND qual_usg_id = p_qual_usg_id_tbl(i);
SELECT jty_terr_values_idx_header_s.nextval
INTO l_header_seq
FROM dual;
SELECT 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' ||
(nvl(max(to_number(substr(index_name, instr(index_name, '_RN')+3))), 0) + 1)
INTO l_index_name
FROM jty_terr_values_idx_header
WHERE index_name like 'JTY_DNM_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN%';
INSERT INTO jty_terr_values_idx_header (
terr_values_idx_header_id
,source_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,qual_usg_id
,index_name
,build_index_flag
,delete_flag )
VALUES (
l_header_seq
,p_source_id
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_qual_usg_id_tbl(i)
,l_index_name
,'Y'
,'N');
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_cp_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_lvc_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_lvc_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_hvc_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_lvn_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_hvn_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_it_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_pic_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_sic_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_curr_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value1_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value2_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value3_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value4_id_tbl(i)
,null
,null);
INSERT INTO jty_terr_values_idx_details (
terr_values_idx_details_id
,terr_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_terr_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_fc_tbl(i)
,null
,null);
UPDATE jty_terr_values_idx_header
SET delete_flag = 'N'
WHERE source_id = p_source_id
AND qual_usg_id = p_qual_usg_id_tbl(i);
SELECT qual_type_usg_id
INTO l_qual_type_usg_id
FROM jtf_qual_type_usgs_all
WHERE source_id = p_source_id
AND qual_type_id = p_trans_id;
SELECT count(*)
INTO l_no_of_records
FROM jty_dea_values_idx_header
WHERE source_id = p_source_id
AND qual_usg_id = p_qual_usg_id_tbl(i);
SELECT jty_dea_values_idx_header_s.nextval
INTO l_header_seq
FROM dual;
INSERT INTO jty_dea_values_idx_header (
dea_values_idx_header_id
,source_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,qual_usg_id
,index_name
,build_index_flag )
VALUES (
l_header_seq
,p_source_id
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_qual_usg_id_tbl(i)
,'JTY_DEA_ATTR_VAL_' || abs(l_qual_type_usg_id) || '_RN' || i
,'Y');
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_cp_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_lvc_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_lvc_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_hvc_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_lvn_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_hvn_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_it_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_pic_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_sic_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_curr_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value1_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value2_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value3_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_value4_id_tbl(i)
,null
,null);
INSERT INTO jty_dea_values_idx_details (
dea_values_idx_details_id
,dea_values_idx_header_id
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,values_col_map
,input_selectivity
,input_ordinal_selectivity )
VALUES (
jty_dea_values_idx_details_s.nextval
,l_header_seq
,G_SYSDATE
,G_USER_ID
,G_SYSDATE
,G_USER_ID
,G_USER_ID
,p_fc_tbl(i)
,null
,null);
SELECT jqu.qual_usg_id
,jqu.real_time_select
,jqu.real_time_from
,jqu.real_time_where
,jqu.comparison_operator
,jqu.low_value_char_id
,jqu.low_value_char
,jqu.high_value_char
,jqu.low_value_number
,jqu.high_value_number
,jqu.interest_type_id
,jqu.primary_interest_code_id
,jqu.secondary_interest_code_id
,jqu.currency_code
,jqu.value1_id
,jqu.value2_id
,jqu.value3_id
,jqu.value4_id
,jqu.first_char
FROM jtf_qual_usgs_all jqu
,jtf_qual_type_usgs jqtu
,jtf_qual_type_denorm_v v
WHERE jqu.org_id = -3113
AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id
AND jqtu.source_id = lp_source_id
AND jqtu.qual_type_id = v.related_id
AND jqu.real_time_select IS NOT NULL
AND v.qual_type_id = lp_trans_id
AND EXISTS ( SELECT jtq.terr_id
FROM jtf_terr_qtype_usgs_all jtqu
,jtf_terr_all jt
,jtf_terr_qual_all jtq
,jtf_qual_type_usgs jqtu
WHERE jt.end_date_active >= lp_start_date
AND jt.start_date_active <= lp_end_date
AND jtqu.terr_id = jt.terr_id
AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
AND jqtu.qual_type_id = lp_trans_id
AND jtqu.terr_id = jtq.terr_id
AND jtq.qual_usg_id = jqu.qual_usg_id);
SELECT program_name
,real_time_trans_table_name
FROM jty_trans_usg_pgm_details
WHERE source_id = lp_source_id
AND trans_type_id = lp_trans_id;
TYPE l_rts_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_select%TYPE;
l_insert_stmt VARCHAR2(32767);
SELECT denorm_dea_value_table_name
INTO l_table_name
FROM jtf_sources_all
WHERE source_id = p_source_id;
SELECT denorm_value_table_name
INTO l_table_name
FROM jtf_sources_all
WHERE source_id = p_source_id;
/* generic insert statement */
l_insert_stmt :=
'INSERT INTO jtf_terr_results_GT_MT jtr ' ||
'( ' ||
' trans_id ' ||
' ,source_id ' ||
' ,qual_type_id ' ||
' ,trans_object_id ' ||
' ,trans_detail_object_id ' ||
' ,txn_date ' ||
' ,terr_id ' ||
' ,absolute_rank ' ||
' ,top_level_terr_id ' ||
' ,num_winners ' ||
' ,worker_id ' ||
') ' ||
'SELECT ' ||
' ' || p_trans_id || ' ' ||
' ,' || p_source_id || ' ' ||
' ,' || p_trans_id || ' ' ||
' ,ILV.trans_object_id ' ||
' ,ILV.trans_detail_object_id ' ||
' ,ILV.txn_date ' ||
' ,ILV.terr_id ' ||
' ,ILV.absolute_rank ' ||
' ,ILV.top_level_terr_id ' ||
' ,ILV.num_winners ' ||
' ,1 ' ||
'FROM ( ';
' SELECT ' ||
' jua.terr_id ' ||
' ,jua.num_qual ' ||
' FROM jtf_terr_qtype_usgs_all jua ' ||
' ,jtf_qual_type_usgs_all jqa ' ||
' WHERE jqa.source_id = ' || p_source_id || ' ' ||
' AND jqa.qual_type_id = ' || p_trans_id || ' ' ||
' AND jua.qual_type_usg_id = jqa.qual_type_usg_id ' ||
' AND jua.terr_id = ilv.terr_id ) ';
l_realtime_sql := l_insert_stmt || l_qual_rules || l_group_by;
/* if mode is date effective, update the column real_time_match_dea_sql */
IF (p_mode = 'DATE EFFECTIVE') THEN
UPDATE jty_trans_usg_pgm_details
SET real_time_match_dea_sql = l_realtime_sql,
last_update_date = sysdate
WHERE source_id = p_source_id
AND trans_type_id = p_trans_id
AND program_name = l_pgm_name_tbl(i);
/* if mode is total or incremental, update the column real_time_match_sql */
UPDATE jty_trans_usg_pgm_details
SET real_time_match_sql = l_realtime_sql,
last_update_date = sysdate
WHERE source_id = p_source_id
AND trans_type_id = p_trans_id
AND program_name = l_pgm_name_tbl(i);
SELECT COUNT(*)
INTO l_num_of_terr
FROM jtf_terr_qtype_usgs_all jtqu
, jtf_terr_all jt1
, jtf_qual_type_usgs jqtu
WHERE jtqu.terr_id = jt1.terr_id
AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
AND jqtu.qual_type_id = p_trans_id
AND jqtu.source_id = p_source_id
AND jt1.end_date_active >= l_start_date
AND jt1.start_date_active <= l_end_date
AND EXISTS (
SELECT 1
FROM jtf_terr_rsc_all jtr,
jtf_terr_rsc_access_all jtra,
jtf_qual_types_all jqta
WHERE jtr.terr_id = jt1.terr_id
AND jtr.end_date_active >= l_start_date
AND jtr.start_date_active <= l_end_date
AND jtr.resource_type <> 'RS_ROLE'
AND jtr.terr_rsc_id = jtra.terr_rsc_id
AND jtra.access_type = jqta.name
AND jqta.qual_type_id = p_trans_id
AND jtra.trans_access_code <> 'NONE')
AND EXISTS (
SELECT 1
FROM jty_denorm_dea_rules_all jtdr
WHERE jtdr.terr_id = jt1.terr_id
AND jtdr.terr_id = jtdr.related_terr_id)
AND jqtu.qual_type_id <> -1001
AND rownum < 2;
SELECT COUNT(*)
INTO l_num_of_terr
FROM jtf_terr_qtype_usgs_all jtqu
, jtf_terr_all jt1
, jtf_qual_type_usgs jqtu
WHERE jtqu.terr_id = jt1.terr_id
AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
AND jqtu.qual_type_id = p_trans_id
AND jqtu.source_id = p_source_id
AND jt1.end_date_active >= l_start_date
AND jt1.start_date_active <= l_end_date
AND EXISTS (
SELECT 1
FROM jtf_terr_rsc_all jtr,
jtf_terr_rsc_access_all jtra,
jtf_qual_types_all jqta
WHERE jtr.terr_id = jt1.terr_id
AND jtr.end_date_active >= l_start_date
AND jtr.start_date_active <= l_end_date
AND jtr.resource_type <> 'RS_ROLE'
AND jtr.terr_rsc_id = jtra.terr_rsc_id
AND jtra.access_type = jqta.name
AND jqta.qual_type_id = p_trans_id
AND jtra.trans_access_code <> 'NONE')
AND EXISTS (
SELECT 1
FROM jtf_terr_denorm_rules_all jtdr
WHERE jtdr.terr_id = jt1.terr_id
AND jtdr.terr_id = jtdr.related_terr_id)
AND jqtu.qual_type_id <> -1001
AND rownum < 2;