[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT
' || opi_dbi_rpt_util_pkg.get_viewby_select_clause(p_view_by_dim) ||
l_view_by_col_name || ' OPI_ATTRIBUTE1,
NULL OPI_ATTRIBUTE2,' ;
'SELECT
' || ' cal.name VIEWBY,
' || ' cal.name OPI_ATTRIBUTE1,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_val')
|| ' OPI_MEASURE2,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_val')
|| ' OPI_MEASURE4,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_val') || ' -
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_val')
|| 'OPI_MEASURE5,
' || opi_dbi_rpt_util_pkg.change_str (
opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_val') || ' - ' ||
opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_val'),
opi_dbi_rpt_util_pkg.nvl_str ('iset.p_actual_val') || ' - ' ||
opi_dbi_rpt_util_pkg.nvl_str ('iset.p_std_usage_val'),
opi_dbi_rpt_util_pkg.nvl_str ('iset.p_actual_val') || ' - ' ||
opi_dbi_rpt_util_pkg.nvl_str ('iset.p_std_usage_val'),
'OPI_MEASURE6') || ',
' || opi_dbi_rpt_util_pkg.change_str ('iset.c_actual_val',
'iset.c_std_usage_val',
'iset.c_std_usage_val',
'OPI_MEASURE7') || ',
' || opi_dbi_rpt_util_pkg.change_str ('iset.c_actual_val',
'iset.c_std_usage_val',
'iset.c_std_usage_val',
'') || ' - '
|| opi_dbi_rpt_util_pkg.change_str ('iset.p_actual_val',
'iset.p_std_usage_val',
'iset.p_std_usage_val',
'')
|| 'OPI_MEASURE8,
' || opi_dbi_rpt_util_pkg.nvl_str('iset.p_actual_val') || ' - '
|| opi_dbi_rpt_util_pkg.nvl_str('iset.p_std_usage_val') || ' OPI_MEASURE15,
' || opi_dbi_rpt_util_pkg.change_str('iset.p_actual_val',
'iset.p_std_usage_val',
'iset.p_std_usage_val',
'OPI_MEASURE16');