APPS.OPI_DBI_CURR_VAR_RPT_PKG SQL Statements

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

Line: 154

    '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: 274

   l_query := '(select ' || l_group_and_sel_clause  || l_col_names
           || '
              from ' || p_fact_name || ' fact
              where 1=1 '
           || p_where_clause;