[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,
' || l_qty1 || ' OPI_MEASURE1,
' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_val')
|| ' OPI_MEASURE2,
' || l_qty2 || ' OPI_MEASURE3,
' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_avail_val')
|| ' OPI_MEASURE4,
' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_actual_val',
'oset.p_avail_val',
'OPI_MEASURE5') || ',
' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_actual_val',
'oset.c_avail_val',
'OPI_MEASURE6') || ',
' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_actual_val',
'oset.c_avail_val',
'oset.p_actual_val',
'oset.p_avail_val',
'OPI_MEASURE7') || ',
' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_val_total')
|| ' OPI_MEASURE8,
' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_avail_val_total')
|| ' OPI_MEASURE9,
' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_actual_val_total',
'oset.c_avail_val_total',
'OPI_MEASURE10') || ',
' || opi_dbi_rpt_util_pkg.change_pct_str ('oset.c_actual_val_total',
'oset.c_avail_val_total',
'oset.p_actual_val_total',
'oset.p_avail_val_total',
'OPI_MEASURE11') || ',
' || opi_dbi_rpt_util_pkg.nvl_str('oset.c_avail_qty_total')
|| ' OPI_MEASURE16 ,
' || opi_dbi_rpt_util_pkg.nvl_str('oset.c_actual_qty_total')
|| ' OPI_MEASURE17 ,
' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_actual_val',
'oset.c_avail_val',
'OPI_MEASURE12') || ',
' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_actual_val',
'oset.p_avail_val',
'OPI_MEASURE13') || ',
' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_actual_val_total',
'oset.c_avail_val_total',
'OPI_MEASURE14') || ',
' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_actual_val_total',
'oset.p_avail_val_total',
'OPI_MEASURE15'
);
'SELECT
' || ' cal.name VIEWBY,
' || ' cal.name OPI_ATTRIBUTE1,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_val')
|| ' OPI_MEASURE1,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_val')
|| ' OPI_MEASURE2,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_avail_val')
|| ' OPI_MEASURE3,
' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_avail_val')
|| ' OPI_MEASURE4,
' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_actual_val',
'iset.p_avail_val',
'OPI_MEASURE5') || ',
' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_actual_val',
'iset.c_avail_val',
'OPI_MEASURE6') || ',
' || opi_dbi_rpt_util_pkg.change_pct_str ('iset.c_actual_val',
'iset.c_avail_val',
'iset.p_actual_val',
'iset.p_avail_val',
'OPI_MEASURE7');