APPS.OPI_DBI_PROD_SCRAP_PKG SQL Statements

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

Line: 169

    'SELECT
        ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
          || l_view_by_col_name || ' OPI_ATTRIBUTE1,
        ' || l_description || ' OPI_ATTRIBUTE2,
        ' || l_uom || ' OPI_ATTRIBUTE3,';

Line: 392

    'SELECT
        ' || ' cal.name VIEWBY,
        ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.p_scrap_val')
                                           || ' OPI_MEASURE1,
        ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_scrap_val')
                                           || ' OPI_MEASURE2,
        ' || opi_dbi_rpt_util_pkg.change_str ('iset.c_scrap_val',
                                           'iset.p_scrap_val',
                                           'iset.p_scrap_val',
                                           'OPI_MEASURE3') || ',
        ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_production_val')
                                           || ' OPI_MEASURE4,
        ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_scrap_val',
                                            'iset.p_production_val',
                                            'OPI_MEASURE5') || ',
        ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_scrap_val',
                                            'iset.c_production_val',
                                            'OPI_MEASURE6') || ',
        ' || opi_dbi_rpt_util_pkg.change_pct_str ('iset.c_scrap_val',
                                               'iset.c_production_val',
                                               'iset.p_scrap_val',
                                               'iset.p_production_val',
                                               'OPI_MEASURE7');