APPS.POA_DBI_POP_PKG SQL Statements

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

Line: 211

     l_sel_clause := 'select decode(v.name,null, fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''), v.name) VIEWBY,
		        decode(v.commodity_id,null, -1, v.commodity_id) VIEWBYID,';

Line: 214

     l_sel_clause := 'select v.value VIEWBY, v.id VIEWBYID, ';

Line: 228

   (select * from (select ' || l_view_by_col || ',' || l_cols ||
        '       nvl(c_purchase_amt,0) POA_MEASURE4,
	              p_purchase_amt POA_MEASURE5,
	              nvl(c_purchase_amt_total,0) POA_MEASURE6,
	              p_purchase_amt_total POA_MEASURE7
		   from
   ' ||  poa_dbi_template_pkg.status_sql(
                                             l_mv,
                                              l_where_clause,
                                              l_join_tbl,
                                              p_use_windowing => 'N',
                                              p_col_name => l_col_tbl,
					      p_use_grpid => 'N',
					      p_filter_where => get_kpi_filter_where,
                                              p_in_join_tables => l_in_join_tbl);

Line: 303

     l_sel_clause := 'select decode(v.name,null, fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''), v.name) VIEWBY,
		        decode(v.commodity_id,null, -1, v.commodity_id) VIEWBYID,';

Line: 306

     l_sel_clause := 'select v.value VIEWBY, v.id VIEWBYID, ';

Line: 320

     (select (rank() over
                   (&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col_name || ')) - 1 rnk,'
        || p_view_by_col_name || ',
           POA_MEASURE1, POA_PERCENT3, POA_MEASURE3, POA_PERCENT2, POA_MEASURE4,
           POA_MEASURE5, POA_MEASURE6 from
     (select ' || p_view_by_col_name || ',
             ' || p_view_by_col_name || ' VIEWBY,
           nvl(c_purchase_amt,0) POA_MEASURE1,
		   ' || poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_PERCENT3,
		   ' || poa_dbi_util_pkg.rate_clause('c_purchase_amt','c_purchase_amt_total') || ' POA_MEASURE3,
		   ' || poa_dbi_util_pkg.change_clause(poa_dbi_util_pkg.rate_clause('c_purchase_amt','c_purchase_amt_total'),poa_dbi_util_pkg.rate_clause('p_purchase_amt','p_purchase_amt_total'),'P') || ' POA_PERCENT2,
           nvl(c_purchase_amt_total,0) POA_MEASURE4,
		   ' || poa_dbi_util_pkg.change_clause('c_purchase_amt_total','p_purchase_amt_total') || ' POA_MEASURE5,
           decode(c_purchase_amt_total, null, null, 100) POA_MEASURE6';

Line: 346

  'select cal.name VIEWBY,
          nvl(p_purchase_amt,0) POA_MEASURE1,
          nvl(c_purchase_amt,0) POA_MEASURE2,
          ' || poa_dbi_util_pkg.change_clause('c_purchase_amt','p_purchase_amt') || ' POA_MEASURE3,
          nvl(p_purchase_amt,0) POA_MEASURE4,
          nvl(c_purchase_amt,0) POA_MEASURE5';