APPS.OPI_DBI_ONTIME_PROD_RPT_PKG SQL Statements

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

Line: 168

	      l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
                                                    (p_join_tbl);

Line: 176

        'SELECT
        ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
		    l_description || ' OPI_ATTRIBUTE1,
        ' || l_uom || ' OPI_ATTRIBUTE2';

Line: 212

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

Line: 247

        'FROM ( SELECT  '  || fnd_global.newline ||
                         l_view_by_fact_col || fnd_global.newline ||
	  ',' || opi_dbi_rpt_util_pkg.nvl_str (
                           p_str         => 'c_late_prod_cnt',
                           p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;