APPS.OPI_DBI_PRD_CST_MARGIN_PKG SQL Statements

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

Line: 183

    l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
                                                (p_join_tbl);

Line: 189

    '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,
    ' || 'oset.OPI_MEASURE1,
    ' || 'oset.OPI_MEASURE2,
    ' || 'oset.OPI_MEASURE3,
    ' || 'oset.OPI_MEASURE4,
    ' || 'oset.OPI_MEASURE5,
    ' || 'oset.OPI_MEASURE6,
    ' || 'oset.OPI_MEASURE7,
    ' || 'oset.OPI_MEASURE8,
    ' || 'oset.OPI_MEASURE9,
    ' || 'oset.OPI_MEASURE10,
    ' || 'oset.OPI_MEASURE11,
    ' || 'oset.OPI_MEASURE12,
    ' || 'oset.OPI_MEASURE13,
    ' || 'oset.OPI_MEASURE14,
    ' || 'oset.OPI_MEASURE15,
    ' || 'oset.OPI_MEASURE16,
    ' || 'oset.OPI_MEASURE17,
    ' || 'oset.OPI_MEASURE18,
    ' || 'oset.OPI_MEASURE19,
    ' || l_drill_across_url || ' OPI_DYNAMIC_URL_1
    ' || 'FROM
    ' || '(SELECT (rank () over
    ' || ' (&ORDER_BY_CLAUSE nulls last,
    ' || l_view_by_fact_col || ')) - 1 rnk,
    ' || l_view_by_fact_col || ',
    ' || 'OPI_MEASURE1,
    ' || 'OPI_MEASURE2,
    ' || 'OPI_MEASURE3,
    ' || 'OPI_MEASURE4,
    ' || 'OPI_MEASURE5,
    ' || 'OPI_MEASURE6,
    ' || 'OPI_MEASURE7,
    ' || 'OPI_MEASURE8,
    ' || 'OPI_MEASURE9,
    ' || 'OPI_MEASURE10,
    ' || 'OPI_MEASURE11,
    ' || 'OPI_MEASURE12,
    ' || 'OPI_MEASURE13,
    ' || 'OPI_MEASURE14,
    ' || 'OPI_MEASURE15,
    ' || 'OPI_MEASURE16,
    ' || 'OPI_MEASURE17,
    ' || 'OPI_MEASURE18,
    ' || 'OPI_MEASURE19
    ' || 'FROM
    ' || '(SELECT
          ' || l_view_by_fact_col || ',
          ' || OPI_DBI_RPT_UTIL_PKG.nvl_str ('c_fulfilled_val')
                                            || ' OPI_MEASURE1,
          ' || OPI_DBI_RPT_UTIL_PKG.nvl_str ('c_cogs_val')
                                            || ' OPI_MEASURE2,
          ' || l_p_margin || ' OPI_MEASURE3,
          ' || l_c_margin || ' OPI_MEASURE4,
          ' || OPI_DBI_RPT_UTIL_PKG.change_str (l_c_margin,
                                                l_p_margin,
                                                l_p_margin, '')
                                            || ' OPI_MEASURE5,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_p_margin,
                                                 l_p_fulfilled_val, '')
                                            || ' OPI_MEASURE6,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_c_margin,
                                                 l_c_fulfilled_val, '')
                                            || ' OPI_MEASURE7,
          ' || OPI_DBI_RPT_UTIL_PKG.change_pct_str (l_c_margin,
                                                    l_c_fulfilled_val,
                                                    l_p_margin,
                                                    l_p_fulfilled_val, '')
                                            || ' OPI_MEASURE8,
          ' || OPI_DBI_RPT_UTIL_PKG.nvl_str ('c_fulfilled_val_total')
                                            || ' OPI_MEASURE9,
          ' || OPI_DBI_RPT_UTIL_PKG.nvl_str ('c_cogs_val_total')
                                            || ' OPI_MEASURE10,
          ' || l_c_margin_total || ' OPI_MEASURE11,
          ' || OPI_DBI_RPT_UTIL_PKG.change_str (l_c_margin_total,
                                                l_p_margin_total,
                                                l_p_margin_total, '')
                                            || ' OPI_MEASURE12,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_c_margin_total,
                                                 l_c_fulfilled_val_total, '')
                                            || ' OPI_MEASURE13,
          ' || OPI_DBI_RPT_UTIL_PKG.change_pct_str (l_c_margin_total,
                                                    l_c_fulfilled_val_total,
                                                    l_p_margin_total,
                                                    l_p_fulfilled_val_total,
                                                    '')
                                            || ' OPI_MEASURE14,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_c_margin,
                                                 l_c_fulfilled_val, '')
                                            || ' OPI_MEASURE15,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_p_margin,
                                                 l_p_fulfilled_val, '')
                                            || ' OPI_MEASURE16,
          ' || OPI_DBI_RPT_UTIL_PKG.nvl_str (l_qty1)
                                            || ' OPI_MEASURE17,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_c_margin_total,
                                                 l_c_fulfilled_val_total, '')
                                            || ' OPI_MEASURE18,
          ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_p_margin_total,
                                                 l_p_fulfilled_val_total, '')
                                            || ' OPI_MEASURE19 ';

Line: 479

        'SELECT
    ' || ' cal.name VIEWBY,
    ' || OPI_DBI_RPT_UTIL_PKG.nvl_str ('iset.c_fulfilled_val') || ' OPI_MEASURE1,
    ' || OPI_DBI_RPT_UTIL_PKG.nvl_str ('iset.c_cogs_val') || ' OPI_MEASURE2,
    ' || l_p_margin       || ' OPI_MEASURE3,
    ' || l_c_margin       || ' OPI_MEASURE4,
    ' || OPI_DBI_RPT_UTIL_PKG.change_str (l_c_margin, l_p_margin, l_p_margin, '') || ' OPI_MEASURE5,
    ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_p_margin, l_p_fulfilled_val, '') || ' OPI_MEASURE6,
    ' || OPI_DBI_RPT_UTIL_PKG.percent_str (l_c_margin, l_c_fulfilled_val, '') || ' OPI_MEASURE7,
    ' || OPI_DBI_RPT_UTIL_PKG.change_pct_str (l_c_margin, l_c_fulfilled_val,
                            l_p_margin, l_p_fulfilled_val, '') || ' OPI_MEASURE8 ';