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.BIV_DBI_BAK_PKG SQL Statements

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

Line: 180


  l_stmt := 'select
  ' ||
    biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
    ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
'
' ||
    case
      when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
        ', v.description'
      else
        ', null'
    end
    || ' BIV_ATTRIBUTE5
/* Backlog Prior */
, nvl(oset.p_backlog,0) BIV_MEASURE1
/* Backlog Current */
, nvl(oset.c_backlog,0) BIV_MEASURE2
/* Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_backlog'
                               ,'oset.p_backlog'
                               ,'BIV_MEASURE4') ||
'
/* Escalated Prior */
, nvl(oset.p_escalated,0) BIV_MEASURE9
/* Escalated Current */
, nvl(oset.c_escalated,0) BIV_MEASURE10
/* Escalated Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_escalated'
                               ,'oset.p_escalated'
                               ,'BIV_MEASURE12') ||
'
/* Unowned Prior */
, nvl(oset.p_unowned,0) BIV_MEASURE13
/* Unowned Current */
, nvl(oset.c_unowned,0) BIV_MEASURE14
/* Unowned Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_unowned'
                               ,'oset.p_unowned'
                               ,'BIV_MEASURE16') ||
'
/* GT Backlog Current */
, nvl(oset.c_backlog_total,0) BIV_MEASURE17
/* GT Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
                               ,'oset.p_backlog_total'
                               ,'BIV_MEASURE18') ||
'
/* GT Escalated Current */
, nvl(oset.c_escalated_total,0) BIV_MEASURE21
/* GT Escalated Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_escalated_total'
                               ,'oset.p_escalated_total'
                               ,'BIV_MEASURE22') ||
'
/* GT Unowned Current */
, nvl(oset.c_unowned_total,0) BIV_MEASURE23
/* GT Unowned Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_unowned_total'
                               ,'oset.p_unowned_total'
                               ,'BIV_MEASURE24') ||
'
, ' ||
biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_rep_func ) ||
'
, ' ||
drill_across('N','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
'
, ' ||
drill_across('N','ESCALATED', 'oset.c_escalated', 'BIV_ATTRIBUTE7',l_view_by) ||
'
, ' ||
drill_across('N','UNOWNED', 'oset.c_unowned', 'BIV_ATTRIBUTE8',l_view_by) ||
'
from
( select * from ( ' || poa_dbi_template_pkg.status_sql
        ( p_fact_name            => l_mv
        , p_where_clause         => l_where_clause
        , p_join_tables          => l_join_tbl
        , p_use_windowing        => 'N'
        , p_col_name             => l_col_tbl
        , p_use_grpid            => 'N'
        , p_paren_count          => 3
        , p_filter_where         => '(c_backlog > 0 or p_backlog > 0)'
        , p_generate_viewby      => 'Y'
        );

Line: 362


  l_stmt := 'select
  ' ||
    biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
    ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
'
' ||
    case
      when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
        ', v.description'
      else
        ', null'
    end
    || ' BIV_ATTRIBUTE5
/* Backlog Prior */
, nvl(oset.p_backlog,0) BIV_MEASURE1
/* Backlog Current */
, nvl(oset.c_backlog,0) BIV_MEASURE2
/* Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_backlog'
                               ,'oset.p_backlog'
                               ,'BIV_MEASURE4') ||
'
/* Percent of Total Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('oset.p_backlog'
                             ,'oset.p_backlog_total'
                             ,'BIV_MEASURE5') ||
'
/* Percent of Total Current */
, ' ||
biv_dbi_tmpl_util.rate_column('oset.c_backlog'
                             ,'oset.c_backlog_total'
                             ,'BIV_MEASURE6') ||
