The following lines contain the word 'select', 'insert', 'update' or 'delete':
select distinct Q.query_id, Q.query_name
from JTF_PERZ_QUERY_PARAM P, JTF_PERZ_QUERY Q
where Q.Query_Id = P.Query_Id
and Q.Application_Id = c_application_id
and P.Parameter_Type = 'condition'
and (P.Parameter_Name = 'productCategory' OR -- As in Group Summary Report or Advanced Search
P.Parameter_Name = 'prodCat' OR -- As in Summary Report or detail Report or other reports
P.Parameter_Name like 'ROW%ProductCategory' OR
P.Parameter_Name like 'ROW%Invt' OR
P.Parameter_Name like 'invItemID%')
order by Q.query_id;
select P.query_param_id, P.parameter_name, P.parameter_type, P.parameter_value, P.parameter_condition, P.parameter_sequence, P.created_by, P.last_update_date, P.last_updated_by, P.last_update_login, P.security_group_id
from JTF_PERZ_QUERY_PARAM P
where P.query_id = c_query_id
and P.Parameter_Type = 'condition'
and (P.Parameter_Name = 'productCategory' OR -- As in Group Summary Report or Advanced Search
P.Parameter_Name = 'prodCat' OR -- As in Summary Report or detail Report or other reports
P.Parameter_Name like 'ROW%ProductCategory' OR
P.Parameter_Name like 'ROW%Invt' OR
P.Parameter_Name like 'invItemID%')
order by P.query_param_id;
select concat_cat_parentage
from eni_prod_den_hrchy_parents_v
where category_id = c_product_category_id
and category_set_id = c_product_cat_set_id
and language = userenv('lang');
select product_category_id, product_cat_set_id
from AS_INTEREST_TYPES_B
where interest_type_id = c_interest_type_id;
select product_category_id, product_cat_set_id
from AS_INTEREST_CODES_B
where interest_code_id = c_interest_code_id;
Update JTF_PERZ_QUERY_PARAM P
set parameter_name = 'rep.ROW' || l_cnt || '.ProdCategory',
parameter_value = l_product_cat_id
where
P.query_param_id = scr.query_param_id;
Update JTF_PERZ_QUERY_PARAM P
set parameter_name = 'rep.ROW' || l_cnt2 || '.ProdCategory',
parameter_value = l_product_cat_id
where
P.query_param_id = scr.query_param_id;
Update JTF_PERZ_QUERY_PARAM P
set parameter_name = 'rep.ROW' || l_cnt2 || '.invItem'
where
P.query_param_id = scr.query_param_id;
Update JTF_PERZ_QUERY_PARAM P
set parameter_name = 'rep.ROW' || l_cnt2 || '.invItemID'
where
P.query_param_id = scr.query_param_id;
select min(lead_line_id)
from as_lead_lines_all;
select max(lead_line_id)
from as_lead_lines_all;
select AS_LEAD_LINES_S.nextval
from dual;
select trigger_name
from all_triggers
where table_owner = c_schema_name
and trigger_name IN ('AS_LEAD_LINES_BIUD','AS_LEAD_LINES_AFTER_BIUD','AS_SALES_CREDITS_BIUD','AS_SALES_CREDITS_AFTER_BIUD')
and nvl(status,'DISABLED')<>'ENABLED';
update as_lead_lines_all l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where l.interest_type_id = int.interest_type_id)
where l.lead_line_id >= l_count
and l.lead_line_id < l_count+G_BATCH_SIZE
and l.interest_type_id is not null
and l.primary_interest_code_id is null
and l.secondary_interest_code_id is null;
update as_lead_lines_all l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.primary_interest_code_id = int.interest_code_id)
where l.lead_line_id >= l_count
and l.lead_line_id < l_count+G_BATCH_SIZE
and l.primary_interest_code_id is not null
and l.secondary_interest_code_id is null;
update as_lead_lines_all l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.secondary_interest_code_id = int.interest_code_id)
where l.lead_line_id >= l_count
and l.lead_line_id < l_count+G_BATCH_SIZE
and l.secondary_interest_code_id is not null;
select min(fst_sales_category_id)
from as_fst_sales_categories;
select max(fst_sales_category_id)
from as_fst_sales_categories;
select AS_FST_SALES_CATEGORIES_S.nextval
from dual;
update as_fst_sales_categories l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where l.interest_type_id = int.interest_type_id)
where l.fst_sales_category_id >= l_count
and l.fst_sales_category_id < l_count+G_BATCH_SIZE
and l.interest_type_id is not null;
select min(interest_id)
from as_interests_all;
select max(interest_id)
from as_interests_all;
select AS_INTERESTS_S.nextval
from dual;
update as_interests_all l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where l.interest_type_id = int.interest_type_id)
where l.interest_id >= l_count
and l.interest_id < l_count+G_BATCH_SIZE
and l.interest_type_id is not null
and l.primary_interest_code_id is null
and l.secondary_interest_code_id is null;
update as_interests_all l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.primary_interest_code_id = int.interest_code_id)
where l.interest_id >= l_count
and l.interest_id < l_count+G_BATCH_SIZE
and l.primary_interest_code_id is not null
and l.secondary_interest_code_id is null;
update as_interests_all l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.secondary_interest_code_id = int.interest_code_id)
where l.interest_id >= l_count
and l.interest_id < l_count+G_BATCH_SIZE
and l.secondary_interest_code_id is not null;
select min(log_id)
from as_lead_lines_log;
select max(log_id)
from as_lead_lines_log;
select AS_LEAD_LINES_LOG_S.nextval
from dual;
update as_lead_lines_log l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where l.interest_type_id = int.interest_type_id)
where l.log_id >= l_count
and l.log_id < l_count+G_BATCH_SIZE
and l.interest_type_id is not null
and l.primary_interest_code_id is null
and l.secondary_interest_code_id is null;
update as_lead_lines_log l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.primary_interest_code_id = int.interest_code_id)
where l.log_id >= l_count
and l.log_id < l_count+G_BATCH_SIZE
and l.primary_interest_code_id is not null
and l.secondary_interest_code_id is null;
update as_lead_lines_log l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.secondary_interest_code_id = int.interest_code_id)
where l.log_id >= l_count
and l.log_id < l_count+G_BATCH_SIZE
and l.secondary_interest_code_id is not null;
select min(sales_credit_id)
from as_sales_credits_denorm;
select max(sales_credit_id)
from as_sales_credits_denorm;
select AS_SALES_CREDITS_S.nextval
from dual;
update as_sales_credits_denorm l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where l.interest_type_id = int.interest_type_id)
where l.sales_credit_id >= l_count
and l.sales_credit_id < l_count+G_BATCH_SIZE
and nvl(l.interest_type_id,-1) <> -1
and nvl(l.primary_interest_code_id,-1) = -1
and nvl(l.secondary_interest_code_id,-1) = -1;
update as_sales_credits_denorm l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.primary_interest_code_id = int.interest_code_id)
where l.sales_credit_id >= l_count
and l.sales_credit_id < l_count+G_BATCH_SIZE
and nvl(l.primary_interest_code_id,-1) <> -1
and nvl(l.secondary_interest_code_id,-1) = -1;
update as_sales_credits_denorm l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.secondary_interest_code_id = int.interest_code_id)
where l.sales_credit_id >= l_count
and l.sales_credit_id < l_count+G_BATCH_SIZE
and nvl(l.secondary_interest_code_id,-1) <> -1;
select min(PROD_WORKSHEET_LINE_ID)
from AS_PROD_WORKSHEET_LINES;
select max(PROD_WORKSHEET_LINE_ID)
from AS_PROD_WORKSHEET_LINES;
select AS_PROD_WORKSHEET_LINES_S.nextval
from dual;
update AS_PROD_WORKSHEET_LINES pwl
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where pwl.interest_type_id = int.interest_type_id)
where pwl.PROD_WORKSHEET_LINE_ID >= l_count
and pwl.PROD_WORKSHEET_LINE_ID < l_count+G_BATCH_SIZE
and pwl.interest_type_id is not null;
update as_pe_int_categories l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_types_b int
where l.interest_type_id = int.interest_type_id)
where nvl(l.interest_type_id,-1) <> -1
and nvl(l.pri_interest_code_id,-1) = -1
and nvl(l.sec_interest_code_id,-1) = -1;
update as_pe_int_categories l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.pri_interest_code_id = int.interest_code_id)
where nvl(l.pri_interest_code_id,-1) <> -1
and nvl(l.sec_interest_code_id,-1) = -1;
update as_pe_int_categories l
set (product_category_id, product_cat_set_id) =
(select int.product_category_id, int.product_cat_set_id
from as_interest_codes_b int
where l.sec_interest_code_id = int.interest_code_id)
where nvl(l.sec_interest_code_id,-1) <> -1;
update as_lead_lines_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
update as_interests_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
update as_sales_credits_denorm set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
update as_lead_lines_log set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
update as_fst_sales_categories set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
update as_opp_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
update as_prod_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;