APPS.ISC_FS_TASK_ACT_BAC_RPT_PKG SQL Statements

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

Line: 45

  l_viewby_select    varchar2(400); -- needed to be increased from 200

Line: 85

  , x_viewby_select    => l_viewby_select
  , x_join_tbl         => l_join_tbl
  , x_dim_bmap         => l_dim_bmap
  , x_comparison_type  => l_comparison_type
  , x_xtd              => l_xtd
  );

Line: 192

  l_stmt := 'select
  ' || l_viewby_select || '
, ISC_MEASURE_1
, ISC_MEASURE_2
, ISC_MEASURE_3
, ISC_MEASURE_4
, ISC_MEASURE_2 ISC_MEASURE_9
, ISC_MEASURE_5
, ISC_MEASURE_6
, ISC_MEASURE_7
, ISC_MEASURE_8
, ISC_MEASURE_21
, ISC_MEASURE_22
, ISC_MEASURE_23
, ISC_MEASURE_24
, ISC_MEASURE_25
, ISC_MEASURE_26
, ISC_MEASURE_27
, ISC_MEASURE_28
, ' || l_product || '
, ' || isc_fs_rpt_util_pkg.get_district_drill_down
       ( l_view_by
       , g_task_rep_func
       , 'ISC_ATTRIBUTE_3' ) || '
, ' || isc_fs_rpt_util_pkg.get_category_drill_down
       ( l_view_by
       , g_task_rep_func
       , 'ISC_ATTRIBUTE_4' ) || '
, ' || get_detail_drill( l_view_by, 'ISC_ATTRIBUTE_5' ) || '
from (
select
  row_number() over(&ORDER_BY_CLAUSE nulls last, '|| isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ')-1 rnk
, iset.*
from ( select * from (
select ' || isc_fs_rpt_util_pkg.get_inner_select_col(l_join_tbl) || '
, nvl(p_backlog,0) ISC_MEASURE_1
, nvl(c_backlog,0) ISC_MEASURE_2
, ' || isc_fs_rpt_util_pkg.change_column
       ( 'c_backlog'
       , 'p_backlog'
       , 'ISC_MEASURE_3' ) || '
, nvl(o_backlog,0) ISC_MEASURE_4
, nvl(c_first_opened,0) ISC_MEASURE_5
, nvl(c_reopened,0) ISC_MEASURE_6
, nvl(c_opened,0) ISC_MEASURE_7
, nvl(c_closed,0) ISC_MEASURE_8
, nvl(p_backlog_total,0) ISC_MEASURE_21
, nvl(c_backlog_total,0) ISC_MEASURE_22
, ' || isc_fs_rpt_util_pkg.change_column
       ( 'c_backlog_total'
       , 'p_backlog_total'
       , 'ISC_MEASURE_23' ) || '
, nvl(o_backlog_total,0) ISC_MEASURE_24
, nvl(c_first_opened_total,0) ISC_MEASURE_25
, nvl(c_reopened_total,0) ISC_MEASURE_26
, nvl(c_opened_total,0) ISC_MEASURE_27
, nvl(c_closed_total,0) ISC_MEASURE_28
from (' || l_stmt;