'
/* Percent of Total Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'
                                                             ,'oset.c_backlog_total'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'
                                                              ,'oset.p_backlog_total'
                                                              ,null)
                               ,'BIV_MEASURE8'
                               ,'N') ||
'
/* Escalated Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
                             ,'oset.p_backlog'
                             ,'BIV_MEASURE9') ||
'
/* Escalated Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
                             ,'oset.c_backlog'
                             ,'BIV_MEASURE10') ||
'
/* Escalated Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
                                                             ,'oset.c_backlog'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
                                                             ,'oset.p_backlog'
                                                             ,null)
                               ,'BIV_MEASURE12'
                               ,'N') ||
'
/* Unowned Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
                             ,'oset.p_backlog'
                             ,'BIV_MEASURE13') ||
'
/* Unowned Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
                             ,'oset.c_backlog'
                             ,'BIV_MEASURE14') ||
'
/* Unowned Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
                                                             ,'oset.c_backlog'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
                                                             ,'oset.p_backlog'
                                                             ,null)
                               ,'BIV_MEASURE16'
                               ,'N') ||
'
/* GT Backlog Current */
, nvl(oset.c_backlog_total,0) BIV_MEASURE17
/* GT Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
                               ,'oset.p_backlog_total'
                               ,'BIV_MEASURE18') ||
'
/* GT Percent of Total Current */
, 100 BIV_MEASURE19
/* GT Escalated Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
                             ,'oset.c_backlog_total'
                             ,'BIV_MEASURE21') ||
'
/* GT Escalated Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
                                                             ,'oset.c_backlog_total'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
                                                             ,'oset.p_backlog_total'
                                                             ,null)
                               ,'BIV_MEASURE22'
                               ,'N') ||
'
/* GT Unowned Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
                             ,'oset.c_backlog_total'
                             ,'BIV_MEASURE23') ||
'
/* GT Unowned Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
                                                             ,'oset.c_backlog_total'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
                                                             ,'oset.p_backlog_total'
                                                             ,null)
                               ,'BIV_MEASURE24'
                               ,'N') ||
'
/* KPI GT Backlog Prior */
, nvl(oset.p_backlog_total,0) BIV_MEASURE31
/* KPI GT Escalated Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
                             ,'oset.p_backlog_total'
                             ,'BIV_MEASURE32') ||
'
/* KPI GT Unowned Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
                             ,'oset.p_backlog_total'
                             ,'BIV_MEASURE33') ||
'
, ' ||
biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_dbn_rep_func ) ||
'
, ' ||
drill_across('Y','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
'
from
( select * from ( ' || poa_dbi_template_pkg.status_sql
        ( p_fact_name            => l_mv
        , p_where_clause         => l_where_clause
        , p_join_tables          => l_join_tbl
        , p_use_windowing        => 'N'
        , p_col_name             => l_col_tbl
        , p_use_grpid            => 'N'
        , p_paren_count          => 3
        , p_filter_where         => '(c_backlog > 0 or p_backlog > 0)'
        , p_generate_viewby      => 'Y'
        );

Line: 622


  l_stmt := 'select
  ' ||
    biv_dbi_tmpl_util.get_view_by_col_name(l_view_by) || ' VIEWBY ' ||
    ', oset.' || l_view_by_col_name || ' VIEWBYID ' ||
'
' ||
    case
      when l_view_by = biv_dbi_tmpl_util.g_PRODUCT then
        ', v.description'
      else
        ', null'
    end
    || ' BIV_ATTRIBUTE5
/* Backlog Prior */
, nvl(oset.p_backlog,0) BIV_MEASURE1
/* Backlog Current */
, nvl(oset.c_backlog,0) BIV_MEASURE2
/* Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_backlog'
                               ,'oset.p_backlog'
                               ,'BIV_MEASURE4') ||
'
/* Percent of Total Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('oset.p_backlog'
                             ,'oset.p_backlog_total'
                             ,'BIV_MEASURE5') ||
'
/* Percent of Total Current */
, ' ||
biv_dbi_tmpl_util.rate_column('oset.c_backlog'
                             ,'oset.c_backlog_total'
                             ,'BIV_MEASURE6') ||
'
/* Percent of Total Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('oset.c_backlog'
                                                             ,'oset.c_backlog_total'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('oset.p_backlog'
                                                              ,'oset.p_backlog_total'
                                                              ,null)
                               ,'BIV_MEASURE8'
                               ,'N') ||
'
/* Escalated Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
                             ,'oset.p_backlog'
                             ,'BIV_MEASURE9') ||
'
/* Escalated Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
                             ,'oset.c_backlog'
                             ,'BIV_MEASURE10') ||
'
/* Escalated Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated,0)'
                                                             ,'oset.c_backlog'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated,0)'
                                                             ,'oset.p_backlog'
                                                             ,null)
                               ,'BIV_MEASURE12'
                               ,'N') ||
'
/* Unowned Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
                             ,'oset.p_backlog'
                             ,'BIV_MEASURE13') ||
'
/* Unowned Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
                             ,'oset.c_backlog'
                             ,'BIV_MEASURE14') ||
'
/* Unowned Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned,0)'
                                                             ,'oset.c_backlog'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned,0)'
                                                             ,'oset.p_backlog'
                                                             ,null)
                               ,'BIV_MEASURE16'
                               ,'N') ||
'
/* GT Backlog Current */
, nvl(oset.c_backlog_total,0) BIV_MEASURE17
/* GT Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('oset.c_backlog_total'
                               ,'oset.p_backlog_total'
                               ,'BIV_MEASURE18') ||
'
/* GT Percent of Total Current */
, 100 BIV_MEASURE19
/* GT Escalated Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
                             ,'oset.c_backlog_total'
                             ,'BIV_MEASURE21') ||
'
/* GT Escalated Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_escalated_total,0)'
                                                             ,'oset.c_backlog_total'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
                                                             ,'oset.p_backlog_total'
                                                             ,null)
                               ,'BIV_MEASURE22'
                               ,'N') ||
'
/* GT Unowned Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
                             ,'oset.c_backlog_total'
                             ,'BIV_MEASURE23') ||
'
/* GT Unowned Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(oset.c_unowned_total,0)'
                                                             ,'oset.c_backlog_total'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
                                                             ,'oset.p_backlog_total'
                                                             ,null)
                               ,'BIV_MEASURE24'
                               ,'N') ||
'
/* KPI GT Backlog Prior */
, nvl(oset.p_backlog_total,0) BIV_MEASURE31
/* KPI GT Escalated Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_escalated_total,0)'
                             ,'oset.p_backlog_total'
                             ,'BIV_MEASURE32') ||
'
/* KPI GT Unowned Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(oset.p_unowned_total,0)'
                             ,'oset.p_backlog_total'
                             ,'BIV_MEASURE33') ||
'
, ' ||
biv_dbi_tmpl_util.get_category_drill_down( l_view_by, g_backlog_dbn_rep_func||'@BIV_RES_STATUS=N' ) ||
'
, ' ||
unr_drill_across('Y','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
'
from
( select * from ( ' || poa_dbi_template_pkg.status_sql
        ( p_fact_name            => l_mv
        , p_where_clause         => l_where_clause
        , p_join_tables          => l_join_tbl
        , p_use_windowing        => 'N'
        , p_col_name             => l_col_tbl
        , p_use_grpid            => 'N'
        , p_paren_count          => 3
        , p_filter_where         => '(c_backlog > 0 or p_backlog > 0)'
        , p_generate_viewby      => 'Y'
        );

Line: 885


  l_stmt := 'select
  cal.name VIEWBY
/* End date of the period */
, cal.end_date VIEWBYID
/* Backlog Prior */
, nvl(iset.p_backlog,0) BIV_MEASURE1
/* Backlog Current */
, nvl(iset.c_backlog,0) BIV_MEASURE2
/* Backlog Change */
, ' ||
biv_dbi_tmpl_util.change_column('iset.c_backlog'
                                   ,'iset.p_backlog'
                                   ,'BIV_MEASURE4') ||
   case
     when p_distribution = 'N' then
'
/* Escalated Prior */
, nvl(iset.p_escalated,0) BIV_MEASURE9
/* Escalated Current */
, nvl(iset.c_escalated,0) BIV_MEASURE10
/* Escalated Change */
, ' ||
biv_dbi_tmpl_util.change_column('iset.c_escalated'
                               ,'iset.p_escalated'
                               ,'BIV_MEASURE12') ||
'
/* Unowned Prior */
, nvl(iset.p_unowned,0) BIV_MEASURE13
/* Unowned Current */
, nvl(iset.c_unowned,0) BIV_MEASURE14
/* Unowned Change */
, ' ||
biv_dbi_tmpl_util.change_column('iset.c_unowned'
                               ,'iset.p_unowned'
                               ,'BIV_MEASURE16')
     else
'
/* Escalated Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'
                             ,'iset.p_backlog'
                             ,'BIV_MEASURE9') ||
'
/* Escalated Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'
                             ,'iset.c_backlog'
                             ,'BIV_MEASURE10') ||
'
/* Escalated Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_escalated,0)'
                                                             ,'iset.c_backlog'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_escalated,0)'
                                                             ,'iset.p_backlog'
                                                             ,null)
                               ,'BIV_MEASURE12'
                               ,'N') ||
'
/* Unowned Percent Prior */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'
                             ,'iset.p_backlog'
                             ,'BIV_MEASURE13') ||
'
/* Unowned Percent Current */
, ' ||
biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'
                             ,'iset.c_backlog'
                             ,'BIV_MEASURE14') ||
'
/* Unowned Percent Change */
, ' ||
biv_dbi_tmpl_util.change_column(biv_dbi_tmpl_util.rate_column('nvl(iset.c_unowned,0)'
                                                             ,'iset.c_backlog'
                                                             ,null)
                               ,biv_dbi_tmpl_util.rate_column('nvl(iset.p_unowned,0)'
                                                             ,'iset.p_backlog'
                                                             ,null)
                               ,'BIV_MEASURE16'
                               ,'N')
   end;