APPS.OPI_DBI_SCRAP_REASON_RPT_PKG SQL Statements

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

Line: 125

	      l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
                                                    (p_join_tbl);

Line: 128

        'SELECT
        ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;

Line: 141

	'FROM ( SELECT
		     rank() over (&ORDER_BY_CLAUSE nulls last '||', '||l_view_by_fact_col||') - 1 rnk
	           ,'||l_view_by_fact_col;

Line: 155

        'FROM ( SELECT  '  || fnd_global.newline ||
                         l_view_by_fact_col || fnd_global.newline ||
	  ',' || opi_dbi_rpt_util_pkg.nvl_str (
                           p_str         => 'p_scrap_val',
                           p_default_val => 0) || ' OPI_MEASURE1,
           '  || opi_dbi_rpt_util_pkg.nvl_str (
                           p_str         => 'c_scrap_val',
                           p_default_val => 0) || ' OPI_MEASURE2,
           '  || opi_dbi_rpt_util_pkg.change_str (
                           p_new_numerator   => 'c_scrap_val',
                           p_old_numerator   => 'p_scrap_val',
                           p_denominator     => 'p_scrap_val',
                           p_measure_name    => 'OPI_MEASURE3')|| ',
	   '  || opi_dbi_rpt_util_pkg.percent_str(
                           p_numerator      => 'c_scrap_val',
                           p_denominator    => 'c_scrap_val_total',
                           p_measure_name   => 'OPI_MEASURE4')|| ',
	   '  || opi_dbi_rpt_util_pkg.nvl_str (
                           p_str         => 'c_scrap_val_total',
                           p_default_val => 0) || ' OPI_MEASURE5,
           '  || opi_dbi_rpt_util_pkg.change_str (
                           p_new_numerator   => 'c_scrap_val_total',
                           p_old_numerator   => 'p_scrap_val_total',
                           p_denominator     => 'p_scrap_val_total',
                           p_measure_name    => 'OPI_MEASURE6')|| ',
	   '  || opi_dbi_rpt_util_pkg.percent_str(
                           p_numerator      => 'c_scrap_val_total',
                           p_denominator    => 'c_scrap_val_total',
                           p_measure_name   => 'OPI_MEASURE7');