eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_FR_PKG dependencies on POA_DBI_UTIL_PKG

Line 30: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

26: procedure status_sql(p_param in bis_pmv_page_parameter_tbl
27: ,x_custom_sql out nocopy varchar2
28: ,x_custom_output out nocopy bis_query_attributes_tbl)
29: is
30: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
31: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
32: l_query varchar2(10000);
33: l_view_by varchar2(120);
34: l_view_by_col varchar2(120);

Line 31: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

27: ,x_custom_sql out nocopy varchar2
28: ,x_custom_output out nocopy bis_query_attributes_tbl)
29: is
30: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
31: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
32: l_query varchar2(10000);
33: l_view_by varchar2(120);
34: l_view_by_col varchar2(120);
35: l_as_of_date date;

Line 41: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

37: l_xtd varchar2(10);
38: l_comparison_type varchar2(1);
39: l_nested_pattern number;
40: l_cur_suffix varchar2(2);
41: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
42: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
43: l_where_clause varchar2(2000);
44: l_mv varchar2(30);
45: l_view_by_value varchar2(30);

Line 42: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

38: l_comparison_type varchar2(1);
39: l_nested_pattern number;
40: l_cur_suffix varchar2(2);
41: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
42: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
43: l_where_clause varchar2(2000);
44: l_mv varchar2(30);
45: l_view_by_value varchar2(30);
46: err_msg varchar2(100);

Line 50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

