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_UFR_PKG dependencies on POA_DBI_UTIL_PKG

Line 29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

25: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
28: IS
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_query varchar2(10000);
32: l_view_by varchar2(120);
33: l_view_by_col varchar2(120);

Line 30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

26: x_custom_sql OUT NOCOPY VARCHAR2,
27: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
28: IS
29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
31: l_query varchar2(10000);
32: l_view_by varchar2(120);
33: l_view_by_col varchar2(120);
34: l_as_of_date date;

Line 40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

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

Line 41: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

37: l_comparison_type varchar2(1);
38: l_nested_pattern number;
39: l_cur_suffix varchar2(2);
40: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
41: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
42: l_where_clause VARCHAR2(2000);
43: l_mv VARCHAR2(30);
44: l_view_by_value varchar2(30);
45: ERR_MSG VARCHAR2(100);

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

45: ERR_MSG VARCHAR2(100);
46: ERR_CDE NUMBER;
47: BEGIN
48:
49: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
50: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
51: l_comparison_type := 'Y';
52: poa_dbi_sutil_pkg.process_parameters(p_param
53: ,l_view_by

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

46: ERR_CDE NUMBER;
47: BEGIN
48:
49: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
50: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
51: l_comparison_type := 'Y';
52: poa_dbi_sutil_pkg.process_parameters(p_param
53: ,l_view_by
54: ,l_view_by_col

Line 74: poa_dbi_util_pkg.add_column(l_col_tbl

70: ,p_role => 'VPP'
71: ,p_mv_set => 'REQS');
72:
73:
74: poa_dbi_util_pkg.add_column(l_col_tbl
75: ,'unfulfilled_cnt'
76: , 'unfulf_cnt'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

74: poa_dbi_util_pkg.add_column(l_col_tbl
75: ,'unfulfilled_cnt'
76: , 'unfulf_cnt'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
79: , p_to_date_type => 'NA');
80: poa_dbi_util_pkg.add_column(l_col_tbl
81: , 'unfulfilled_ped_cnt'
82: , 'unfulf_ped_cnt'

Line 80: poa_dbi_util_pkg.add_column(l_col_tbl

76: , 'unfulf_cnt'
77: , p_grand_total => 'Y'
78: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
79: , p_to_date_type => 'NA');
80: poa_dbi_util_pkg.add_column(l_col_tbl
81: , 'unfulfilled_ped_cnt'
82: , 'unfulf_ped_cnt'
83: , p_grand_total => 'Y'
84: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 84: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

80: poa_dbi_util_pkg.add_column(l_col_tbl
81: , 'unfulfilled_ped_cnt'
82: , 'unfulf_ped_cnt'
83: , p_grand_total => 'Y'
84: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
85: , p_to_date_type => 'NA');
86: poa_dbi_util_pkg.add_column(l_col_tbl
87: , 'unfulfilled_amt_' || l_cur_suffix
88: , 'unfulf_amt'

Line 86: poa_dbi_util_pkg.add_column(l_col_tbl

82: , 'unfulf_ped_cnt'
83: , p_grand_total => 'Y'
84: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
85: , p_to_date_type => 'NA');
86: poa_dbi_util_pkg.add_column(l_col_tbl
87: , 'unfulfilled_amt_' || l_cur_suffix
88: , 'unfulf_amt'
89: , p_grand_total => 'Y'
90: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 90: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

86: poa_dbi_util_pkg.add_column(l_col_tbl
87: , 'unfulfilled_amt_' || l_cur_suffix
88: , 'unfulf_amt'
89: , p_grand_total => 'Y'
90: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
91: , p_to_date_type => 'NA');
92: poa_dbi_util_pkg.add_column(l_col_tbl
93: , 'num_days_unfulfilled'
94: , 'num_days_unfulf'

Line 92: poa_dbi_util_pkg.add_column(l_col_tbl

88: , 'unfulf_amt'
89: , p_grand_total => 'Y'
90: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
91: , p_to_date_type => 'NA');
92: poa_dbi_util_pkg.add_column(l_col_tbl
93: , 'num_days_unfulfilled'
94: , 'num_days_unfulf'
95: , p_grand_total => 'Y'
96: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 96: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

92: poa_dbi_util_pkg.add_column(l_col_tbl
93: , 'num_days_unfulfilled'
94: , 'num_days_unfulf'
95: , p_grand_total => 'Y'
96: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
97: , p_to_date_type => 'NA');
98:
99: if(l_view_by = 'ITEM+POA_ITEMS') then
100: poa_dbi_util_pkg.add_column(l_col_tbl

Line 100: poa_dbi_util_pkg.add_column(l_col_tbl

96: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
97: , p_to_date_type => 'NA');
98:
99: if(l_view_by = 'ITEM+POA_ITEMS') then
100: poa_dbi_util_pkg.add_column(l_col_tbl
101: ,'unfulfilled_qty'
102: ,'unfulf_qty'
103: , p_grand_total => 'N'
104: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 104: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

100: poa_dbi_util_pkg.add_column(l_col_tbl
101: ,'unfulfilled_qty'
102: ,'unfulf_qty'
103: , p_grand_total => 'N'
104: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
105: , p_to_date_type => 'NA');
106:
107: end if;
108:

Line 212: || poa_dbi_util_pkg.rate_clause('c_unfulf_cnt', 'c_unfulf_cnt_total', 'P') || ' POA_PERCENT1,

208:
209: end if;
210: l_sel_clause := l_sel_clause || ' nvl(c_unfulf_cnt,0) POA_MEASURE1,
211: '
212: || poa_dbi_util_pkg.rate_clause('c_unfulf_cnt', 'c_unfulf_cnt_total', 'P') || ' POA_PERCENT1,
213: nvl(c_unfulf_ped_cnt,0) POA_MEASURE2,
214: nvl(c_unfulf_amt,0) POA_MEASURE3,
215: nvl(c_unfulf_cnt_total,0) POA_MEASURE6,
216: decode(c_unfulf_cnt_total, null, null, 100) POA_PERCENT2,

Line 220: poa_dbi_util_pkg.rate_clause('c_num_days_unfulf','c_unfulf_cnt', 'NP')|| ' POA_MEASURE4,

216: decode(c_unfulf_cnt_total, null, null, 100) POA_PERCENT2,
217: nvl(c_unfulf_ped_cnt_total,0) POA_MEASURE7,
218: nvl(c_unfulf_amt_total,0) POA_MEASURE8,
219: ' ||
220: poa_dbi_util_pkg.rate_clause('c_num_days_unfulf','c_unfulf_cnt', 'NP')|| ' POA_MEASURE4,
221: ' ||
222: poa_dbi_util_pkg.rate_clause('c_num_days_unfulf_total','c_unfulf_cnt_total','NP')|| ' POA_MEASURE9
223: ';
224:

Line 222: poa_dbi_util_pkg.rate_clause('c_num_days_unfulf_total','c_unfulf_cnt_total','NP')|| ' POA_MEASURE9

218: nvl(c_unfulf_amt_total,0) POA_MEASURE8,
219: ' ||
220: poa_dbi_util_pkg.rate_clause('c_num_days_unfulf','c_unfulf_cnt', 'NP')|| ' POA_MEASURE4,
221: ' ||
222: poa_dbi_util_pkg.rate_clause('c_num_days_unfulf_total','c_unfulf_cnt_total','NP')|| ' POA_MEASURE9
223: ';
224:
225: return l_sel_clause;
226: END get_status_sel_clause;

Line 258: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

254: PROCEDURE amt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
255: x_custom_sql OUT NOCOPY VARCHAR2,
256: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
257: IS
258: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
259: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
260: l_query varchar2(10000);
261: l_view_by varchar2(120);
262: l_view_by_col varchar2(120);

Line 259: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

255: x_custom_sql OUT NOCOPY VARCHAR2,
256: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
257: IS
258: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
259: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
260: l_query varchar2(10000);
261: l_view_by varchar2(120);
262: l_view_by_col varchar2(120);
263: l_as_of_date date;

Line 269: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

265: l_xtd varchar2(10);
266: l_comparison_type varchar2(1);
267: l_nested_pattern number;
268: l_cur_suffix varchar2(2);
269: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
270: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
271: l_where_clause VARCHAR2(2000);
272: l_mv VARCHAR2(30);
273: l_view_by_value varchar2(30);

Line 270: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

266: l_comparison_type varchar2(1);
267: l_nested_pattern number;
268: l_cur_suffix varchar2(2);
269: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
270: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
271: l_where_clause VARCHAR2(2000);
272: l_mv VARCHAR2(30);
273: l_view_by_value varchar2(30);
274: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

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

274: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
275: ERR_MSG VARCHAR2(100);
276: ERR_CDE NUMBER;
277: BEGIN
278: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
279: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
280: l_comparison_type := 'Y';
281: poa_dbi_sutil_pkg.process_parameters(p_param
282: , l_view_by

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

275: ERR_MSG VARCHAR2(100);
276: ERR_CDE NUMBER;
277: BEGIN
278: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
279: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
280: l_comparison_type := 'Y';
281: poa_dbi_sutil_pkg.process_parameters(p_param
282: , l_view_by
283: , l_view_by_col

Line 301: poa_dbi_util_pkg.add_bucket_columns(

297: , p_func_area => 'PO'
298: , p_version => '7.1'
299: , p_role => 'VPP'
300: , p_mv_set => 'REQS');
301: poa_dbi_util_pkg.add_bucket_columns(
302: p_short_name => 'POA_DBI_UFR_BUCKET'
303: ,p_col_tbl => l_col_tbl
304: ,p_col_name => 'unfulfilled_amt_' || l_cur_suffix || '_age'
305: ,p_alias_name => 'unfulf_amt_age'

Line 308: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS

304: ,p_col_name => 'unfulfilled_amt_' || l_cur_suffix || '_age'
305: ,p_alias_name => 'unfulf_amt_age'
306: ,x_bucket_rec => l_bucket_rec
307: ,p_grand_total => 'Y'
308: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
309: ,p_to_date_type => 'NA');
310:
311: poa_dbi_util_pkg.add_column(l_col_tbl
312: ,'unfulfilled_amt_'|| l_cur_suffix

Line 311: poa_dbi_util_pkg.add_column(l_col_tbl

307: ,p_grand_total => 'Y'
308: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
309: ,p_to_date_type => 'NA');
310:
311: poa_dbi_util_pkg.add_column(l_col_tbl
312: ,'unfulfilled_amt_'|| l_cur_suffix
313: , 'unfulf_amt'
314: , p_grand_total => 'Y'
315: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 315: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

311: poa_dbi_util_pkg.add_column(l_col_tbl
312: ,'unfulfilled_amt_'|| l_cur_suffix
313: , 'unfulf_amt'
314: , p_grand_total => 'Y'
315: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
316: , p_to_date_type => 'NA');
317: poa_dbi_util_pkg.add_column(l_col_tbl
318: ,'pen_fulfill_amt_'|| l_cur_suffix
319: , 'pen_fulf_amt'

Line 317: poa_dbi_util_pkg.add_column(l_col_tbl

313: , 'unfulf_amt'
314: , p_grand_total => 'Y'
315: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
316: , p_to_date_type => 'NA');
317: poa_dbi_util_pkg.add_column(l_col_tbl
318: ,'pen_fulfill_amt_'|| l_cur_suffix
319: , 'pen_fulf_amt'
320: , p_grand_total => 'Y'
321: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 321: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

317: poa_dbi_util_pkg.add_column(l_col_tbl
318: ,'pen_fulfill_amt_'|| l_cur_suffix
319: , 'pen_fulf_amt'
320: , p_grand_total => 'Y'
321: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
322: , p_to_date_type => 'NA');
323: if(l_view_by = 'ITEM+POA_ITEMS') then
324: poa_dbi_util_pkg.add_column(l_col_tbl
325: ,'unfulfilled_qty'

Line 324: poa_dbi_util_pkg.add_column(l_col_tbl

320: , p_grand_total => 'Y'
321: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
322: , p_to_date_type => 'NA');
323: if(l_view_by = 'ITEM+POA_ITEMS') then
324: poa_dbi_util_pkg.add_column(l_col_tbl
325: ,'unfulfilled_qty'
326: ,'unfulf_qty'
327: , p_grand_total => 'N'
328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

324: poa_dbi_util_pkg.add_column(l_col_tbl
325: ,'unfulfilled_qty'
326: ,'unfulf_qty'
327: , p_grand_total => 'N'
328: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
329: , p_to_date_type => 'NA');
330: end if;
331:
332:

Line 394: || poa_dbi_util_pkg.get_bucket_outer_query(

390: ' oset.POA_MEASURE2 POA_MEASURE2, --unfulf amt
391: oset.POA_MEASURE3 POA_MEASURE3, -- unfulf amt pend process
392: oset.POA_MEASURE4 POA_MEASURE4 -- pending fulf'
393: || fnd_global.newline
394: || poa_dbi_util_pkg.get_bucket_outer_query(
395: p_bucket_rec
396: , p_col_name => 'oset.POA_MEASURE5'
397: , p_alias_name => 'POA_MEASURE5'
398: , p_prefix => ''

Line 407: || poa_dbi_util_pkg.get_bucket_outer_query(

403: oset.POA_MEASURE6 POA_MEASURE6, --unfulf amt total
404: oset.POA_MEASURE7 POA_MEASURE7, -- pend process total
405: oset.POA_MEASURE8 POA_MEASURE8 -- unfulf amt pend fulf total'
406: || fnd_global.newline
407: || poa_dbi_util_pkg.get_bucket_outer_query(
408: p_bucket_rec
409: , p_col_name => 'oset.POA_MEASURE9'
410: , p_alias_name => 'POA_MEASURE9'
411: , p_prefix => ''

Line 423: poa_dbi_util_pkg.get_bucket_drill_url(

419: || fnd_global.newline ;
420:
421:
422: l_sel_clause := l_sel_clause ||
423: poa_dbi_util_pkg.get_bucket_drill_url(
424: p_bucket_rec
425: , 'POA_ATTRIBUTE7'
426: ,
427: '''pFunctionName=POA_DBI_UFR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=-2&POA_BUCKET+REQUISITION_AGING='

Line 458: || poa_dbi_util_pkg.get_bucket_outer_query(

454:
455: l_sel_clause := l_sel_clause || ',POA_MEASURE2,POA_MEASURE3,
456: POA_MEASURE4 '
457: || fnd_global.newline
458: || poa_dbi_util_pkg.get_bucket_outer_query(
459: p_bucket_rec
460: , p_col_name => 'POA_MEASURE5'
461: , p_alias_name => 'POA_MEASURE5'
462: , p_prefix => ''

Line 468: || poa_dbi_util_pkg.get_bucket_outer_query(

464: , p_total_flag => 'N')
465: || fnd_global.newline ||
466: ' ,POA_MEASURE6,
467: POA_MEASURE7,POA_MEASURE8'
468: || poa_dbi_util_pkg.get_bucket_outer_query(
469: p_bucket_rec
470: , p_col_name => 'POA_MEASURE9'
471: , p_alias_name => 'POA_MEASURE9'
472: , p_prefix => ''

Line 488: || poa_dbi_util_pkg.get_bucket_outer_query(

484: || ' nvl(c_unfulf_amt,0) POA_MEASURE2,
485: (nvl(c_unfulf_amt,0)-nvl(c_pen_fulf_amt,0)) POA_MEASURE3,
486: nvl(c_pen_fulf_amt,0) POA_MEASURE4';
487: l_sel_clause := l_sel_clause || fnd_global.newline
488: || poa_dbi_util_pkg.get_bucket_outer_query(
489: p_bucket_rec
490: , p_col_name => 'c_unfulf_amt_age'
491: , p_alias_name => 'POA_MEASURE5'
492: , p_prefix => 'nvl('

Line 500: || poa_dbi_util_pkg.get_bucket_outer_query(

496:
497: nvl(c_unfulf_amt_total,0) POA_MEASURE6,
498: (nvl(c_unfulf_amt_total,0)-nvl(c_pen_fulf_amt_total,0)) POA_MEASURE7,
499: nvl(c_pen_fulf_amt_total,0) POA_MEASURE8'
500: || poa_dbi_util_pkg.get_bucket_outer_query(
501: p_bucket_rec
502: , p_col_name => 'c_unfulf_amt_age'
503: , p_alias_name => 'POA_MEASURE9'
504: , p_prefix => 'nvl('

Line 538: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

534: PROCEDURE sum_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
535: x_custom_sql OUT NOCOPY VARCHAR2,
536: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
537: IS
538: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
539: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
540: l_query varchar2(10000);
541: l_view_by varchar2(120);
542: l_view_by_col varchar2(120);

Line 539: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

535: x_custom_sql OUT NOCOPY VARCHAR2,
536: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
537: IS
538: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
539: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
540: l_query varchar2(10000);
541: l_view_by varchar2(120);
542: l_view_by_col varchar2(120);
543: l_as_of_date date;

Line 549: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

545: l_xtd varchar2(10);
546: l_comparison_type varchar2(1);
547: l_nested_pattern number;
548: l_cur_suffix varchar2(2);
549: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
550: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
551: l_where_clause VARCHAR2(2000);
552: l_mv VARCHAR2(30);
553: l_view_by_value varchar2(30);

Line 550: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

546: l_comparison_type varchar2(1);
547: l_nested_pattern number;
548: l_cur_suffix varchar2(2);
549: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
550: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
551: l_where_clause VARCHAR2(2000);
552: l_mv VARCHAR2(30);
553: l_view_by_value varchar2(30);
554: ERR_MSG VARCHAR2(100);

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

553: l_view_by_value varchar2(30);
554: ERR_MSG VARCHAR2(100);
555: ERR_CDE NUMBER;
556: BEGIN
557: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
558: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
559: l_comparison_type := 'Y';
560: poa_dbi_sutil_pkg.process_parameters(p_param
561: , l_view_by

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

554: ERR_MSG VARCHAR2(100);
555: ERR_CDE NUMBER;
556: BEGIN
557: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
558: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
559: l_comparison_type := 'Y';
560: poa_dbi_sutil_pkg.process_parameters(p_param
561: , l_view_by
562: , l_view_by_col

Line 581: poa_dbi_util_pkg.add_column(l_col_tbl

577: , p_version => '7.1'
578: , p_role => 'VPP'
579: , p_mv_set => 'REQS');
580:
581: poa_dbi_util_pkg.add_column(l_col_tbl
582: ,'unfulfilled_cnt'
583: , 'unfulf_cnt'
584: , p_grand_total => 'Y'
585: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 585: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

581: poa_dbi_util_pkg.add_column(l_col_tbl
582: ,'unfulfilled_cnt'
583: , 'unfulf_cnt'
584: , p_grand_total => 'Y'
585: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
586: , p_to_date_type => 'NA');
587: poa_dbi_util_pkg.add_column(l_col_tbl
588: ,'pen_fulfill_cnt'
589: , 'pen_fulf_cnt'

Line 587: poa_dbi_util_pkg.add_column(l_col_tbl

583: , 'unfulf_cnt'
584: , p_grand_total => 'Y'
585: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
586: , p_to_date_type => 'NA');
587: poa_dbi_util_pkg.add_column(l_col_tbl
588: ,'pen_fulfill_cnt'
589: , 'pen_fulf_cnt'
590: , p_grand_total => 'Y'
591: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 591: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

587: poa_dbi_util_pkg.add_column(l_col_tbl
588: ,'pen_fulfill_cnt'
589: , 'pen_fulf_cnt'
590: , p_grand_total => 'Y'
591: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
592: , p_to_date_type => 'NA');
593: poa_dbi_util_pkg.add_column(l_col_tbl
594: ,'unfulfilled_ped_cnt'
595: , 'unfulf_ped_cnt'

Line 593: poa_dbi_util_pkg.add_column(l_col_tbl

589: , 'pen_fulf_cnt'
590: , p_grand_total => 'Y'
591: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
592: , p_to_date_type => 'NA');
593: poa_dbi_util_pkg.add_column(l_col_tbl
594: ,'unfulfilled_ped_cnt'
595: , 'unfulf_ped_cnt'
596: , p_grand_total => 'Y'
597: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 597: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

593: poa_dbi_util_pkg.add_column(l_col_tbl
594: ,'unfulfilled_ped_cnt'
595: , 'unfulf_ped_cnt'
596: , p_grand_total => 'Y'
597: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
598: , p_to_date_type => 'NA');
599:
600: poa_dbi_util_pkg.add_column(l_col_tbl
601: ,'unful_po_revisions'

Line 600: poa_dbi_util_pkg.add_column(l_col_tbl

596: , p_grand_total => 'Y'
597: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
598: , p_to_date_type => 'NA');
599:
600: poa_dbi_util_pkg.add_column(l_col_tbl
601: ,'unful_po_revisions'
602: , 'unful_po_revisions'
603: , p_grand_total => 'Y'
604: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 604: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

600: poa_dbi_util_pkg.add_column(l_col_tbl
601: ,'unful_po_revisions'
602: , 'unful_po_revisions'
603: , p_grand_total => 'Y'
604: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
605: , p_to_date_type => 'NA');
606: if(l_view_by = 'ITEM+POA_ITEMS') then
607: poa_dbi_util_pkg.add_column(l_col_tbl
608: ,'unfulfilled_qty'

Line 607: poa_dbi_util_pkg.add_column(l_col_tbl

603: , p_grand_total => 'Y'
604: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
605: , p_to_date_type => 'NA');
606: if(l_view_by = 'ITEM+POA_ITEMS') then
607: poa_dbi_util_pkg.add_column(l_col_tbl
608: ,'unfulfilled_qty'
609: ,'unfulf_qty'
610: , p_grand_total => 'N'
611: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 611: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

607: poa_dbi_util_pkg.add_column(l_col_tbl
608: ,'unfulfilled_qty'
609: ,'unfulf_qty'
610: , p_grand_total => 'N'
611: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
612: , p_to_date_type => 'NA');
613: end if;
614:
615: l_query := get_sum_sel_clause(

Line 769: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

765: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
766: x_custom_sql OUT NOCOPY VARCHAR2,
767: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
768: IS
769: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
770: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
771: l_query varchar2(10000);
772: l_view_by varchar2(120);
773: l_view_by_col varchar2(120);

Line 770: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

766: x_custom_sql OUT NOCOPY VARCHAR2,
767: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
768: IS
769: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
770: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
771: l_query varchar2(10000);
772: l_view_by varchar2(120);
773: l_view_by_col varchar2(120);
774: l_as_of_date date;

Line 780: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

776: l_xtd varchar2(10);
777: l_comparison_type varchar2(1);
778: l_nested_pattern number;
779: l_cur_suffix varchar2(2);
780: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
781: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
782: l_where_clause VARCHAR2(2000);
783: l_mv VARCHAR2(30);
784: l_view_by_value varchar2(30);

Line 781: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;

777: l_comparison_type varchar2(1);
778: l_nested_pattern number;
779: l_cur_suffix varchar2(2);
780: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
781: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
782: l_where_clause VARCHAR2(2000);
783: l_mv VARCHAR2(30);
784: l_view_by_value varchar2(30);
785: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;

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

785: l_bucket_rec BIS_BUCKET_PUB.BIS_BUCKET_REC_TYPE;
786: ERR_MSG VARCHAR2(100);
787: ERR_CDE NUMBER;
788: BEGIN
789: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
790: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
791: l_comparison_type := 'Y';
792: poa_dbi_sutil_pkg.process_parameters(p_param
793: , l_view_by

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

786: ERR_MSG VARCHAR2(100);
787: ERR_CDE NUMBER;
788: BEGIN
789: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
790: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
791: l_comparison_type := 'Y';
792: poa_dbi_sutil_pkg.process_parameters(p_param
793: , l_view_by
794: , l_view_by_col

Line 812: poa_dbi_util_pkg.add_bucket_columns(

808: , p_func_area => 'PO'
809: , p_version => '7.1'
810: , p_role => 'VPP'
811: , p_mv_set => 'REQS');
812: poa_dbi_util_pkg.add_bucket_columns(
813: p_short_name => 'POA_DBI_UFR_BUCKET'
814: ,p_col_tbl => l_col_tbl
815: ,p_col_name => 'unfulfilled_cnt_age'
816: ,p_alias_name => 'unfulf_cnt_age'

Line 819: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS

815: ,p_col_name => 'unfulfilled_cnt_age'
816: ,p_alias_name => 'unfulf_cnt_age'
817: ,x_bucket_rec => l_bucket_rec
818: ,p_grand_total => 'Y'
819: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
820: ,p_to_date_type => 'NA');
821:
822: poa_dbi_util_pkg.add_column(l_col_tbl
823: ,'unfulfilled_cnt'

Line 822: poa_dbi_util_pkg.add_column(l_col_tbl

818: ,p_grand_total => 'Y'
819: ,p_prior_code => poa_dbi_util_pkg.NO_PRIORS
820: ,p_to_date_type => 'NA');
821:
822: poa_dbi_util_pkg.add_column(l_col_tbl
823: ,'unfulfilled_cnt'
824: , 'unfulf_cnt'
825: , p_grand_total => 'Y'
826: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 826: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

822: poa_dbi_util_pkg.add_column(l_col_tbl
823: ,'unfulfilled_cnt'
824: , 'unfulf_cnt'
825: , p_grand_total => 'Y'
826: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
827: , p_to_date_type => 'NA');
828: poa_dbi_util_pkg.add_column(l_col_tbl
829: ,'num_days_unfulfilled'
830: , 'num_days_unfulf'

Line 828: poa_dbi_util_pkg.add_column(l_col_tbl

824: , 'unfulf_cnt'
825: , p_grand_total => 'Y'
826: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
827: , p_to_date_type => 'NA');
828: poa_dbi_util_pkg.add_column(l_col_tbl
829: ,'num_days_unfulfilled'
830: , 'num_days_unfulf'
831: , p_grand_total => 'Y'
832: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 832: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

828: poa_dbi_util_pkg.add_column(l_col_tbl
829: ,'num_days_unfulfilled'
830: , 'num_days_unfulf'
831: , p_grand_total => 'Y'
832: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
833: , p_to_date_type => 'NA');
834:
835: if(l_view_by = 'ITEM+POA_ITEMS') then
836: poa_dbi_util_pkg.add_column(l_col_tbl

Line 836: poa_dbi_util_pkg.add_column(l_col_tbl

832: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
833: , p_to_date_type => 'NA');
834:
835: if(l_view_by = 'ITEM+POA_ITEMS') then
836: poa_dbi_util_pkg.add_column(l_col_tbl
837: ,'unfulfilled_qty'
838: ,'unfulf_qty'
839: , p_grand_total => 'N'
840: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

Line 840: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

836: poa_dbi_util_pkg.add_column(l_col_tbl
837: ,'unfulfilled_qty'
838: ,'unfulf_qty'
839: , p_grand_total => 'N'
840: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
841: , p_to_date_type => 'NA');
842: end if;
843:
844:

Line 906: || poa_dbi_util_pkg.get_bucket_outer_query(

902: ' oset.POA_MEASURE2 POA_MEASURE2, --Average Age (Days)
903: oset.POA_MEASURE3 POA_MEASURE3 --Unfulfilled Lines'
904:
905: || fnd_global.newline
906: || poa_dbi_util_pkg.get_bucket_outer_query(
907: p_bucket_rec
908: , p_col_name => 'oset.POA_MEASURE4'
909: , p_alias_name => 'POA_MEASURE4'
910: , p_prefix => ''

Line 919: || poa_dbi_util_pkg.get_bucket_outer_query(

915:
916: oset.POA_MEASURE5 POA_MEASURE5, --Grand Total for Average Age (Days)
917: oset.POA_MEASURE6 POA_MEASURE6 --Grand Total for Unfulfilled Lines'
918: || fnd_global.newline
919: || poa_dbi_util_pkg.get_bucket_outer_query(
920: p_bucket_rec
921: , p_col_name => 'oset.POA_MEASURE7'
922: , p_alias_name => 'POA_MEASURE7'
923: , p_prefix => ''

Line 930: poa_dbi_util_pkg.get_bucket_drill_url(

926: || fnd_global.newline ;
927:
928:
929: l_sel_clause := l_sel_clause ||
930: poa_dbi_util_pkg.get_bucket_drill_url(
931: p_bucket_rec
932: , 'POA_ATTRIBUTE5'
933: ,
934: '''pFunctionName=POA_DBI_UFR_DTL&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&POA_ATTRIBUTE10=-2&POA_BUCKET+REQUISITION_AGING='

Line 959: || poa_dbi_util_pkg.get_bucket_outer_query(

955:
956: l_sel_clause := l_sel_clause || ',POA_MEASURE2,POA_MEASURE3'
957:
958: || fnd_global.newline
959: || poa_dbi_util_pkg.get_bucket_outer_query(
960: p_bucket_rec
961: , p_col_name => 'POA_MEASURE4'
962: , p_alias_name => 'POA_MEASURE4'
963: , p_prefix => ''

Line 969: || poa_dbi_util_pkg.get_bucket_outer_query(

965: , p_total_flag => 'N')
966: || fnd_global.newline ||
967: ' ,POA_MEASURE5,
968: POA_MEASURE6'
969: || poa_dbi_util_pkg.get_bucket_outer_query(
970: p_bucket_rec
971: , p_col_name => 'POA_MEASURE7'
972: , p_alias_name => 'POA_MEASURE7'
973: , p_prefix => ''

Line 989: || poa_dbi_util_pkg.get_bucket_outer_query(

985: || ' nvl(c_num_days_unfulf,0)/decode(c_unfulf_cnt,0,null,c_unfulf_cnt) POA_MEASURE2,
986: nvl(c_unfulf_cnt,0) POA_MEASURE3';
987:
988: l_sel_clause := l_sel_clause || fnd_global.newline
989: || poa_dbi_util_pkg.get_bucket_outer_query(
990: p_bucket_rec
991: , p_col_name => 'c_unfulf_cnt_age'
992: , p_alias_name => 'POA_MEASURE4'
993: , p_prefix => 'nvl('

Line 1001: || poa_dbi_util_pkg.get_bucket_outer_query(

997: nvl(c_num_days_unfulf_total,0)/decode(c_unfulf_cnt_total,0,null,c_unfulf_cnt_total) POA_MEASURE5,
998:
999: nvl(c_unfulf_cnt_total,0) POA_MEASURE6'
1000:
1001: || poa_dbi_util_pkg.get_bucket_outer_query(
1002: p_bucket_rec
1003: , p_col_name => 'c_unfulf_cnt_age'
1004: , p_alias_name => 'POA_MEASURE7'
1005: , p_prefix => 'nvl('

Line 1041: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

1037: l_query varchar2(10000);
1038: l_option number;
1039: l_cur_suffix varchar2(2);
1040: l_where_clause varchar2(2000);
1041: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
1042: l_in_join_tables VARCHAR2(240) ;
1043: l_context number;
1044: l_bucket varchar2(400);
1045: l_context_where VARCHAR2(240);

Line 1089: poa_dbi_util_pkg.bind_low_high(p_param

1085: ||' and (&RANGE_HIGH is null or '
1086: ||'(to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'')-fact.req_approved_date)'
1087: || ' < &RANGE_HIGH)';
1088:
1089: poa_dbi_util_pkg.bind_low_high(p_param
1090: , 'POA_DBI_UFR_BUCKET'
1091: , 'POA_BUCKET+REQUISITION_AGING'
1092: , '&RANGE_LOW'
1093: , '&RANGE_HIGH'

Line 1222: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);

1218: and pll.po_header_id=por.po_header_id(+)
1219: and pll.po_release_id=por.po_release_id(+)
1220: ORDER BY rnk';
1221:
1222: poa_dbi_util_pkg.get_custom_status_binds(x_custom_output);
1223:
1224: end;
1225:
1226: