The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_view_by_select VARCHAR2(32000);
,p_view_by_select => l_view_by_select
,p_view_by => l_dummy);
,p_view_by_select => l_view_by_select
,p_view_by => l_dummy);
l_sqltext := 'SELECT name VIEWBY,
sum(nvl(curr_login,0)-nvl(curr_idle,0))*100/decode(sum(curr_login),0,null,sum(curr_login)) bix_pmv_ai_availrate,
/* sum(nvl(p_login,0)-nvl(p_idle,0))*100/decode(sum(p_login),0,null,sum(p_login)) bix_pmv_ai_prevavailrate,*/
sum(nvl(curr_login,0)-nvl(curr_idle,0)-nvl(curr_avail,0))*100/decode(sum(curr_login),0,null,sum(curr_login)) bix_pmv_ai_utilrate/*,
sum(nvl(p_login,0)-nvl(p_idle,0)-nvl(p_avail,0))*100/decode(sum(p_login),0,null,sum(p_login)) bix_pmv_ai_prevutilrate*/
FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
FROM '||bix_pmv_dbi_utl_pkg.trend_sql
(p_xtd => l_xtd,
p_comparison_type => l_comp_type,
p_fact_name => l_mv,
p_where_clause => l_where_clause,
p_col_name => bix_col_tab,
p_use_grpid => 'N',
p_in_join_tables => NULL,
p_fact_hint => NULL,
p_union_clause =>l_union_all_text )||'
) GROUP BY name ,st_date order by st_date ';