[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'select v.value VIEWBY,
v.id VIEWBYID,
oset.POA_PERCENT1 POA_PERCENT1,
oset.POA_PERCENT2 POA_PERCENT2,
oset.POA_MEASURE1 POA_MEASURE1,
oset.POA_MEASURE2 POA_MEASURE2
from
(select * from
(select ' || l_view_by_col || ',
' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT1,
' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,
' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,
' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2
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);
l_sel_clause := 'select ' || case p_view_by_col_name
when 'inv_d_created_by' then 'decode(v.value, null, fnd_message.get_string(''POA'', ''POA_DBI_APL_UNASSIGNED''), v.value) '
else 'v.value ' end ||
'VIEWBY,
decode(v.id, null, -1, v.id) VIEWBYID,
oset.POA_MEASURE1 POA_MEASURE1, --Manual Distributions
oset.POA_PERCENT1 POA_PERCENT1, --Change
oset.POA_MEASURE3 POA_MEASURE3, --Distributions
oset.POA_PERCENT2 POA_PERCENT2, --Manual Distribution Rate
oset.POA_MEASURE4 POA_MEASURE4, --Total Manual Distributions
oset.POA_MEASURE5 POA_MEASURE5, --Total Distributions
oset.POA_MEASURE6 POA_MEASURE6, --Total Change
oset.POA_MEASURE7 POA_MEASURE7, --Total Manual Distribution Rate
''' || p_url || ''' POA_MEASURE8
from
(select (rank() over
(&ORDER_BY_CLAUSE nulls last, '||p_view_by_col_name||')) - 1 rnk, '||
p_view_by_col_name ||',
POA_MEASURE1, POA_PERCENT1, POA_MEASURE3, POA_PERCENT2, POA_MEASURE4,
POA_MEASURE5, POA_MEASURE6, POA_MEASURE7 from
(select '||p_view_by_col_name||', '||
p_view_by_col_name ||' VIEWBY,
nvl(c_manual_dist_count,0) POA_MEASURE1,
' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT1,
nvl(c_dist_count,0) POA_MEASURE3,
' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count','c_dist_count') || ' POA_PERCENT2,
nvl(c_manual_dist_count_total,0) POA_MEASURE4,
nvl(c_dist_count_total,0) POA_MEASURE5,
' || poa_dbi_util_pkg.change_clause('c_manual_dist_count_total','p_manual_dist_count_total') || ' POA_MEASURE6,
' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE7';
'select cal.name VIEWBY,
nvl(p_manual_dist_count,0) POA_MEASURE1,
nvl(c_manual_dist_count,0) POA_MEASURE2,
nvl(p_manual_dist_count,0) POA_PERCENT1,
' || poa_dbi_util_pkg.change_clause('c_manual_dist_count','p_manual_dist_count') || ' POA_PERCENT3,
nvl(c_manual_dist_count,0) POA_PERCENT2';