APPS.POA_DBI_PCL_PKG SQL Statements

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

Line: 160

  'select v.value VIEWBY,
          oset.POA_PERCENT1 POA_PERCENT1,
          oset.POA_PERCENT2 POA_PERCENT2,
          oset.POA_PERCENT3 POA_PERCENT3,
          oset.POA_PERCENT4 POA_PERCENT4,
          oset.POA_MEASURE1 POA_MEASURE1,
          oset.POA_MEASURE2 POA_MEASURE2,
          oset.POA_MEASURE3 POA_MEASURE3,
          oset.POA_MEASURE4 POA_MEASURE4 from
   (select * from
     (select org_id,
             ' || poa_dbi_util_pkg.rate_clause('c_p_contract_amt','c_purchase_amt') || ' POA_PERCENT1,
             ' || poa_dbi_util_pkg.rate_clause('p_p_contract_amt','p_purchase_amt') || ' POA_PERCENT2,
             ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt','c_purchase_amt') || ' POA_PERCENT3,
             ' || poa_dbi_util_pkg.rate_clause('p_n_contract_amt','p_purchase_amt') || ' POA_PERCENT4,
             ' || poa_dbi_util_pkg.rate_clause('c_p_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE1,
             ' || poa_dbi_util_pkg.rate_clause('p_p_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE2,
             ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE3,
             ' || poa_dbi_util_pkg.rate_clause('p_n_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE4
   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: 241

  'select v.value VIEWBY,
	oset.POA_MEASURE1 POA_MEASURE1,		--Leakage Amount
	oset.POA_PERCENT1 POA_PERCENT1, 	--Change
	oset.POA_MEASURE3 POA_MEASURE3,		--Leakage Impact Amount
	oset.POA_PERCENT2 POA_PERCENT2,		--Leakage Rate
	oset.POA_MEASURE4 POA_MEASURE4, 	--Total Leakage Amount
	oset.POA_MEASURE5 POA_MEASURE5,		--Total Leakage Impact Amount
	oset.POA_MEASURE6 POA_MEASURE6, 	--Total Change
	oset.POA_MEASURE7 POA_MEASURE7,		-- Total Leakage Rate
           ''' || p_url || ''' POA_MEASURE8
     from
     (select (rank() over
                   (&ORDER_BY_CLAUSE nulls last, ' || p_view_by_col || ')) - 1 rnk,'
        || p_view_by_col || ',
           POA_MEASURE1, POA_PERCENT1, POA_MEASURE3, POA_PERCENT2, POA_MEASURE4,
           POA_MEASURE5, POA_MEASURE6, POA_MEASURE7 from
     (select ' || p_view_by_col || ',
             ' || p_view_by_col || ' VIEWBY,
           nvl(c_p_contract_amt,0) POA_MEASURE1,
           ' || poa_dbi_util_pkg.change_clause('c_p_contract_amt','p_p_contract_amt') || ' POA_PERCENT1,
           nvl(c_p_savings_amt,0) POA_MEASURE3,
           '|| poa_dbi_util_pkg.rate_clause('c_p_contract_amt','c_purchase_amt') ||' POA_PERCENT2,
           nvl(c_p_contract_amt_total,0) POA_MEASURE4,
           nvl(c_p_savings_amt_total,0) POA_MEASURE5,
           '||poa_dbi_util_pkg.change_clause('c_p_contract_amt_total','p_p_contract_amt_total') || ' POA_MEASURE6,
           '||poa_dbi_util_pkg.rate_clause('c_p_contract_amt_total','c_purchase_amt_total')||' POA_MEASURE7';

Line: 281

  'select cal.name VIEWBY,
             nvl(p_p_contract_amt,0) POA_MEASURE1,
             nvl(c_p_contract_amt,0) POA_MEASURE2,
	     nvl(p_p_contract_amt,0) POA_PERCENT1,
          ' || poa_dbi_util_pkg.change_clause('c_p_contract_amt','p_p_contract_amt') || ' POA_PERCENT3,
	     nvl(c_p_contract_amt,0) POA_PERCENT2';