DBA Data[Home] [Help]

APPS.BIX_PMV_AI_AURTR_PRTLT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

l_view_by_select   VARCHAR2(32000);
Line: 74

                     ,p_view_by_select  => l_view_by_select
                     ,p_view_by         => l_dummy);
Line: 112

                     ,p_view_by_select  => l_view_by_select
                     ,p_view_by         => l_dummy);
Line: 117

      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 ';