46: err_msg varchar2(100);
47: err_cde number;
48: begin
49: l_comparison_type := 'Y';
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52:
53: poa_dbi_sutil_pkg.process_parameters(p_param
54: ,l_view_by

Line 51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

47: err_cde number;
48: begin
49: l_comparison_type := 'Y';
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52:
53: poa_dbi_sutil_pkg.process_parameters(p_param
54: ,l_view_by
55: ,l_view_by_col

Line 74: poa_dbi_util_pkg.add_column(l_col_tbl

70: ,p_version => '7.1'
71: ,p_role => 'VPP'
72: ,p_mv_set => 'REQMF');
73:
74: poa_dbi_util_pkg.add_column(l_col_tbl
75: , 'fulfilled_cnt_'||l_cur_suffix
76: , 'fulf_cnt'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 78: , p_prior_code => poa_dbi_util_pkg.both_priors

74: poa_dbi_util_pkg.add_column(l_col_tbl
75: , 'fulfilled_cnt_'||l_cur_suffix
76: , 'fulf_cnt'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.both_priors
79: , p_to_date_type => 'RLX');
80:
81: poa_dbi_util_pkg.add_column(l_col_tbl
82: , 'fulfilled_man_cnt_'||l_cur_suffix

Line 81: poa_dbi_util_pkg.add_column(l_col_tbl

77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.both_priors
79: , p_to_date_type => 'RLX');
80:
81: poa_dbi_util_pkg.add_column(l_col_tbl
82: , 'fulfilled_man_cnt_'||l_cur_suffix
83: , 'fulf_man_cnt'
84: , p_grand_total => 'Y'
85: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 85: , p_prior_code => poa_dbi_util_pkg.both_priors

81: poa_dbi_util_pkg.add_column(l_col_tbl
82: , 'fulfilled_man_cnt_'||l_cur_suffix
83: , 'fulf_man_cnt'
84: , p_grand_total => 'Y'
85: , p_prior_code => poa_dbi_util_pkg.both_priors
86: , p_to_date_type => 'RLX');
87:
88: poa_dbi_util_pkg.add_column(l_col_tbl
89: , 'fulfilled_ped_cnt'

Line 88: poa_dbi_util_pkg.add_column(l_col_tbl

84: , p_grand_total => 'Y'
85: , p_prior_code => poa_dbi_util_pkg.both_priors
86: , p_to_date_type => 'RLX');
87:
88: poa_dbi_util_pkg.add_column(l_col_tbl
89: , 'fulfilled_ped_cnt'
90: , 'fulf_ped_cnt'
91: , p_grand_total => 'Y'
92: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 92: , p_prior_code => poa_dbi_util_pkg.both_priors

88: poa_dbi_util_pkg.add_column(l_col_tbl
89: , 'fulfilled_ped_cnt'
90: , 'fulf_ped_cnt'
91: , p_grand_total => 'Y'
92: , p_prior_code => poa_dbi_util_pkg.both_priors
93: , p_to_date_type => 'RLX');
94:
95: poa_dbi_util_pkg.add_column(l_col_tbl
96: , 'fulfilled_amt_'||l_cur_suffix

Line 95: poa_dbi_util_pkg.add_column(l_col_tbl

91: , p_grand_total => 'Y'
92: , p_prior_code => poa_dbi_util_pkg.both_priors
93: , p_to_date_type => 'RLX');
94:
95: poa_dbi_util_pkg.add_column(l_col_tbl
96: , 'fulfilled_amt_'||l_cur_suffix
97: , 'fulf_amt'
98: , p_grand_total => 'Y'
99: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 99: , p_prior_code => poa_dbi_util_pkg.both_priors

95: poa_dbi_util_pkg.add_column(l_col_tbl
96: , 'fulfilled_amt_'||l_cur_suffix
97: , 'fulf_amt'
98: , p_grand_total => 'Y'
99: , p_prior_code => poa_dbi_util_pkg.both_priors
100: , p_to_date_type => 'RLX');
101:
102: poa_dbi_util_pkg.add_column(l_col_tbl
103: , 'days_to_fulfill'

Line 102: poa_dbi_util_pkg.add_column(l_col_tbl

98: , p_grand_total => 'Y'
99: , p_prior_code => poa_dbi_util_pkg.both_priors
100: , p_to_date_type => 'RLX');
101:
102: poa_dbi_util_pkg.add_column(l_col_tbl
103: , 'days_to_fulfill'
104: , 'days_fulf'
105: , p_grand_total => 'Y'
106: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 106: , p_prior_code => poa_dbi_util_pkg.both_priors

102: poa_dbi_util_pkg.add_column(l_col_tbl
103: , 'days_to_fulfill'
104: , 'days_fulf'
105: , p_grand_total => 'Y'
106: , p_prior_code => poa_dbi_util_pkg.both_priors
107: , p_to_date_type => 'RLX');
108:
109: if(l_view_by = 'ITEM+POA_ITEMS') then
110: poa_dbi_util_pkg.add_column(l_col_tbl

Line 110: poa_dbi_util_pkg.add_column(l_col_tbl

106: , p_prior_code => poa_dbi_util_pkg.both_priors
107: , p_to_date_type => 'RLX');
108:
109: if(l_view_by = 'ITEM+POA_ITEMS') then
110: poa_dbi_util_pkg.add_column(l_col_tbl
111: ,'fulfilled_qty'
112: ,'fulf_qty'
113: , p_grand_total => 'Y'
114: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 114: , p_prior_code => poa_dbi_util_pkg.both_priors

110: poa_dbi_util_pkg.add_column(l_col_tbl
111: ,'fulfilled_qty'
112: ,'fulf_qty'
113: , p_grand_total => 'Y'
114: , p_prior_code => poa_dbi_util_pkg.both_priors
115: , p_to_date_type => 'RLX');
116: end if;
117:
118: l_query := get_status_sel_clause(l_view_by, l_view_by_col) || ' from ';

Line 246: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,

242:
243: l_sel_clause := l_sel_clause || '
244: nvl(c_fulf_cnt,0) POA_MEASURE1,
245: nvl(p_fulf_cnt,0) POA_MEASURE10,
246: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
247: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),

Line 248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,

244: nvl(c_fulf_cnt,0) POA_MEASURE1,
245: nvl(p_fulf_cnt,0) POA_MEASURE10,
246: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
247: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,

Line 249: '||poa_dbi_util_pkg.change_clause(

245: nvl(p_fulf_cnt,0) POA_MEASURE10,
246: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
247: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,

Line 250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),

246: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
247: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,

Line 251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,

247: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,

Line 252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,

248: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||

Line 253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,

249: '||poa_dbi_util_pkg.change_clause(
250: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
251: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||
257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||

Line 256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||

252: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||
257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||
258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,
259: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt, 0) POA_MEASURE5,
260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,

Line 257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||

253: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P')||' POA_PERCENT11,
254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||
257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||
258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,
259: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt, 0) POA_MEASURE5,
260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
261: nvl(p_fulf_cnt_total,0) POA_MEASURE13,

Line 258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,

254: nvl(c_fulf_amt,0) POA_MEASURE3,
255: nvl(p_fulf_amt,0) POA_MEASURE11,
256: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT5, ' || fnd_global.newline ||
257: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP') || ' POA_MEASURE4, ' || fnd_global.newline ||
258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,
259: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt, 0) POA_MEASURE5,
260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
261: nvl(p_fulf_cnt_total,0) POA_MEASURE13,
262: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,

Line 262: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,

258: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP') || ' POA_MEASURE12,
259: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt, 0) POA_MEASURE5,
260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
261: nvl(p_fulf_cnt_total,0) POA_MEASURE13,
262: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
263: nvl(c_fulf_man_cnt_total,0) POA_MEASURE7,
264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,
265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),

Line 264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,

260: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
261: nvl(p_fulf_cnt_total,0) POA_MEASURE13,
262: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
263: nvl(c_fulf_man_cnt_total,0) POA_MEASURE7,
264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,
265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,

Line 265: '||poa_dbi_util_pkg.change_clause(

261: nvl(p_fulf_cnt_total,0) POA_MEASURE13,
262: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
263: nvl(c_fulf_man_cnt_total,0) POA_MEASURE7,
264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,
265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,

Line 266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),

262: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
263: nvl(c_fulf_man_cnt_total,0) POA_MEASURE7,
264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,
265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,

Line 267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,

263: nvl(c_fulf_man_cnt_total,0) POA_MEASURE7,
264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,
265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||

Line 268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,

264: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT7,
265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||

Line 269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,

265: '||poa_dbi_util_pkg.change_clause(
266: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
267: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT8,
268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||

Line 272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||

268: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT9,
269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||
274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15
275: ';
276:

Line 273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||

269: '||poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt_total','p_fulf_cnt_total','P')||' POA_PERCENT12,
270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||
274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15
275: ';
276:
277: return l_sel_clause;

Line 274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15

270: nvl(c_fulf_amt_total,0) POA_MEASURE8,
271: nvl(p_fulf_amt_total,0) POA_MEASURE14,' || fnd_global.newline ||
272: poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP') || ' POA_PERCENT10,' || fnd_global.newline ||
273: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP') || ' POA_MEASURE9,' || fnd_global.newline ||
274: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP') || ' POA_MEASURE15
275: ';
276:
277: return l_sel_clause;
278: end;

Line 318: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

314: ,x_custom_sql out nocopy varchar2
315: ,x_custom_output out nocopy bis_query_attributes_tbl)
316: is
317: err_msg varchar2(100);
318: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
319: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
320: l_query varchar2(10000);
321: l_view_by varchar2(120);
322: l_view_by_col varchar2(120);

Line 319: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

315: ,x_custom_output out nocopy bis_query_attributes_tbl)
316: is
317: err_msg varchar2(100);
318: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
319: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
320: l_query varchar2(10000);
321: l_view_by varchar2(120);
322: l_view_by_col varchar2(120);
323: l_as_of_date date;

Line 329: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

325: l_xtd varchar2(10);
326: l_comparison_type varchar2(1);
327: l_nested_pattern number;
328: l_cur_suffix varchar2(2);
329: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
330: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
331: l_where_clause varchar2(2000);
332: l_mv varchar2(30);
333: l_view_by_value varchar2(30);

Line 330: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

326: l_comparison_type varchar2(1);
327: l_nested_pattern number;
328: l_cur_suffix varchar2(2);
329: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
330: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
331: l_where_clause varchar2(2000);
332: l_mv varchar2(30);
333: l_view_by_value varchar2(30);
334: err_cde number;

Line 337: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

333: l_view_by_value varchar2(30);
334: err_cde number;
335: begin
336: l_comparison_type := 'Y';
337: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
338: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
339:
340: poa_dbi_sutil_pkg.process_parameters(p_param
341: ,l_view_by

Line 338: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

334: err_cde number;
335: begin
336: l_comparison_type := 'Y';
337: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
338: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
339:
340: poa_dbi_sutil_pkg.process_parameters(p_param
341: ,l_view_by
342: ,l_view_by_col

Line 361: poa_dbi_util_pkg.add_column(l_col_tbl

357: ,p_version => '7.1'
358: ,p_role => 'VPP'
359: ,p_mv_set => 'REQMF');
360:
361: poa_dbi_util_pkg.add_column(l_col_tbl
362: , 'fulfilled_cnt_'||l_cur_suffix
363: , 'fulf_cnt'
364: , p_grand_total => 'Y'
365: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 365: , p_prior_code => poa_dbi_util_pkg.both_priors

361: poa_dbi_util_pkg.add_column(l_col_tbl
362: , 'fulfilled_cnt_'||l_cur_suffix
363: , 'fulf_cnt'
364: , p_grand_total => 'Y'
365: , p_prior_code => poa_dbi_util_pkg.both_priors
366: , p_to_date_type => 'RLX');
367:
368: poa_dbi_util_pkg.add_column(l_col_tbl
369: , 'fulfilled_man_cnt_'||l_cur_suffix

Line 368: poa_dbi_util_pkg.add_column(l_col_tbl

364: , p_grand_total => 'Y'
365: , p_prior_code => poa_dbi_util_pkg.both_priors
366: , p_to_date_type => 'RLX');
367:
368: poa_dbi_util_pkg.add_column(l_col_tbl
369: , 'fulfilled_man_cnt_'||l_cur_suffix
370: , 'fulf_man_cnt'
371: , p_grand_total => 'Y'
372: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 372: , p_prior_code => poa_dbi_util_pkg.both_priors

368: poa_dbi_util_pkg.add_column(l_col_tbl
369: , 'fulfilled_man_cnt_'||l_cur_suffix
370: , 'fulf_man_cnt'
371: , p_grand_total => 'Y'
372: , p_prior_code => poa_dbi_util_pkg.both_priors
373: , p_to_date_type => 'RLX');
374:
375: poa_dbi_util_pkg.add_column(l_col_tbl
376: , 'fulfilled_ped_cnt'

Line 375: poa_dbi_util_pkg.add_column(l_col_tbl

371: , p_grand_total => 'Y'
372: , p_prior_code => poa_dbi_util_pkg.both_priors
373: , p_to_date_type => 'RLX');
374:
375: poa_dbi_util_pkg.add_column(l_col_tbl
376: , 'fulfilled_ped_cnt'
377: , 'fulf_ped_cnt'
378: , p_grand_total => 'Y'
379: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 379: , p_prior_code => poa_dbi_util_pkg.both_priors

375: poa_dbi_util_pkg.add_column(l_col_tbl
376: , 'fulfilled_ped_cnt'
377: , 'fulf_ped_cnt'
378: , p_grand_total => 'Y'
379: , p_prior_code => poa_dbi_util_pkg.both_priors
380: , p_to_date_type => 'RLX');
381:
382: if(l_view_by = 'ITEM+POA_ITEMS') then
383: poa_dbi_util_pkg.add_column(l_col_tbl

Line 383: poa_dbi_util_pkg.add_column(l_col_tbl

379: , p_prior_code => poa_dbi_util_pkg.both_priors
380: , p_to_date_type => 'RLX');
381:
382: if(l_view_by = 'ITEM+POA_ITEMS') then
383: poa_dbi_util_pkg.add_column(l_col_tbl
384: ,'fulfilled_qty'
385: ,'fulf_qty'
386: , p_grand_total => 'Y'
387: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 387: , p_prior_code => poa_dbi_util_pkg.both_priors

383: poa_dbi_util_pkg.add_column(l_col_tbl
384: ,'fulfilled_qty'
385: ,'fulf_qty'
386: , p_grand_total => 'Y'
387: , p_prior_code => poa_dbi_util_pkg.both_priors
388: , p_to_date_type => 'RLX');
389: end if;
390:
391: l_query := get_summary_sel_clause(l_view_by, l_view_by_col) || ' from ';

Line 494: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,

490: end if;
491:
492: l_sel_clause := l_sel_clause || '
493: nvl(c_fulf_cnt,0) POA_MEASURE1,
494: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
495: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
496: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
497: '||poa_dbi_util_pkg.change_clause(
498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),

Line 496: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,

492: l_sel_clause := l_sel_clause || '
493: nvl(c_fulf_cnt,0) POA_MEASURE1,
494: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
495: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
496: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
497: '||poa_dbi_util_pkg.change_clause(
498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
499: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
500: nvl(c_fulf_ped_cnt,0) POA_PERCENT4,

Line 497: '||poa_dbi_util_pkg.change_clause(

493: nvl(c_fulf_cnt,0) POA_MEASURE1,
494: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
495: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
496: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
497: '||poa_dbi_util_pkg.change_clause(
498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
499: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
500: nvl(c_fulf_ped_cnt,0) POA_PERCENT4,
501: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_MEASURE3,

Line 498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),

494: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT1,
495: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
496: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
497: '||poa_dbi_util_pkg.change_clause(
498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
499: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
500: nvl(c_fulf_ped_cnt,0) POA_PERCENT4,
501: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_MEASURE3,
502: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt,0) POA_MEASURE4,

Line 499: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,

495: nvl(c_fulf_man_cnt,0) POA_MEASURE2,
496: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT2,
497: '||poa_dbi_util_pkg.change_clause(
498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
499: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
500: nvl(c_fulf_ped_cnt,0) POA_PERCENT4,
501: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_MEASURE3,
502: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt,0) POA_MEASURE4,
503: nvl(c_fulf_cnt_total,0) POA_MEASURE5,

Line 501: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_MEASURE3,

497: '||poa_dbi_util_pkg.change_clause(
498: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
499: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),'P')||' POA_PERCENT3,
500: nvl(c_fulf_ped_cnt,0) POA_PERCENT4,
501: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_MEASURE3,
502: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt,0) POA_MEASURE4,
503: nvl(c_fulf_cnt_total,0) POA_MEASURE5,
504: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT5,
505: nvl(c_fulf_man_cnt_total,0) POA_MEASURE6,

Line 504: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT5,

500: nvl(c_fulf_ped_cnt,0) POA_PERCENT4,
501: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P')||' POA_MEASURE3,
502: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt,0) POA_MEASURE4,
503: nvl(c_fulf_cnt_total,0) POA_MEASURE5,
504: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT5,
505: nvl(c_fulf_man_cnt_total,0) POA_MEASURE6,
506: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT6,
507: '||poa_dbi_util_pkg.change_clause(
508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),

Line 506: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT6,

502: nvl(c_fulf_cnt,0) - nvl(c_fulf_man_cnt,0) POA_MEASURE4,
503: nvl(c_fulf_cnt_total,0) POA_MEASURE5,
504: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT5,
505: nvl(c_fulf_man_cnt_total,0) POA_MEASURE6,
506: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT6,
507: '||poa_dbi_util_pkg.change_clause(
508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
509: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT7,
510: nvl(c_fulf_ped_cnt_total,0) POA_PERCENT8,

Line 507: '||poa_dbi_util_pkg.change_clause(

503: nvl(c_fulf_cnt_total,0) POA_MEASURE5,
504: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT5,
505: nvl(c_fulf_man_cnt_total,0) POA_MEASURE6,
506: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT6,
507: '||poa_dbi_util_pkg.change_clause(
508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
509: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT7,
510: nvl(c_fulf_ped_cnt_total,0) POA_PERCENT8,
511: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_MEASURE7

Line 508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),

504: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT5,
505: nvl(c_fulf_man_cnt_total,0) POA_MEASURE6,
506: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT6,
507: '||poa_dbi_util_pkg.change_clause(
508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
509: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT7,
510: nvl(c_fulf_ped_cnt_total,0) POA_PERCENT8,
511: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_MEASURE7
512: ';

Line 509: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT7,

505: nvl(c_fulf_man_cnt_total,0) POA_MEASURE6,
506: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT6,
507: '||poa_dbi_util_pkg.change_clause(
508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
509: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT7,
510: nvl(c_fulf_ped_cnt_total,0) POA_PERCENT8,
511: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_MEASURE7
512: ';
513:

Line 511: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_MEASURE7

507: '||poa_dbi_util_pkg.change_clause(
508: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
509: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),'P')||' POA_PERCENT7,
510: nvl(c_fulf_ped_cnt_total,0) POA_PERCENT8,
511: '||poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt_total','c_fulf_cnt_total','P')||' POA_MEASURE7
512: ';
513:
514: return l_sel_clause;
515: end;

