[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'select v.value VIEWBY,
oset.POA_MEASURE1 POA_MEASURE1, --Non-Contract Purchases Amount
oset.POA_PERCENT1 POA_PERCENT1, --Change
oset.POA_MEASURE3 POA_MEASURE3, --PO Purchases Amount
oset.POA_PERCENT2 POA_PERCENT2, --Non-Contract Rate
oset.POA_MEASURE4 POA_MEASURE4, --Total Non-Contract Purchases Amount
oset.POA_MEASURE5 POA_MEASURE5, --Total PO Purchases Amount
oset.POA_MEASURE6 POA_MEASURE6, --Total Change
oset.POA_MEASURE7 POA_MEASURE7, --Total Non-Contract 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_n_contract_amt,0) POA_MEASURE1,
' || poa_dbi_util_pkg.change_clause('c_n_contract_amt','p_n_contract_amt') || ' POA_PERCENT1,
nvl(c_purchase_amt,0) POA_MEASURE3,
' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt','c_purchase_amt') || ' POA_PERCENT2,
nvl(c_n_contract_amt_total,0) POA_MEASURE4,
nvl(c_purchase_amt_total,0) POA_MEASURE5,
' || poa_dbi_util_pkg.change_clause('c_n_contract_amt_total','p_n_contract_amt_total') || ' POA_MEASURE6,
' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE7';
'select cal.name VIEWBY,
nvl(p_n_contract_amt,0) POA_MEASURE1,
nvl(c_n_contract_amt,0) POA_MEASURE2,
nvl(p_n_contract_amt,0) POA_PERCENT1,
' || poa_dbi_util_pkg.change_clause('c_n_contract_amt','p_n_contract_amt') || ' POA_PERCENT3,
nvl(c_n_contract_amt,0) POA_PERCENT2';