APPS.OPI_DBI_RES_EFF_PKG SQL Statements

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

Line: 163

    'SELECT '|| opi_dbi_rpt_util_pkg.get_viewby_select_clause(p_view_by_dim) ||
                l_view_by_col_name                              || ' OPI_ATTRIBUTE1,';

Line: 359

    'SELECT
        ' || ' cal.name VIEWBY,
        ' || ' cal.name OPI_ATTRIBUTE1,
        ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_qty')
                                           || ' OPI_MEASURE1,
        ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_qty')
                                           || ' OPI_MEASURE2,
        ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
                                               'iset.p_actual_qty',
                                               'OPI_MEASURE3') || ',
        ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
        				       'iset.c_actual_qty ',
                                               'OPI_MEASURE4') || ',
        ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
                                                     'iset.c_actual_qty',
                                                     '') || ' -
        ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
                                                'iset.p_actual_qty',
                                               '') || ' OPI_MEASURE5 ';