Line 549: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

545: ,x_custom_sql out nocopy varchar2
546: ,x_custom_output out nocopy bis_query_attributes_tbl)
547: is
548: err_msg varchar2(100);
549: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
550: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
551: l_query varchar2(10000);
552: l_view_by varchar2(120);
553: l_view_by_col varchar2(120);

Line 550: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

546: ,x_custom_output out nocopy bis_query_attributes_tbl)
547: is
548: err_msg varchar2(100);
549: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
550: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
551: l_query varchar2(10000);
552: l_view_by varchar2(120);
553: l_view_by_col varchar2(120);
554: l_as_of_date date;

Line 560: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

556: l_xtd varchar2(10);
557: l_comparison_type varchar2(1);
558: l_nested_pattern number;
559: l_cur_suffix varchar2(2);
560: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
561: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
562: l_where_clause varchar2(2000);
563: l_mv varchar2(30);
564: l_view_by_value varchar2(30);

Line 561: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

557: l_comparison_type varchar2(1);
558: l_nested_pattern number;
559: l_cur_suffix varchar2(2);
560: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
561: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
562: l_where_clause varchar2(2000);
563: l_mv varchar2(30);
564: l_view_by_value varchar2(30);
565: err_cde number;

Line 569: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

565: err_cde number;
566: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
567: begin
568: l_comparison_type := 'Y';
569: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
570: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
571:
572: poa_dbi_sutil_pkg.process_parameters(p_param
573: ,l_view_by

Line 570: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

566: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
567: begin
568: l_comparison_type := 'Y';
569: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
570: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
571:
572: poa_dbi_sutil_pkg.process_parameters(p_param
573: ,l_view_by
574: ,l_view_by_col

Line 593: poa_dbi_util_pkg.add_column(l_col_tbl

589: ,p_version => '7.1'
590: ,p_role => 'VPP'
591: ,p_mv_set => 'REQMF');
592:
593: poa_dbi_util_pkg.add_column(l_col_tbl
594: , 'fulfilled_amt_'||l_cur_suffix
595: , 'fulf_amt'
596: , p_grand_total => 'Y'
597: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 597: , p_prior_code => poa_dbi_util_pkg.both_priors

593: poa_dbi_util_pkg.add_column(l_col_tbl
594: , 'fulfilled_amt_'||l_cur_suffix
595: , 'fulf_amt'
596: , p_grand_total => 'Y'
597: , p_prior_code => poa_dbi_util_pkg.both_priors
598: , p_to_date_type => 'RLX');
599:
600: poa_dbi_util_pkg.add_column(l_col_tbl
601: , 'fulfilled_man_amt_'||l_cur_suffix

Line 600: poa_dbi_util_pkg.add_column(l_col_tbl

596: , p_grand_total => 'Y'
597: , p_prior_code => poa_dbi_util_pkg.both_priors
598: , p_to_date_type => 'RLX');
599:
600: poa_dbi_util_pkg.add_column(l_col_tbl
601: , 'fulfilled_man_amt_'||l_cur_suffix
602: , 'fulf_man_amt'
603: , p_grand_total => 'Y'
604: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 604: , p_prior_code => poa_dbi_util_pkg.both_priors

600: poa_dbi_util_pkg.add_column(l_col_tbl
601: , 'fulfilled_man_amt_'||l_cur_suffix
602: , 'fulf_man_amt'
603: , p_grand_total => 'Y'
604: , p_prior_code => poa_dbi_util_pkg.both_priors
605: , p_to_date_type => 'RLX');
606:
607: poa_dbi_util_pkg.add_bucket_columns(
608: p_short_name => 'POA_DBI_FR_BUCKET'

Line 607: poa_dbi_util_pkg.add_bucket_columns(

603: , p_grand_total => 'Y'
604: , p_prior_code => poa_dbi_util_pkg.both_priors
605: , p_to_date_type => 'RLX');
606:
607: poa_dbi_util_pkg.add_bucket_columns(
608: p_short_name => 'POA_DBI_FR_BUCKET'
609: ,p_col_tbl => l_col_tbl
610: ,p_col_name => 'fulfilled_amt_'||l_cur_suffix||'_age'
611: ,p_alias_name => 'fulf_amt_age'

Line 614: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS

610: ,p_col_name => 'fulfilled_amt_'||l_cur_suffix||'_age'
611: ,p_alias_name => 'fulf_amt_age'
612: ,x_bucket_rec => l_bucket_rec
613: ,p_grand_total => 'Y'
614: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
615: ,p_to_date_type => 'RLX');
616:
617: if(l_view_by = 'ITEM+POA_ITEMS') then
618: poa_dbi_util_pkg.add_column(l_col_tbl

Line 618: poa_dbi_util_pkg.add_column(l_col_tbl

614: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
615: ,p_to_date_type => 'RLX');
616:
617: if(l_view_by = 'ITEM+POA_ITEMS') then
618: poa_dbi_util_pkg.add_column(l_col_tbl
619: ,'fulfilled_qty'
620: ,'fulf_qty'
621: , p_grand_total => 'Y'
622: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 622: , p_prior_code => poa_dbi_util_pkg.both_priors

618: poa_dbi_util_pkg.add_column(l_col_tbl
619: ,'fulfilled_qty'
620: ,'fulf_qty'
621: , p_grand_total => 'Y'
622: , p_prior_code => poa_dbi_util_pkg.both_priors
623: , p_to_date_type => 'RLX');
624: end if;
625:
626: l_query := get_amt_sql_sel_clause(l_view_by, l_view_by_col,l_bucket_rec) || ' from ';

Line 671: || poa_dbi_util_pkg.get_bucket_outer_query(

667: oset.POA_PERCENT1 POA_PERCENT1, --fulf amt Change
668: oset.POA_MEASURE2 POA_MEASURE2, --Manual Amount
669: oset.POA_PERCENT2 POA_PERCENT2, --Manual Amount Rate
670: oset.POA_PERCENT3 POA_PERCENT3 --Man Amt Rate Change ' || fnd_global.newline
671: || poa_dbi_util_pkg.get_bucket_outer_query(
672: p_bucket_rec
673: , p_col_name => 'oset.POA_PERCENT4'
674: , p_alias_name => 'POA_PERCENT4'
675: , p_prefix => ''

Line 684: poa_dbi_util_pkg.get_bucket_outer_query(

680: oset.POA_MEASURE4 POA_MEASURE4, --Grand Total for Manual Amount
681: oset.POA_PERCENT6 POA_PERCENT6, --Grand Total for Manual Amount Rate
682: oset.POA_PERCENT7 POA_PERCENT7 --Grand tot for man amt rate change '
683: || fnd_global.newline ||
684: poa_dbi_util_pkg.get_bucket_outer_query(
685: p_bucket_rec
686: , p_col_name => 'oset.POA_PERCENT8'
687: , p_alias_name => 'POA_PERCENT8'
688: , p_prefix => ''

Line 693: poa_dbi_util_pkg.get_bucket_drill_url(

689: , p_suffix => ''
690: , p_total_flag => 'N') || fnd_global.newline;
691:
692: l_sel_clause := l_sel_clause ||
693: poa_dbi_util_pkg.get_bucket_drill_url(
694: p_bucket_rec
695: , 'POA_ATTRIBUTE6'
696: , '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=1&POA_BUCKET+REQUISITION_AGING='
697: , ''''

Line 720: '|| poa_dbi_util_pkg.get_bucket_outer_query(

716: POA_PERCENT1,
717: POA_MEASURE2,
718: POA_PERCENT2,
719: POA_PERCENT3
720: '|| poa_dbi_util_pkg.get_bucket_outer_query(
721: p_bucket_rec
722: , p_col_name => 'POA_PERCENT4'
723: , p_alias_name => 'POA_PERCENT4'
724: , p_prefix => ''

Line 732: '|| poa_dbi_util_pkg.get_bucket_outer_query(

728: POA_PERCENT5,
729: POA_MEASURE4,
730: POA_PERCENT6,
731: POA_PERCENT7
732: '|| poa_dbi_util_pkg.get_bucket_outer_query(
733: p_bucket_rec
734: , p_col_name => 'POA_PERCENT8'
735: , p_alias_name => 'POA_PERCENT8'
736: , p_prefix => ''

Line 751: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT1,

747: end if;
748:
749: l_sel_clause := l_sel_clause || '
750: nvl(c_fulf_amt,0) POA_MEASURE1,
751: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT1,
752: nvl(c_fulf_man_amt,0) POA_MEASURE2,
753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,
754: '||poa_dbi_util_pkg.change_clause(
755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),

Line 753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,

749: l_sel_clause := l_sel_clause || '
750: nvl(c_fulf_amt,0) POA_MEASURE1,
751: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT1,
752: nvl(c_fulf_man_amt,0) POA_MEASURE2,
753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,
754: '||poa_dbi_util_pkg.change_clause(
755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),
756: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt','P'),'P')||' POA_PERCENT3
757: '|| poa_dbi_util_pkg.get_bucket_outer_query(

Line 754: '||poa_dbi_util_pkg.change_clause(

750: nvl(c_fulf_amt,0) POA_MEASURE1,
751: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT1,
752: nvl(c_fulf_man_amt,0) POA_MEASURE2,
753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,
754: '||poa_dbi_util_pkg.change_clause(
755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),
756: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt','P'),'P')||' POA_PERCENT3
757: '|| poa_dbi_util_pkg.get_bucket_outer_query(
758: p_bucket_rec

Line 755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),

751: '||poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP')||' POA_PERCENT1,
752: nvl(c_fulf_man_amt,0) POA_MEASURE2,
753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,
754: '||poa_dbi_util_pkg.change_clause(
755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),
756: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt','P'),'P')||' POA_PERCENT3
757: '|| poa_dbi_util_pkg.get_bucket_outer_query(
758: p_bucket_rec
759: , p_col_name => 'c_fulf_amt_age'

Line 756: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt','P'),'P')||' POA_PERCENT3

752: nvl(c_fulf_man_amt,0) POA_MEASURE2,
753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,
754: '||poa_dbi_util_pkg.change_clause(
755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),
756: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt','P'),'P')||' POA_PERCENT3
757: '|| poa_dbi_util_pkg.get_bucket_outer_query(
758: p_bucket_rec
759: , p_col_name => 'c_fulf_amt_age'
760: , p_alias_name => 'POA_PERCENT4'

Line 757: '|| poa_dbi_util_pkg.get_bucket_outer_query(

753: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P')||' POA_PERCENT2,
754: '||poa_dbi_util_pkg.change_clause(
755: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt','P'),
756: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt','P'),'P')||' POA_PERCENT3
757: '|| poa_dbi_util_pkg.get_bucket_outer_query(
758: p_bucket_rec
759: , p_col_name => 'c_fulf_amt_age'
760: , p_alias_name => 'POA_PERCENT4'
761: , p_prefix => 'nvl('

Line 765: '||poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP')||' POA_PERCENT5,

761: , p_prefix => 'nvl('
762: , p_suffix => ',0)'
763: , p_total_flag => 'N') ||',
764: nvl(c_fulf_amt_total,0) POA_MEASURE3,
765: '||poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP')||' POA_PERCENT5,
766: nvl(c_fulf_man_amt_total,0) POA_MEASURE4,
767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,
768: '||poa_dbi_util_pkg.change_clause(
769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),

Line 767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,

763: , p_total_flag => 'N') ||',
764: nvl(c_fulf_amt_total,0) POA_MEASURE3,
765: '||poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP')||' POA_PERCENT5,
766: nvl(c_fulf_man_amt_total,0) POA_MEASURE4,
767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,
768: '||poa_dbi_util_pkg.change_clause(
769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),
770: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt_total','p_fulf_amt_total','P'),'P')||' POA_PERCENT7
771: '|| poa_dbi_util_pkg.get_bucket_outer_query(

Line 768: '||poa_dbi_util_pkg.change_clause(

764: nvl(c_fulf_amt_total,0) POA_MEASURE3,
765: '||poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP')||' POA_PERCENT5,
766: nvl(c_fulf_man_amt_total,0) POA_MEASURE4,
767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,
768: '||poa_dbi_util_pkg.change_clause(
769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),
770: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt_total','p_fulf_amt_total','P'),'P')||' POA_PERCENT7
771: '|| poa_dbi_util_pkg.get_bucket_outer_query(
772: p_bucket_rec

Line 769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),

765: '||poa_dbi_util_pkg.change_clause('c_fulf_amt_total','p_fulf_amt_total','NP')||' POA_PERCENT5,
766: nvl(c_fulf_man_amt_total,0) POA_MEASURE4,
767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,
768: '||poa_dbi_util_pkg.change_clause(
769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),
770: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt_total','p_fulf_amt_total','P'),'P')||' POA_PERCENT7
771: '|| poa_dbi_util_pkg.get_bucket_outer_query(
772: p_bucket_rec
773: , p_col_name => 'c_fulf_amt_age'

Line 770: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt_total','p_fulf_amt_total','P'),'P')||' POA_PERCENT7

766: nvl(c_fulf_man_amt_total,0) POA_MEASURE4,
767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,
768: '||poa_dbi_util_pkg.change_clause(
769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),
770: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt_total','p_fulf_amt_total','P'),'P')||' POA_PERCENT7
771: '|| poa_dbi_util_pkg.get_bucket_outer_query(
772: p_bucket_rec
773: , p_col_name => 'c_fulf_amt_age'
774: , p_alias_name => 'POA_PERCENT8'

Line 771: '|| poa_dbi_util_pkg.get_bucket_outer_query(

767: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P')||' POA_PERCENT6,
768: '||poa_dbi_util_pkg.change_clause(
769: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt_total','c_fulf_amt_total','P'),
770: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt_total','p_fulf_amt_total','P'),'P')||' POA_PERCENT7
771: '|| poa_dbi_util_pkg.get_bucket_outer_query(
772: p_bucket_rec
773: , p_col_name => 'c_fulf_amt_age'
774: , p_alias_name => 'POA_PERCENT8'
775: , p_prefix => 'nvl('

Line 814: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

810: l_query varchar2(10000);
811: l_option number;
812: l_cur_suffix varchar2(2);
813: l_where_clause varchar2(2000);
814: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
815: l_in_join_tables varchar2(240) ;
816: l_xtd varchar2(10);
817: err_msg varchar2(100);
818: l_bucket varchar2(50);

Line 844: poa_dbi_util_pkg.bind_low_high(p_param

840: || 'and (&RANGE_HIGH is null or '
841: || 'greatest(0,(fact.req_fulfilled_date-fact.req_approved_date))'
842: || ' < &RANGE_HIGH)';
843:
844: poa_dbi_util_pkg.bind_low_high(p_param
845: , 'POA_DBI_FR_BUCKET'
846: , 'POA_BUCKET+REQUISITION_AGING'
847: , '&RANGE_LOW'
848: , '&RANGE_HIGH'

Line 867: -- and orgl.security_profile_id=' || poa_dbi_util_pkg.get_sec_profile ||

863: --- having a security clause
864: -- per_organization_list orgl
865: -- where
866: -- fact.org_id=orgl.organization_id
867: -- and orgl.security_profile_id=' || poa_dbi_util_pkg.get_sec_profile ||
868: ---End MOAC changes
869:
870: x_custom_sql := '
871: select

Line 957: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);

953: and poh.org_id=porg.organization_id(+)
954: and (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
955: ORDER BY rnk ';
956:
957: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
958: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);
959: exception
960: when others then
961: err_msg := substr(sqlerrm,1,400);

Line 958: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);

954: and (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
955: ORDER BY rnk ';
956:
957: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
958: poa_dbi_util_pkg.get_custom_rolling_binds(x_custom_output,l_xtd);
959: exception
960: when others then
961: err_msg := substr(sqlerrm,1,400);
962: end;

Line 970: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

966: ,x_custom_sql out nocopy varchar2
967: ,x_custom_output out nocopy bis_query_attributes_tbl)
968: is
969: err_msg varchar2(100);
970: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
971: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
972: l_query varchar2(10000);
973: l_view_by varchar2(120);
974: l_view_by_col varchar2(120);

Line 971: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

967: ,x_custom_output out nocopy bis_query_attributes_tbl)
968: is
969: err_msg varchar2(100);
970: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
971: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
972: l_query varchar2(10000);
973: l_view_by varchar2(120);
974: l_view_by_col varchar2(120);
975: l_as_of_date date;

Line 981: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

977: l_xtd varchar2(10);
978: l_comparison_type varchar2(1);
979: l_nested_pattern number;
980: l_cur_suffix varchar2(2);
981: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
982: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
983: l_where_clause varchar2(2000);
984: l_mv varchar2(30);
985: l_view_by_value varchar2(30);

Line 982: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;

978: l_comparison_type varchar2(1);
979: l_nested_pattern number;
980: l_cur_suffix varchar2(2);
981: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
982: l_join_rec poa_dbi_util_pkg.poa_dbi_join_rec;
983: l_where_clause varchar2(2000);
984: l_mv varchar2(30);
985: l_view_by_value varchar2(30);
986: err_cde number;

Line 990: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();

986: err_cde number;
987: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
988: begin
989: l_comparison_type := 'Y';
990: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
991: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
992:
993: poa_dbi_sutil_pkg.process_parameters(p_param
994: ,l_view_by

Line 991: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();

987: l_bucket_rec bis_bucket_pub.bis_bucket_rec_type;
988: begin
989: l_comparison_type := 'Y';
990: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
991: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
992:
993: poa_dbi_sutil_pkg.process_parameters(p_param
994: ,l_view_by
995: ,l_view_by_col

Line 1014: poa_dbi_util_pkg.add_column(l_col_tbl

1010: ,p_version => '7.1'
1011: ,p_role => 'VPP'
1012: ,p_mv_set => 'REQMF');
1013:
1014: poa_dbi_util_pkg.add_column(l_col_tbl
1015: , 'days_to_fulfill'
1016: , 'days_fulf'
1017: , p_grand_total => 'Y'
1018: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1018: , p_prior_code => poa_dbi_util_pkg.both_priors

1014: poa_dbi_util_pkg.add_column(l_col_tbl
1015: , 'days_to_fulfill'
1016: , 'days_fulf'
1017: , p_grand_total => 'Y'
1018: , p_prior_code => poa_dbi_util_pkg.both_priors
1019: , p_to_date_type => 'RLX');
1020:
1021: poa_dbi_util_pkg.add_column(l_col_tbl
1022: , 'fulfilled_cnt_'||l_cur_suffix

Line 1021: poa_dbi_util_pkg.add_column(l_col_tbl

1017: , p_grand_total => 'Y'
1018: , p_prior_code => poa_dbi_util_pkg.both_priors
1019: , p_to_date_type => 'RLX');
1020:
1021: poa_dbi_util_pkg.add_column(l_col_tbl
1022: , 'fulfilled_cnt_'||l_cur_suffix
1023: , 'fulf_cnt'
1024: , p_grand_total => 'Y'
1025: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1025: , p_prior_code => poa_dbi_util_pkg.both_priors

1021: poa_dbi_util_pkg.add_column(l_col_tbl
1022: , 'fulfilled_cnt_'||l_cur_suffix
1023: , 'fulf_cnt'
1024: , p_grand_total => 'Y'
1025: , p_prior_code => poa_dbi_util_pkg.both_priors
1026: , p_to_date_type => 'RLX');
1027:
1028: poa_dbi_util_pkg.add_column(l_col_tbl
1029: , 'fulfilled_man_cnt_'||l_cur_suffix

Line 1028: poa_dbi_util_pkg.add_column(l_col_tbl

1024: , p_grand_total => 'Y'
1025: , p_prior_code => poa_dbi_util_pkg.both_priors
1026: , p_to_date_type => 'RLX');
1027:
1028: poa_dbi_util_pkg.add_column(l_col_tbl
1029: , 'fulfilled_man_cnt_'||l_cur_suffix
1030: , 'fulf_man_cnt'
1031: , p_grand_total => 'Y'
1032: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1032: , p_prior_code => poa_dbi_util_pkg.both_priors

1028: poa_dbi_util_pkg.add_column(l_col_tbl
1029: , 'fulfilled_man_cnt_'||l_cur_suffix
1030: , 'fulf_man_cnt'
1031: , p_grand_total => 'Y'
1032: , p_prior_code => poa_dbi_util_pkg.both_priors
1033: , p_to_date_type => 'RLX');
1034:
1035: if(l_view_by = 'ITEM+POA_ITEMS') then
1036: poa_dbi_util_pkg.add_column(l_col_tbl

Line 1036: poa_dbi_util_pkg.add_column(l_col_tbl

1032: , p_prior_code => poa_dbi_util_pkg.both_priors
1033: , p_to_date_type => 'RLX');
1034:
1035: if(l_view_by = 'ITEM+POA_ITEMS') then
1036: poa_dbi_util_pkg.add_column(l_col_tbl
1037: ,'fulfilled_qty'
1038: ,'fulf_qty'
1039: , p_grand_total => 'Y'
1040: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1040: , p_prior_code => poa_dbi_util_pkg.both_priors

1036: poa_dbi_util_pkg.add_column(l_col_tbl
1037: ,'fulfilled_qty'
1038: ,'fulf_qty'
1039: , p_grand_total => 'Y'
1040: , p_prior_code => poa_dbi_util_pkg.both_priors
1041: , p_to_date_type => 'RLX');
1042: end if;
1043:
1044: poa_dbi_util_pkg.add_bucket_columns(

Line 1044: poa_dbi_util_pkg.add_bucket_columns(

1040: , p_prior_code => poa_dbi_util_pkg.both_priors
1041: , p_to_date_type => 'RLX');
1042: end if;
1043:
1044: poa_dbi_util_pkg.add_bucket_columns(
1045: p_short_name => 'POA_DBI_FR_BUCKET'
1046: ,p_col_tbl => l_col_tbl
1047: ,p_col_name => 'fulfilled_cnt_'||l_cur_suffix||'_age'
1048: ,p_alias_name => 'fulf_cnt_age'

Line 1051: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS

1047: ,p_col_name => 'fulfilled_cnt_'||l_cur_suffix||'_age'
1048: ,p_alias_name => 'fulf_cnt_age'
1049: ,x_bucket_rec => l_bucket_rec
1050: ,p_grand_total => 'Y'
1051: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
1052: ,p_to_date_type => 'RLX');
1053:
1054: l_query := get_req_age_sel_clause(l_view_by, l_view_by_col,l_bucket_rec) || ' from ';
1055:

Line 1104: poa_dbi_util_pkg.get_bucket_outer_query(

1100: oset.POA_PERCENT3 POA_PERCENT3, --Manual Lines
1101: oset.POA_PERCENT4 POA_PERCENT4, --Manual Lines Rate
1102: oset.POA_MEASURE3 POA_MEASURE3 --Manual Lines Rate Change '
1103: || fnd_global.newline ||
1104: poa_dbi_util_pkg.get_bucket_outer_query(
1105: p_bucket_rec
1106: , p_col_name => 'oset.POA_MEASURE4'
1107: , p_alias_name => 'POA_MEASURE4'
1108: , p_prefix => ''

Line 1119: poa_dbi_util_pkg.get_bucket_outer_query(

1115: oset.POA_PERCENT7 POA_PERCENT7, --Grand Total for Manual Lines
1116: oset.POA_PERCENT8 POA_PERCENT8, --Grand Total for Manual Lines Rate
1117: oset.POA_MEASURE7 POA_MEASURE7 -- grand tot for man lines rate change'
1118: || fnd_global.newline ||
1119: poa_dbi_util_pkg.get_bucket_outer_query(
1120: p_bucket_rec
1121: , p_col_name => 'oset.POA_MEASURE8'
1122: , p_alias_name => 'POA_MEASURE8'
1123: , p_prefix => ''

Line 1128: poa_dbi_util_pkg.get_bucket_drill_url(

1124: , p_suffix => ''
1125: , p_total_flag => 'N') || fnd_global.newline;
1126:
1127: l_sel_clause := l_sel_clause ||
1128: poa_dbi_util_pkg.get_bucket_drill_url(
1129: p_bucket_rec
1130: , 'POA_ATTRIBUTE6'
1131: , '''pFunctionName=POA_DBI_FR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=1&POA_BUCKET+REQUISITION_AGING='
1132: , ''''

Line 1157: '|| poa_dbi_util_pkg.get_bucket_outer_query(

1153: POA_PERCENT2,
1154: POA_PERCENT3,
1155: POA_PERCENT4,
1156: POA_MEASURE3
1157: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1158: p_bucket_rec
1159: , p_col_name => 'POA_MEASURE4'
1160: , p_alias_name => 'POA_MEASURE4'
1161: , p_prefix => ''

Line 1171: '|| poa_dbi_util_pkg.get_bucket_outer_query(

1167: POA_PERCENT6,
1168: POA_PERCENT7,
1169: POA_PERCENT8,
1170: POA_MEASURE7
1171: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1172: p_bucket_rec
1173: , p_col_name => 'POA_MEASURE8'
1174: , p_alias_name => 'POA_MEASURE8'
1175: , p_prefix => ''

Line 1189: '||poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP')||' POA_MEASURE1,

1185: nvl(c_fulf_qty,0) POA_ATTRIBUTE5,';
1186: end if;
1187:
1188: l_sel_clause := l_sel_clause || '
1189: '||poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP')||' POA_MEASURE1,
1190: '||poa_dbi_util_pkg.change_clause(
1191: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP'),
1192: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP'),
1193: 'P')||' POA_PERCENT1,

Line 1190: '||poa_dbi_util_pkg.change_clause(

1186: end if;
1187:
1188: l_sel_clause := l_sel_clause || '
1189: '||poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP')||' POA_MEASURE1,
1190: '||poa_dbi_util_pkg.change_clause(
1191: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP'),
1192: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP'),
1193: 'P')||' POA_PERCENT1,
1194: nvl(c_fulf_cnt,0) POA_MEASURE2,

Line 1191: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP'),

1187:
1188: l_sel_clause := l_sel_clause || '
1189: '||poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP')||' POA_MEASURE1,
1190: '||poa_dbi_util_pkg.change_clause(
1191: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP'),
1192: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP'),
1193: 'P')||' POA_PERCENT1,
1194: nvl(c_fulf_cnt,0) POA_MEASURE2,
1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,

Line 1192: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP'),

1188: l_sel_clause := l_sel_clause || '
1189: '||poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP')||' POA_MEASURE1,
1190: '||poa_dbi_util_pkg.change_clause(
1191: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP'),
1192: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP'),
1193: 'P')||' POA_PERCENT1,
1194: nvl(c_fulf_cnt,0) POA_MEASURE2,
1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,
1196: nvl(c_fulf_man_cnt,0) POA_PERCENT3,

Line 1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,

1191: poa_dbi_util_pkg.rate_clause('c_days_fulf','c_fulf_cnt','NP'),
1192: poa_dbi_util_pkg.rate_clause('p_days_fulf','p_fulf_cnt','NP'),
1193: 'P')||' POA_PERCENT1,
1194: nvl(c_fulf_cnt,0) POA_MEASURE2,
1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,
1196: nvl(c_fulf_man_cnt,0) POA_PERCENT3,
1197: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
1198: '||poa_dbi_util_pkg.change_clause(
1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),

Line 1197: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT4,

1193: 'P')||' POA_PERCENT1,
1194: nvl(c_fulf_cnt,0) POA_MEASURE2,
1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,
1196: nvl(c_fulf_man_cnt,0) POA_PERCENT3,
1197: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
1198: '||poa_dbi_util_pkg.change_clause(
1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
1200: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),
1201: 'P')||' POA_MEASURE3

Line 1198: '||poa_dbi_util_pkg.change_clause(

1194: nvl(c_fulf_cnt,0) POA_MEASURE2,
1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,
1196: nvl(c_fulf_man_cnt,0) POA_PERCENT3,
1197: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
1198: '||poa_dbi_util_pkg.change_clause(
1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
1200: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),
1201: 'P')||' POA_MEASURE3
1202: '|| poa_dbi_util_pkg.get_bucket_outer_query(

Line 1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),

1195: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP')||' POA_PERCENT2,
1196: nvl(c_fulf_man_cnt,0) POA_PERCENT3,
1197: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
1198: '||poa_dbi_util_pkg.change_clause(
1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
1200: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),
1201: 'P')||' POA_MEASURE3
1202: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1203: p_bucket_rec

Line 1200: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),

1196: nvl(c_fulf_man_cnt,0) POA_PERCENT3,
1197: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P')||' POA_PERCENT4,
1198: '||poa_dbi_util_pkg.change_clause(
1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
1200: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),
1201: 'P')||' POA_MEASURE3
1202: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1203: p_bucket_rec
1204: , p_col_name => 'c_fulf_cnt_age'

Line 1202: '|| poa_dbi_util_pkg.get_bucket_outer_query(

1198: '||poa_dbi_util_pkg.change_clause(
1199: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt','c_fulf_cnt','P'),
1200: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt','p_fulf_cnt','P'),
1201: 'P')||' POA_MEASURE3
1202: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1203: p_bucket_rec
1204: , p_col_name => 'c_fulf_cnt_age'
1205: , p_alias_name => 'POA_MEASURE4'
1206: , p_prefix => 'nvl('

Line 1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||

1205: , p_alias_name => 'POA_MEASURE4'
1206: , p_prefix => 'nvl('
1207: , p_suffix => ',0)'
1208: , p_total_flag => 'N') ||',
1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||
1210: poa_dbi_util_pkg.change_clause(
1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),
1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),
1213: 'P')|| ' POA_PERCENT5,

Line 1210: poa_dbi_util_pkg.change_clause(

1206: , p_prefix => 'nvl('
1207: , p_suffix => ',0)'
1208: , p_total_flag => 'N') ||',
1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||
1210: poa_dbi_util_pkg.change_clause(
1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),
1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),
1213: 'P')|| ' POA_PERCENT5,
1214: nvl(c_fulf_cnt_total,0) POA_MEASURE6,

Line 1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),

1207: , p_suffix => ',0)'
1208: , p_total_flag => 'N') ||',
1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||
1210: poa_dbi_util_pkg.change_clause(
1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),
1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),
1213: 'P')|| ' POA_PERCENT5,
1214: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
1215: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,

Line 1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),

1208: , p_total_flag => 'N') ||',
1209: '||poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP')||' POA_MEASURE5, '|| fnd_global.newline ||
1210: poa_dbi_util_pkg.change_clause(
1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),
1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),
1213: 'P')|| ' POA_PERCENT5,
1214: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
1215: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
1216: nvl(c_fulf_man_cnt_total,0) POA_PERCENT7,

Line 1215: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,

1211: poa_dbi_util_pkg.rate_clause('c_days_fulf_total','c_fulf_cnt_total','NP'),
1212: poa_dbi_util_pkg.rate_clause('p_days_fulf_total','p_fulf_cnt_total','NP'),
1213: 'P')|| ' POA_PERCENT5,
1214: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
1215: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
1216: nvl(c_fulf_man_cnt_total,0) POA_PERCENT7,
1217: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT8,
1218: '||
1219: poa_dbi_util_pkg.change_clause(

Line 1217: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT8,

1213: 'P')|| ' POA_PERCENT5,
1214: nvl(c_fulf_cnt_total,0) POA_MEASURE6,
1215: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
1216: nvl(c_fulf_man_cnt_total,0) POA_PERCENT7,
1217: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT8,
1218: '||
1219: poa_dbi_util_pkg.change_clause(
1220: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
1221: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),

Line 1219: poa_dbi_util_pkg.change_clause(

1215: '||poa_dbi_util_pkg.change_clause('c_fulf_cnt_total','p_fulf_cnt_total','NP')||' POA_PERCENT6,
1216: nvl(c_fulf_man_cnt_total,0) POA_PERCENT7,
1217: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT8,
1218: '||
1219: poa_dbi_util_pkg.change_clause(
1220: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
1221: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),
1222: 'P')||' POA_MEASURE7
1223: '|| poa_dbi_util_pkg.get_bucket_outer_query(

Line 1220: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),

1216: nvl(c_fulf_man_cnt_total,0) POA_PERCENT7,
1217: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT8,
1218: '||
1219: poa_dbi_util_pkg.change_clause(
1220: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
1221: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),
1222: 'P')||' POA_MEASURE7
1223: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1224: p_bucket_rec

Line 1221: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),

1217: '||poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P')||' POA_PERCENT8,
1218: '||
1219: poa_dbi_util_pkg.change_clause(
1220: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
1221: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),
1222: 'P')||' POA_MEASURE7
1223: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1224: p_bucket_rec
1225: , p_col_name => 'c_fulf_cnt_age'

Line 1223: '|| poa_dbi_util_pkg.get_bucket_outer_query(

1219: poa_dbi_util_pkg.change_clause(
1220: poa_dbi_util_pkg.rate_clause('c_fulf_man_cnt_total','c_fulf_cnt_total','P'),
1221: poa_dbi_util_pkg.rate_clause('p_fulf_man_cnt_total','p_fulf_cnt_total','P'),
1222: 'P')||' POA_MEASURE7
1223: '|| poa_dbi_util_pkg.get_bucket_outer_query(
1224: p_bucket_rec
1225: , p_col_name => 'c_fulf_cnt_age'
1226: , p_alias_name => 'POA_MEASURE8'
1227: , p_prefix => 'nvl('

Line 1277: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1273: l_xtd varchar2(10);
1274: l_comparison_type varchar2(1);
1275: l_nested_pattern number;
1276: l_cur_suffix varchar2(2);
1277: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1278: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1279: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1280: l_where_clause varchar2(2000);
1281: err_msg varchar2(100);

Line 1278: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1274: l_comparison_type varchar2(1);
1275: l_nested_pattern number;
1276: l_cur_suffix varchar2(2);
1277: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1278: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1279: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1280: l_where_clause varchar2(2000);
1281: err_msg varchar2(100);
1282: err_cde number;

Line 1279: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

1275: l_nested_pattern number;
1276: l_cur_suffix varchar2(2);
1277: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1278: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1279: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1280: l_where_clause varchar2(2000);
1281: err_msg varchar2(100);
1282: err_cde number;
1283: begin

Line 1285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

1281: err_msg varchar2(100);
1282: err_cde number;
1283: begin
1284: l_comparison_type := 'Y';
1285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1286: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1287:
1288: poa_dbi_sutil_pkg.process_parameters(p_param,
1289: l_view_by,

Line 1286: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

1282: err_cde number;
1283: begin
1284: l_comparison_type := 'Y';
1285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1286: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1287:
1288: poa_dbi_sutil_pkg.process_parameters(p_param,
1289: l_view_by,
1290: l_view_by_col_name,

Line 1309: poa_dbi_util_pkg.add_column(l_col_tbl

1305: '7.1',
1306: 'VPP',
1307: 'REQMF');
1308:
1309: poa_dbi_util_pkg.add_column(l_col_tbl
1310: , 'fulfilled_man_cnt_'||l_cur_suffix
1311: , 'fulf_man_cnt'
1312: , p_grand_total => 'N'
1313: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1313: , p_prior_code => poa_dbi_util_pkg.both_priors

1309: poa_dbi_util_pkg.add_column(l_col_tbl
1310: , 'fulfilled_man_cnt_'||l_cur_suffix
1311: , 'fulf_man_cnt'
1312: , p_grand_total => 'N'
1313: , p_prior_code => poa_dbi_util_pkg.both_priors
1314: , p_to_date_type => 'RLX');
1315:
1316: poa_dbi_util_pkg.add_column(l_col_tbl
1317: , 'fulfilled_cnt_'||l_cur_suffix

Line 1316: poa_dbi_util_pkg.add_column(l_col_tbl

1312: , p_grand_total => 'N'
1313: , p_prior_code => poa_dbi_util_pkg.both_priors
1314: , p_to_date_type => 'RLX');
1315:
1316: poa_dbi_util_pkg.add_column(l_col_tbl
1317: , 'fulfilled_cnt_'||l_cur_suffix
1318: , 'fulf_cnt'
1319: , p_grand_total => 'N'
1320: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1320: , p_prior_code => poa_dbi_util_pkg.both_priors

1316: poa_dbi_util_pkg.add_column(l_col_tbl
1317: , 'fulfilled_cnt_'||l_cur_suffix
1318: , 'fulf_cnt'
1319: , p_grand_total => 'N'
1320: , p_prior_code => poa_dbi_util_pkg.both_priors
1321: , p_to_date_type => 'RLX');
1322:
1323: l_query := get_trend_sel_clause || '
1324: from '

Line 1347: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP') || ' POA_PERCENT1, -- fulf lines change

1343: begin
1344: l_sel_clause := 'select cal.name VIEWBY,';
1345: l_sel_clause := l_sel_clause || '
1346: nvl(c_fulf_cnt,0) POA_MEASURE1, -- fulf lines
1347: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP') || ' POA_PERCENT1, -- fulf lines change
1348: nvl(c_fulf_man_cnt,0) POA_MEASURE2, -- man lines
1349: ' || poa_dbi_util_pkg.change_clause('c_fulf_man_cnt','p_fulf_man_cnt') || ' POA_PERCENT2, -- man lines change
1350: nvl(c_fulf_cnt,0)-nvl(c_fulf_man_cnt,0) POA_MEASURE3, -- auto lines
1351: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt-c_fulf_man_cnt','p_fulf_cnt-p_fulf_man_cnt') || ' POA_PERCENT3 -- auto lines change';

Line 1349: ' || poa_dbi_util_pkg.change_clause('c_fulf_man_cnt','p_fulf_man_cnt') || ' POA_PERCENT2, -- man lines change

1345: l_sel_clause := l_sel_clause || '
1346: nvl(c_fulf_cnt,0) POA_MEASURE1, -- fulf lines
1347: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP') || ' POA_PERCENT1, -- fulf lines change
1348: nvl(c_fulf_man_cnt,0) POA_MEASURE2, -- man lines
1349: ' || poa_dbi_util_pkg.change_clause('c_fulf_man_cnt','p_fulf_man_cnt') || ' POA_PERCENT2, -- man lines change
1350: nvl(c_fulf_cnt,0)-nvl(c_fulf_man_cnt,0) POA_MEASURE3, -- auto lines
1351: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt-c_fulf_man_cnt','p_fulf_cnt-p_fulf_man_cnt') || ' POA_PERCENT3 -- auto lines change';
1352: return l_sel_clause;
1353: end;

Line 1351: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt-c_fulf_man_cnt','p_fulf_cnt-p_fulf_man_cnt') || ' POA_PERCENT3 -- auto lines change';

1347: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt','p_fulf_cnt','NP') || ' POA_PERCENT1, -- fulf lines change
1348: nvl(c_fulf_man_cnt,0) POA_MEASURE2, -- man lines
1349: ' || poa_dbi_util_pkg.change_clause('c_fulf_man_cnt','p_fulf_man_cnt') || ' POA_PERCENT2, -- man lines change
1350: nvl(c_fulf_cnt,0)-nvl(c_fulf_man_cnt,0) POA_MEASURE3, -- auto lines
1351: ' || poa_dbi_util_pkg.change_clause('c_fulf_cnt-c_fulf_man_cnt','p_fulf_cnt-p_fulf_man_cnt') || ' POA_PERCENT3 -- auto lines change';
1352: return l_sel_clause;
1353: end;
1354:
1355: /*Fulfilled Requisitions Amount Trend*/

Line 1371: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1367: l_xtd varchar2(10);
1368: l_comparison_type varchar2(1);
1369: l_nested_pattern number;
1370: l_cur_suffix varchar2(2);
1371: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1372: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1373: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1374: l_where_clause varchar2(2000);
1375: err_msg varchar2(100);

Line 1372: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1368: l_comparison_type varchar2(1);
1369: l_nested_pattern number;
1370: l_cur_suffix varchar2(2);
1371: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1372: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1373: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1374: l_where_clause varchar2(2000);
1375: err_msg varchar2(100);
1376: err_cde number;

Line 1373: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

1369: l_nested_pattern number;
1370: l_cur_suffix varchar2(2);
1371: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1372: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1373: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1374: l_where_clause varchar2(2000);
1375: err_msg varchar2(100);
1376: err_cde number;
1377: begin

Line 1379: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

1375: err_msg varchar2(100);
1376: err_cde number;
1377: begin
1378: l_comparison_type := 'Y';
1379: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1381:
1382: poa_dbi_sutil_pkg.process_parameters(p_param,
1383: l_view_by,

Line 1380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

1376: err_cde number;
1377: begin
1378: l_comparison_type := 'Y';
1379: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1380: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1381:
1382: poa_dbi_sutil_pkg.process_parameters(p_param,
1383: l_view_by,
1384: l_view_by_col_name,

Line 1403: poa_dbi_util_pkg.add_column(l_col_tbl

1399: '7.1',
1400: 'VPP',
1401: 'REQMF');
1402:
1403: poa_dbi_util_pkg.add_column(l_col_tbl
1404: , 'fulfilled_man_amt_'||l_cur_suffix
1405: , 'fulf_man_amt'
1406: , p_grand_total => 'N'
1407: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1407: , p_prior_code => poa_dbi_util_pkg.both_priors

1403: poa_dbi_util_pkg.add_column(l_col_tbl
1404: , 'fulfilled_man_amt_'||l_cur_suffix
1405: , 'fulf_man_amt'
1406: , p_grand_total => 'N'
1407: , p_prior_code => poa_dbi_util_pkg.both_priors
1408: , p_to_date_type => 'RLX');
1409:
1410: poa_dbi_util_pkg.add_column(l_col_tbl
1411: , 'fulfilled_amt_'||l_cur_suffix

Line 1410: poa_dbi_util_pkg.add_column(l_col_tbl

1406: , p_grand_total => 'N'
1407: , p_prior_code => poa_dbi_util_pkg.both_priors
1408: , p_to_date_type => 'RLX');
1409:
1410: poa_dbi_util_pkg.add_column(l_col_tbl
1411: , 'fulfilled_amt_'||l_cur_suffix
1412: , 'fulf_amt'
1413: , p_grand_total => 'N'
1414: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1414: , p_prior_code => poa_dbi_util_pkg.both_priors

1410: poa_dbi_util_pkg.add_column(l_col_tbl
1411: , 'fulfilled_amt_'||l_cur_suffix
1412: , 'fulf_amt'
1413: , p_grand_total => 'N'
1414: , p_prior_code => poa_dbi_util_pkg.both_priors
1415: , p_to_date_type => 'RLX');
1416:
1417: l_query := get_amt_trend_sel_clause || '
1418: from '

Line 1442: ' || poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP') || ' POA_PERCENT1, -- fulf amt change

1438: l_sel_clause := 'select cal.name VIEWBY,';
1439: l_sel_clause := l_sel_clause || '
1440: nvl(p_fulf_amt,0) POA_MEASURE3, -- prior fulf amt
1441: nvl(c_fulf_amt,0) POA_MEASURE1, -- fulf amt
1442: ' || poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP') || ' POA_PERCENT1, -- fulf amt change
1443: nvl(p_fulf_man_amt,0) POA_MEASURE4, -- prior man amt
1444: nvl(c_fulf_man_amt,0) POA_MEASURE2, -- man amt
1445: ' || poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P') || ' POA_PERCENT2, -- man amt rate
1446: ' ||

Line 1445: ' || poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P') || ' POA_PERCENT2, -- man amt rate

1441: nvl(c_fulf_amt,0) POA_MEASURE1, -- fulf amt
1442: ' || poa_dbi_util_pkg.change_clause('c_fulf_amt','p_fulf_amt','NP') || ' POA_PERCENT1, -- fulf amt change
1443: nvl(p_fulf_man_amt,0) POA_MEASURE4, -- prior man amt
1444: nvl(c_fulf_man_amt,0) POA_MEASURE2, -- man amt
1445: ' || poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P') || ' POA_PERCENT2, -- man amt rate
1446: ' ||
1447: poa_dbi_util_pkg.change_clause(
1448: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P'),
1449: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt', 'P'),

Line 1447: poa_dbi_util_pkg.change_clause(

1443: nvl(p_fulf_man_amt,0) POA_MEASURE4, -- prior man amt
1444: nvl(c_fulf_man_amt,0) POA_MEASURE2, -- man amt
1445: ' || poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P') || ' POA_PERCENT2, -- man amt rate
1446: ' ||
1447: poa_dbi_util_pkg.change_clause(
1448: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P'),
1449: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt', 'P'),
1450: 'P') || ' POA_PERCENT3 --man amt rate change';
1451: return l_sel_clause;

Line 1448: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P'),

1444: nvl(c_fulf_man_amt,0) POA_MEASURE2, -- man amt
1445: ' || poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P') || ' POA_PERCENT2, -- man amt rate
1446: ' ||
1447: poa_dbi_util_pkg.change_clause(
1448: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P'),
1449: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt', 'P'),
1450: 'P') || ' POA_PERCENT3 --man amt rate change';
1451: return l_sel_clause;
1452: end;

Line 1449: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt', 'P'),

1445: ' || poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P') || ' POA_PERCENT2, -- man amt rate
1446: ' ||
1447: poa_dbi_util_pkg.change_clause(
1448: poa_dbi_util_pkg.rate_clause('c_fulf_man_amt','c_fulf_amt', 'P'),
1449: poa_dbi_util_pkg.rate_clause('p_fulf_man_amt','p_fulf_amt', 'P'),
1450: 'P') || ' POA_PERCENT3 --man amt rate change';
1451: return l_sel_clause;
1452: end;
1453:

Line 1470: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1466: l_xtd varchar2(10);
1467: l_comparison_type varchar2(1);
1468: l_nested_pattern number;
1469: l_cur_suffix varchar2(2);
1470: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1471: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1472: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1473: l_where_clause varchar2(2000);
1474: err_msg varchar2(100);

Line 1471: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1467: l_comparison_type varchar2(1);
1468: l_nested_pattern number;
1469: l_cur_suffix varchar2(2);
1470: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1471: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1472: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1473: l_where_clause varchar2(2000);
1474: err_msg varchar2(100);
1475: err_cde number;

Line 1472: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;

1468: l_nested_pattern number;
1469: l_cur_suffix varchar2(2);
1470: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1471: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1472: l_in_join_tbl poa_dbi_util_pkg.poa_dbi_in_join_tbl;
1473: l_where_clause varchar2(2000);
1474: err_msg varchar2(100);
1475: err_cde number;
1476: begin

Line 1478: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

1474: err_msg varchar2(100);
1475: err_cde number;
1476: begin
1477: l_comparison_type := 'Y';
1478: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1479: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1480:
1481: poa_dbi_sutil_pkg.process_parameters(p_param,
1482: l_view_by,

Line 1479: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

1475: err_cde number;
1476: begin
1477: l_comparison_type := 'Y';
1478: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1479: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1480:
1481: poa_dbi_sutil_pkg.process_parameters(p_param,
1482: l_view_by,
1483: l_view_by_col_name,

Line 1502: poa_dbi_util_pkg.add_column(l_col_tbl

1498: '7.1',
1499: 'VPP',
1500: 'REQMF');
1501:
1502: poa_dbi_util_pkg.add_column(l_col_tbl
1503: , 'fulfilled_ped_cnt'
1504: , 'fulf_ped_cnt'
1505: , p_grand_total => 'N'
1506: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1506: , p_prior_code => poa_dbi_util_pkg.both_priors

1502: poa_dbi_util_pkg.add_column(l_col_tbl
1503: , 'fulfilled_ped_cnt'
1504: , 'fulf_ped_cnt'
1505: , p_grand_total => 'N'
1506: , p_prior_code => poa_dbi_util_pkg.both_priors
1507: , p_to_date_type => 'RLX');
1508:
1509: poa_dbi_util_pkg.add_column(l_col_tbl
1510: , 'fulfilled_cnt_'||l_cur_suffix

Line 1509: poa_dbi_util_pkg.add_column(l_col_tbl

1505: , p_grand_total => 'N'
1506: , p_prior_code => poa_dbi_util_pkg.both_priors
1507: , p_to_date_type => 'RLX');
1508:
1509: poa_dbi_util_pkg.add_column(l_col_tbl
1510: , 'fulfilled_cnt_'||l_cur_suffix
1511: , 'fulf_cnt'
1512: , p_grand_total => 'N'
1513: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 1513: , p_prior_code => poa_dbi_util_pkg.both_priors

1509: poa_dbi_util_pkg.add_column(l_col_tbl
1510: , 'fulfilled_cnt_'||l_cur_suffix
1511: , 'fulf_cnt'
1512: , p_grand_total => 'N'
1513: , p_prior_code => poa_dbi_util_pkg.both_priors
1514: , p_to_date_type => 'RLX');
1515:
1516: l_query := get_ped_trend_sel_clause || '
1517: from '

Line 1540: || poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P') || ' POA_PERCENT3, -- prior percent ped rate

1536: begin
1537: l_sel_clause := 'select cal.name VIEWBY,';
1538: l_sel_clause := l_sel_clause || '
1539: '
1540: || poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P') || ' POA_PERCENT3, -- prior percent ped rate
1541: '
1542: || poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P') || ' POA_PERCENT1, -- percent ped rate
1543: '
1544: || poa_dbi_util_pkg.change_clause(

Line 1542: || poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P') || ' POA_PERCENT1, -- percent ped rate

1538: l_sel_clause := l_sel_clause || '
1539: '
1540: || poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P') || ' POA_PERCENT3, -- prior percent ped rate
1541: '
1542: || poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P') || ' POA_PERCENT1, -- percent ped rate
1543: '
1544: || poa_dbi_util_pkg.change_clause(
1545: poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P'),
1546: poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P'),

Line 1544: || poa_dbi_util_pkg.change_clause(

1540: || poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P') || ' POA_PERCENT3, -- prior percent ped rate
1541: '
1542: || poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P') || ' POA_PERCENT1, -- percent ped rate
1543: '
1544: || poa_dbi_util_pkg.change_clause(
1545: poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P'),
1546: poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P'),
1547: 'P') || ' POA_PERCENT2 -- percent ped rate change';
1548: return l_sel_clause;

Line 1545: poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P'),

1541: '
1542: || poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P') || ' POA_PERCENT1, -- percent ped rate
1543: '
1544: || poa_dbi_util_pkg.change_clause(
1545: poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P'),
1546: poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P'),
1547: 'P') || ' POA_PERCENT2 -- percent ped rate change';
1548: return l_sel_clause;
1549: end;

Line 1546: poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P'),

1542: || poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P') || ' POA_PERCENT1, -- percent ped rate
1543: '
1544: || poa_dbi_util_pkg.change_clause(
1545: poa_dbi_util_pkg.rate_clause('c_fulf_ped_cnt','c_fulf_cnt','P'),
1546: poa_dbi_util_pkg.rate_clause('p_fulf_ped_cnt','p_fulf_cnt','P'),
1547: 'P') || ' POA_PERCENT2 -- percent ped rate change';
1548: return l_sel_clause;
1549: end;
1550: