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.OPI_DBI_WMS_RPT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 62: opi_dbi_rpt_util_pkg.process_parameters (

58: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
59: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
60:
61: -- get all the query parameters
62: opi_dbi_rpt_util_pkg.process_parameters (
63: p_param => p_param,
64: p_view_by => l_view_by,
65: p_view_by_col_name => l_view_by_col,
66: p_comparison_type => l_comparison_type,

Line 158: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

154: l_uom VARCHAR2(30);
155: l_view_by_fact_col VARCHAR2(400);
156:
157: BEGIN
158: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
159: (p_view_by_dim);
160: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
161: (p_join_tbl);
162:

Line 160: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

156:
157: BEGIN
158: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
159: (p_view_by_dim);
160: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
161: (p_join_tbl);
162:
163: -- Item Description and UOM for item view by
164: opi_dbi_rpt_util_pkg.get_viewby_item_columns(

Line 164: opi_dbi_rpt_util_pkg.get_viewby_item_columns(

160: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
161: (p_join_tbl);
162:
163: -- Item Description and UOM for item view by
164: opi_dbi_rpt_util_pkg.get_viewby_item_columns(
165: p_dim_name => p_view_by_dim,
166: p_description => l_description,
167: p_uom => l_uom);
168:

Line 172: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)

168:
169: -- Start generating SELECT clause for query
170: l_sel_clause :=
171: 'SELECT
172: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
173: || fnd_global.newline ||' ' || l_description ||
174: ' OPI_ATTRIBUTE10 ';
175:
176: l_sel_clause := l_sel_clause ||'

Line 239: ' || opi_dbi_rpt_util_pkg.nvl_str (

235:
236: l_sel_clause := l_sel_clause ||
237: 'FROM ( SELECT ' || fnd_global.newline ||'
238: ' || l_view_by_fact_col || ',
239: ' || opi_dbi_rpt_util_pkg.nvl_str (
240: p_str => 'p_picks',
241: p_default_val => 0) || ' OPI_MEASURE11,
242: ' || opi_dbi_rpt_util_pkg.nvl_str (
243: p_str => 'c_picks',

Line 242: ' || opi_dbi_rpt_util_pkg.nvl_str (

238: ' || l_view_by_fact_col || ',
239: ' || opi_dbi_rpt_util_pkg.nvl_str (
240: p_str => 'p_picks',
241: p_default_val => 0) || ' OPI_MEASURE11,
242: ' || opi_dbi_rpt_util_pkg.nvl_str (
243: p_str => 'c_picks',
244: p_default_val => 0) || ' OPI_MEASURE1,
245: ' || opi_dbi_rpt_util_pkg.change_str (
246: p_new_numerator => 'c_picks',

Line 245: ' || opi_dbi_rpt_util_pkg.change_str (

241: p_default_val => 0) || ' OPI_MEASURE11,
242: ' || opi_dbi_rpt_util_pkg.nvl_str (
243: p_str => 'c_picks',
244: p_default_val => 0) || ' OPI_MEASURE1,
245: ' || opi_dbi_rpt_util_pkg.change_str (
246: p_new_numerator => 'c_picks',
247: p_old_numerator => 'p_picks',
248: p_denominator => 'p_picks',
249: p_measure_name => 'OPI_MEASURE2') || ',

Line 250: ' || opi_dbi_rpt_util_pkg.percent_str(

246: p_new_numerator => 'c_picks',
247: p_old_numerator => 'p_picks',
248: p_denominator => 'p_picks',
249: p_measure_name => 'OPI_MEASURE2') || ',
250: ' || opi_dbi_rpt_util_pkg.percent_str(
251: p_numerator => 'c_picks',
252: p_denominator => 'c_picks_total',
253: p_measure_name => 'OPI_MEASURE3') || ',
254: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 254: ' || opi_dbi_rpt_util_pkg.nvl_str (

250: ' || opi_dbi_rpt_util_pkg.percent_str(
251: p_numerator => 'c_picks',
252: p_denominator => 'c_picks_total',
253: p_measure_name => 'OPI_MEASURE3') || ',
254: ' || opi_dbi_rpt_util_pkg.nvl_str (
255: p_str => 'p_picks_with_exceptions',
256: p_default_val => 0) || ' OPI_MEASURE12,
257: ' || opi_dbi_rpt_util_pkg.nvl_str (
258: p_str => 'c_picks_with_exceptions',

Line 257: ' || opi_dbi_rpt_util_pkg.nvl_str (

253: p_measure_name => 'OPI_MEASURE3') || ',
254: ' || opi_dbi_rpt_util_pkg.nvl_str (
255: p_str => 'p_picks_with_exceptions',
256: p_default_val => 0) || ' OPI_MEASURE12,
257: ' || opi_dbi_rpt_util_pkg.nvl_str (
258: p_str => 'c_picks_with_exceptions',
259: p_default_val => 0) || ' OPI_MEASURE4,
260: ' || opi_dbi_rpt_util_pkg.change_str (
261: p_new_numerator => 'c_picks_with_exceptions',

Line 260: ' || opi_dbi_rpt_util_pkg.change_str (

256: p_default_val => 0) || ' OPI_MEASURE12,
257: ' || opi_dbi_rpt_util_pkg.nvl_str (
258: p_str => 'c_picks_with_exceptions',
259: p_default_val => 0) || ' OPI_MEASURE4,
260: ' || opi_dbi_rpt_util_pkg.change_str (
261: p_new_numerator => 'c_picks_with_exceptions',
262: p_old_numerator => 'p_picks_with_exceptions',
263: p_denominator => 'p_picks_with_exceptions',
264: p_measure_name => 'OPI_MEASURE5') || ',

Line 265: ' || opi_dbi_rpt_util_pkg.percent_str(

261: p_new_numerator => 'c_picks_with_exceptions',
262: p_old_numerator => 'p_picks_with_exceptions',
263: p_denominator => 'p_picks_with_exceptions',
264: p_measure_name => 'OPI_MEASURE5') || ',
265: ' || opi_dbi_rpt_util_pkg.percent_str(
266: p_numerator => 'p_picks_with_exceptions',
267: p_denominator => 'p_picks',
268: p_measure_name => 'OPI_MEASURE13') || ',
269: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 269: ' || opi_dbi_rpt_util_pkg.percent_str(

265: ' || opi_dbi_rpt_util_pkg.percent_str(
266: p_numerator => 'p_picks_with_exceptions',
267: p_denominator => 'p_picks',
268: p_measure_name => 'OPI_MEASURE13') || ',
269: ' || opi_dbi_rpt_util_pkg.percent_str(
270: p_numerator => 'c_picks_with_exceptions',
271: p_denominator => 'c_picks',
272: p_measure_name => 'OPI_MEASURE6') || ',
273: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 273: ' || opi_dbi_rpt_util_pkg.change_pct_str (

269: ' || opi_dbi_rpt_util_pkg.percent_str(
270: p_numerator => 'c_picks_with_exceptions',
271: p_denominator => 'c_picks',
272: p_measure_name => 'OPI_MEASURE6') || ',
273: ' || opi_dbi_rpt_util_pkg.change_pct_str (
274: p_new_numerator => 'c_picks_with_exceptions',
275: p_new_denominator => 'c_picks',
276: p_old_numerator => 'p_picks_with_exceptions',
277: p_old_denominator => 'p_picks',

Line 279: ' || opi_dbi_rpt_util_pkg.nvl_str (

275: p_new_denominator => 'c_picks',
276: p_old_numerator => 'p_picks_with_exceptions',
277: p_old_denominator => 'p_picks',
278: p_measure_name => 'OPI_MEASURE7') || ',
279: ' || opi_dbi_rpt_util_pkg.nvl_str (
280: p_str => 'p_pick_exceptions',
281: p_default_val => 0) || ' OPI_MEASURE14,
282: ' || opi_dbi_rpt_util_pkg.nvl_str (
283: p_str => 'c_pick_exceptions',

Line 282: ' || opi_dbi_rpt_util_pkg.nvl_str (

278: p_measure_name => 'OPI_MEASURE7') || ',
279: ' || opi_dbi_rpt_util_pkg.nvl_str (
280: p_str => 'p_pick_exceptions',
281: p_default_val => 0) || ' OPI_MEASURE14,
282: ' || opi_dbi_rpt_util_pkg.nvl_str (
283: p_str => 'c_pick_exceptions',
284: p_default_val => 0) || ' OPI_MEASURE8,
285: ' || opi_dbi_rpt_util_pkg.change_str (
286: p_new_numerator => 'c_pick_exceptions',

Line 285: ' || opi_dbi_rpt_util_pkg.change_str (

281: p_default_val => 0) || ' OPI_MEASURE14,
282: ' || opi_dbi_rpt_util_pkg.nvl_str (
283: p_str => 'c_pick_exceptions',
284: p_default_val => 0) || ' OPI_MEASURE8,
285: ' || opi_dbi_rpt_util_pkg.change_str (
286: p_new_numerator => 'c_pick_exceptions',
287: p_old_numerator => 'p_pick_exceptions',
288: p_denominator => 'p_pick_exceptions',
289: p_measure_name => 'OPI_MEASURE9') || ',

Line 290: ' || opi_dbi_rpt_util_pkg.nvl_str (

286: p_new_numerator => 'c_pick_exceptions',
287: p_old_numerator => 'p_pick_exceptions',
288: p_denominator => 'p_pick_exceptions',
289: p_measure_name => 'OPI_MEASURE9') || ',
290: ' || opi_dbi_rpt_util_pkg.nvl_str (
291: p_str => 'c_picks_total',
292: p_default_val => 0) || ' OPI_MEASURE21,
293: ' || opi_dbi_rpt_util_pkg.change_str (
294: p_new_numerator => 'c_picks_total',

Line 293: ' || opi_dbi_rpt_util_pkg.change_str (

289: p_measure_name => 'OPI_MEASURE9') || ',
290: ' || opi_dbi_rpt_util_pkg.nvl_str (
291: p_str => 'c_picks_total',
292: p_default_val => 0) || ' OPI_MEASURE21,
293: ' || opi_dbi_rpt_util_pkg.change_str (
294: p_new_numerator => 'c_picks_total',
295: p_old_numerator => 'p_picks_total',
296: p_denominator => 'p_picks_total',
297: p_measure_name => 'OPI_MEASURE22') || ',

Line 298: ' || opi_dbi_rpt_util_pkg.percent_str(

294: p_new_numerator => 'c_picks_total',
295: p_old_numerator => 'p_picks_total',
296: p_denominator => 'p_picks_total',
297: p_measure_name => 'OPI_MEASURE22') || ',
298: ' || opi_dbi_rpt_util_pkg.percent_str(
299: p_numerator => 'c_picks_total',
300: p_denominator => 'c_picks_total',
301: p_measure_name => 'OPI_MEASURE23') || ',
302: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 302: ' || opi_dbi_rpt_util_pkg.nvl_str (

298: ' || opi_dbi_rpt_util_pkg.percent_str(
299: p_numerator => 'c_picks_total',
300: p_denominator => 'c_picks_total',
301: p_measure_name => 'OPI_MEASURE23') || ',
302: ' || opi_dbi_rpt_util_pkg.nvl_str (
303: p_str => 'c_picks_with_exceptions_total',
304: p_default_val => 0) || ' OPI_MEASURE24,
305: ' || opi_dbi_rpt_util_pkg.change_str (
306: p_new_numerator => 'c_picks_with_exceptions_total',

Line 305: ' || opi_dbi_rpt_util_pkg.change_str (

301: p_measure_name => 'OPI_MEASURE23') || ',
302: ' || opi_dbi_rpt_util_pkg.nvl_str (
303: p_str => 'c_picks_with_exceptions_total',
304: p_default_val => 0) || ' OPI_MEASURE24,
305: ' || opi_dbi_rpt_util_pkg.change_str (
306: p_new_numerator => 'c_picks_with_exceptions_total',
307: p_old_numerator => 'p_picks_with_exceptions_total',
308: p_denominator => 'p_picks_with_exceptions_total',
309: p_measure_name => 'OPI_MEASURE25') || ',

Line 310: ' || opi_dbi_rpt_util_pkg.percent_str(

306: p_new_numerator => 'c_picks_with_exceptions_total',
307: p_old_numerator => 'p_picks_with_exceptions_total',
308: p_denominator => 'p_picks_with_exceptions_total',
309: p_measure_name => 'OPI_MEASURE25') || ',
310: ' || opi_dbi_rpt_util_pkg.percent_str(
311: p_numerator => 'c_picks_with_exceptions_total',
312: p_denominator => 'c_picks_total',
313: p_measure_name => 'OPI_MEASURE26') || ',
314: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 314: ' || opi_dbi_rpt_util_pkg.change_pct_str (

310: ' || opi_dbi_rpt_util_pkg.percent_str(
311: p_numerator => 'c_picks_with_exceptions_total',
312: p_denominator => 'c_picks_total',
313: p_measure_name => 'OPI_MEASURE26') || ',
314: ' || opi_dbi_rpt_util_pkg.change_pct_str (
315: p_new_numerator => 'c_picks_with_exceptions_total',
316: p_new_denominator => 'c_picks_total',
317: p_old_numerator => 'p_picks_with_exceptions_total',
318: p_old_denominator => 'p_picks_total',

Line 320: ' || opi_dbi_rpt_util_pkg.nvl_str (

316: p_new_denominator => 'c_picks_total',
317: p_old_numerator => 'p_picks_with_exceptions_total',
318: p_old_denominator => 'p_picks_total',
319: p_measure_name => 'OPI_MEASURE27') || ',
320: ' || opi_dbi_rpt_util_pkg.nvl_str (
321: p_str => 'c_pick_exceptions_total',
322: p_default_val => 0) || ' OPI_MEASURE28,
323: ' || opi_dbi_rpt_util_pkg.change_str (
324: p_new_numerator => 'c_pick_exceptions_total',

Line 323: ' || opi_dbi_rpt_util_pkg.change_str (

319: p_measure_name => 'OPI_MEASURE27') || ',
320: ' || opi_dbi_rpt_util_pkg.nvl_str (
321: p_str => 'c_pick_exceptions_total',
322: p_default_val => 0) || ' OPI_MEASURE28,
323: ' || opi_dbi_rpt_util_pkg.change_str (
324: p_new_numerator => 'c_pick_exceptions_total',
325: p_old_numerator => 'p_pick_exceptions_total',
326: p_denominator => 'p_pick_exceptions_total',
327: p_measure_name => 'OPI_MEASURE29') || ',

Line 328: ' || opi_dbi_rpt_util_pkg.percent_str(

324: p_new_numerator => 'c_pick_exceptions_total',
325: p_old_numerator => 'p_pick_exceptions_total',
326: p_denominator => 'p_pick_exceptions_total',
327: p_measure_name => 'OPI_MEASURE29') || ',
328: ' || opi_dbi_rpt_util_pkg.percent_str(
329: p_numerator => 'c_picks_with_exceptions',
330: p_denominator => 'c_picks',
331: p_measure_name => 'OPI_MEASURE30') || ',
332: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 332: ' || opi_dbi_rpt_util_pkg.percent_str(

328: ' || opi_dbi_rpt_util_pkg.percent_str(
329: p_numerator => 'c_picks_with_exceptions',
330: p_denominator => 'c_picks',
331: p_measure_name => 'OPI_MEASURE30') || ',
332: ' || opi_dbi_rpt_util_pkg.percent_str(
333: p_numerator => 'p_picks_with_exceptions',
334: p_denominator => 'p_picks',
335: p_measure_name => 'OPI_MEASURE31') || ',
336: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 336: ' || opi_dbi_rpt_util_pkg.percent_str(

332: ' || opi_dbi_rpt_util_pkg.percent_str(
333: p_numerator => 'p_picks_with_exceptions',
334: p_denominator => 'p_picks',
335: p_measure_name => 'OPI_MEASURE31') || ',
336: ' || opi_dbi_rpt_util_pkg.percent_str(
337: p_numerator => 'c_picks_with_exceptions_total',
338: p_denominator => 'c_picks_total',
339: p_measure_name => 'OPI_MEASURE32') || ',
340: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 340: ' || opi_dbi_rpt_util_pkg.percent_str(

336: ' || opi_dbi_rpt_util_pkg.percent_str(
337: p_numerator => 'c_picks_with_exceptions_total',
338: p_denominator => 'c_picks_total',
339: p_measure_name => 'OPI_MEASURE32') || ',
340: ' || opi_dbi_rpt_util_pkg.percent_str(
341: p_numerator => 'p_picks_with_exceptions_total',
342: p_denominator => 'p_picks_total',
343: p_measure_name => 'OPI_MEASURE33');
344: RETURN l_sel_clause;

Line 383: opi_dbi_rpt_util_pkg.process_parameters (

379: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
380: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
381:
382: -- get all the query parameters
383: opi_dbi_rpt_util_pkg.process_parameters (
384: p_param => p_param,
385: p_view_by => l_view_by,
386: p_view_by_col_name => l_view_by_col,
387: p_comparison_type => l_comparison_type,

Line 458: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

454: l_sel_clause VARCHAR2(15000);
455: l_view_by_col_name VARCHAR2(120);
456: l_view_by_fact_col VARCHAR2(400);
457: BEGIN
458: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
459: (p_view_by_dim);
460: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
461: (p_join_tbl);
462:

Line 460: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

456: l_view_by_fact_col VARCHAR2(400);
457: BEGIN
458: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
459: (p_view_by_dim);
460: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
461: (p_join_tbl);
462:
463: -- Start generating SELECT clause for query
464: l_sel_clause :=

Line 466: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)

462:
463: -- Start generating SELECT clause for query
464: l_sel_clause :=
465: 'SELECT
466: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
467: || fnd_global.newline;
468:
469: l_sel_clause := l_sel_clause ||
470: 'OPI_MEASURE1

Line 491: ' || opi_dbi_rpt_util_pkg.nvl_str (

487:
488: l_sel_clause := l_sel_clause ||
489: 'FROM ( SELECT ' || fnd_global.newline ||'
490: ' || l_view_by_fact_col || ',
491: ' || opi_dbi_rpt_util_pkg.nvl_str (
492: p_str => 'c_exceptions',
493: p_default_val => 0) || ' OPI_MEASURE1,
494: ' || opi_dbi_rpt_util_pkg.change_str (
495: p_new_numerator => 'c_exceptions',

Line 494: ' || opi_dbi_rpt_util_pkg.change_str (

490: ' || l_view_by_fact_col || ',
491: ' || opi_dbi_rpt_util_pkg.nvl_str (
492: p_str => 'c_exceptions',
493: p_default_val => 0) || ' OPI_MEASURE1,
494: ' || opi_dbi_rpt_util_pkg.change_str (
495: p_new_numerator => 'c_exceptions',
496: p_old_numerator => 'p_exceptions',
497: p_denominator => 'p_exceptions',
498: p_measure_name => 'OPI_MEASURE2') || ',

Line 499: ' || opi_dbi_rpt_util_pkg.percent_str(

495: p_new_numerator => 'c_exceptions',
496: p_old_numerator => 'p_exceptions',
497: p_denominator => 'p_exceptions',
498: p_measure_name => 'OPI_MEASURE2') || ',
499: ' || opi_dbi_rpt_util_pkg.percent_str(
500: p_numerator => 'c_exceptions',
501: p_denominator => 'c_exceptions_total',
502: p_measure_name => 'OPI_MEASURE3') || ',
503: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 503: ' || opi_dbi_rpt_util_pkg.nvl_str (

499: ' || opi_dbi_rpt_util_pkg.percent_str(
500: p_numerator => 'c_exceptions',
501: p_denominator => 'c_exceptions_total',
502: p_measure_name => 'OPI_MEASURE3') || ',
503: ' || opi_dbi_rpt_util_pkg.nvl_str (
504: p_str => 'c_exceptions_total',
505: p_default_val => 0) || ' OPI_MEASURE4,
506: ' || opi_dbi_rpt_util_pkg.change_str (
507: p_new_numerator => 'c_exceptions_total',

Line 506: ' || opi_dbi_rpt_util_pkg.change_str (

502: p_measure_name => 'OPI_MEASURE3') || ',
503: ' || opi_dbi_rpt_util_pkg.nvl_str (
504: p_str => 'c_exceptions_total',
505: p_default_val => 0) || ' OPI_MEASURE4,
506: ' || opi_dbi_rpt_util_pkg.change_str (
507: p_new_numerator => 'c_exceptions_total',
508: p_old_numerator => 'p_exceptions_total',
509: p_denominator => 'p_exceptions_total',
510: p_measure_name => 'OPI_MEASURE5') || ',

Line 511: ' || opi_dbi_rpt_util_pkg.percent_str(

507: p_new_numerator => 'c_exceptions_total',
508: p_old_numerator => 'p_exceptions_total',
509: p_denominator => 'p_exceptions_total',
510: p_measure_name => 'OPI_MEASURE5') || ',
511: ' || opi_dbi_rpt_util_pkg.percent_str(
512: p_numerator => 'c_exceptions_total',
513: p_denominator => 'c_exceptions_total',
514: p_measure_name => 'OPI_MEASURE6');
515: RETURN l_sel_clause;

Line 553: opi_dbi_rpt_util_pkg.process_parameters (

549: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
550: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
551:
552: -- Get Report Parameters for query
553: opi_dbi_rpt_util_pkg.process_parameters (
554: p_param => p_param,
555: p_view_by => l_view_by,
556: p_view_by_col_name => l_view_by_col,
557: p_comparison_type => l_comparison_type,

Line 642: ' || opi_dbi_rpt_util_pkg.nvl_str (

638: BEGIN
639: -- Main Outer query
640: l_sel_clause := 'SELECT
641: ' || ' cal.name VIEWBY,
642: ' || opi_dbi_rpt_util_pkg.nvl_str (
643: p_str => 'p_picks',
644: p_default_val => 0) || ' OPI_MEASURE11,
645: ' || opi_dbi_rpt_util_pkg.nvl_str (
646: p_str => 'c_picks',

Line 645: ' || opi_dbi_rpt_util_pkg.nvl_str (

641: ' || ' cal.name VIEWBY,
642: ' || opi_dbi_rpt_util_pkg.nvl_str (
643: p_str => 'p_picks',
644: p_default_val => 0) || ' OPI_MEASURE11,
645: ' || opi_dbi_rpt_util_pkg.nvl_str (
646: p_str => 'c_picks',
647: p_default_val => 0) || ' OPI_MEASURE1,
648: ' || opi_dbi_rpt_util_pkg.change_str (
649: p_new_numerator => 'c_picks',

Line 648: ' || opi_dbi_rpt_util_pkg.change_str (

644: p_default_val => 0) || ' OPI_MEASURE11,
645: ' || opi_dbi_rpt_util_pkg.nvl_str (
646: p_str => 'c_picks',
647: p_default_val => 0) || ' OPI_MEASURE1,
648: ' || opi_dbi_rpt_util_pkg.change_str (
649: p_new_numerator => 'c_picks',
650: p_old_numerator => 'p_picks',
651: p_denominator => 'p_picks',
652: p_measure_name => 'OPI_MEASURE2') || ',

Line 653: ' || opi_dbi_rpt_util_pkg.nvl_str (

649: p_new_numerator => 'c_picks',
650: p_old_numerator => 'p_picks',
651: p_denominator => 'p_picks',
652: p_measure_name => 'OPI_MEASURE2') || ',
653: ' || opi_dbi_rpt_util_pkg.nvl_str (
654: p_str => 'p_picks_with_exceptions',
655: p_default_val => 0) || ' OPI_MEASURE12,
656: ' || opi_dbi_rpt_util_pkg.nvl_str (
657: p_str => 'c_picks_with_exceptions',

Line 656: ' || opi_dbi_rpt_util_pkg.nvl_str (

652: p_measure_name => 'OPI_MEASURE2') || ',
653: ' || opi_dbi_rpt_util_pkg.nvl_str (
654: p_str => 'p_picks_with_exceptions',
655: p_default_val => 0) || ' OPI_MEASURE12,
656: ' || opi_dbi_rpt_util_pkg.nvl_str (
657: p_str => 'c_picks_with_exceptions',
658: p_default_val => 0) || ' OPI_MEASURE3,
659: ' || opi_dbi_rpt_util_pkg.change_str (
660: p_new_numerator => 'c_picks_with_exceptions',

Line 659: ' || opi_dbi_rpt_util_pkg.change_str (

655: p_default_val => 0) || ' OPI_MEASURE12,
656: ' || opi_dbi_rpt_util_pkg.nvl_str (
657: p_str => 'c_picks_with_exceptions',
658: p_default_val => 0) || ' OPI_MEASURE3,
659: ' || opi_dbi_rpt_util_pkg.change_str (
660: p_new_numerator => 'c_picks_with_exceptions',
661: p_old_numerator => 'p_picks_with_exceptions',
662: p_denominator => 'p_picks_with_exceptions',
663: p_measure_name => 'OPI_MEASURE4') || ',

Line 664: ' || opi_dbi_rpt_util_pkg.percent_str(

660: p_new_numerator => 'c_picks_with_exceptions',
661: p_old_numerator => 'p_picks_with_exceptions',
662: p_denominator => 'p_picks_with_exceptions',
663: p_measure_name => 'OPI_MEASURE4') || ',
664: ' || opi_dbi_rpt_util_pkg.percent_str(
665: p_numerator => 'p_picks_with_exceptions',
666: p_denominator => 'p_picks',
667: p_measure_name => 'OPI_MEASURE13') || ',
668: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 668: ' || opi_dbi_rpt_util_pkg.percent_str(

664: ' || opi_dbi_rpt_util_pkg.percent_str(
665: p_numerator => 'p_picks_with_exceptions',
666: p_denominator => 'p_picks',
667: p_measure_name => 'OPI_MEASURE13') || ',
668: ' || opi_dbi_rpt_util_pkg.percent_str(
669: p_numerator => 'c_picks_with_exceptions',
670: p_denominator => 'c_picks',
671: p_measure_name => 'OPI_MEASURE5') || ',
672: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 672: ' || opi_dbi_rpt_util_pkg.change_pct_str (

668: ' || opi_dbi_rpt_util_pkg.percent_str(
669: p_numerator => 'c_picks_with_exceptions',
670: p_denominator => 'c_picks',
671: p_measure_name => 'OPI_MEASURE5') || ',
672: ' || opi_dbi_rpt_util_pkg.change_pct_str (
673: p_new_numerator => 'c_picks_with_exceptions',
674: p_new_denominator => 'c_picks',
675: p_old_numerator => 'p_picks_with_exceptions',
676: p_old_denominator => 'p_picks',

Line 678: ' || opi_dbi_rpt_util_pkg.nvl_str (

674: p_new_denominator => 'c_picks',
675: p_old_numerator => 'p_picks_with_exceptions',
676: p_old_denominator => 'p_picks',
677: p_measure_name => 'OPI_MEASURE6') || ',
678: ' || opi_dbi_rpt_util_pkg.nvl_str (
679: p_str => 'p_pick_exceptions',
680: p_default_val => 0) || ' OPI_MEASURE14,
681: ' || opi_dbi_rpt_util_pkg.nvl_str (
682: p_str => 'c_pick_exceptions',

Line 681: ' || opi_dbi_rpt_util_pkg.nvl_str (

677: p_measure_name => 'OPI_MEASURE6') || ',
678: ' || opi_dbi_rpt_util_pkg.nvl_str (
679: p_str => 'p_pick_exceptions',
680: p_default_val => 0) || ' OPI_MEASURE14,
681: ' || opi_dbi_rpt_util_pkg.nvl_str (
682: p_str => 'c_pick_exceptions',
683: p_default_val => 0) || ' OPI_MEASURE7,
684: ' || opi_dbi_rpt_util_pkg.change_str (
685: p_new_numerator => 'c_pick_exceptions',

Line 684: ' || opi_dbi_rpt_util_pkg.change_str (

680: p_default_val => 0) || ' OPI_MEASURE14,
681: ' || opi_dbi_rpt_util_pkg.nvl_str (
682: p_str => 'c_pick_exceptions',
683: p_default_val => 0) || ' OPI_MEASURE7,
684: ' || opi_dbi_rpt_util_pkg.change_str (
685: p_new_numerator => 'c_pick_exceptions',
686: p_old_numerator => 'p_pick_exceptions',
687: p_denominator => 'p_pick_exceptions',
688: p_measure_name => 'OPI_MEASURE8');

Line 729: opi_dbi_rpt_util_pkg.process_parameters (

725: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
726: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
727:
728: -- get all the query parameters
729: opi_dbi_rpt_util_pkg.process_parameters (
730: p_param => p_param,
731: p_view_by => l_view_by,
732: p_view_by_col_name => l_view_by_col,
733: p_comparison_type => l_comparison_type,

Line 829: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

825: l_sel_clause VARCHAR2(15000);
826: l_view_by_col_name VARCHAR2(120);
827: l_view_by_fact_col VARCHAR2(400);
828: BEGIN
829: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
830: (p_view_by_dim);
831: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
832: (p_join_tbl);
833:

Line 831: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

827: l_view_by_fact_col VARCHAR2(400);
828: BEGIN
829: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
830: (p_view_by_dim);
831: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
832: (p_join_tbl);
833:
834: -- Start generating SELECT clause for query
835: l_sel_clause :=

Line 837: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;

833:
834: -- Start generating SELECT clause for query
835: l_sel_clause :=
836: 'SELECT
837: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;
838:
839: l_sel_clause := l_sel_clause ||'
840: OPI_MEASURE13
841: ,OPI_MEASURE2

Line 889: ',' || opi_dbi_rpt_util_pkg.rate_str (

885:
886: l_sel_clause := l_sel_clause ||
887: 'FROM ( SELECT ' || fnd_global.newline ||
888: l_view_by_fact_col || fnd_global.newline ||
889: ',' || opi_dbi_rpt_util_pkg.rate_str (
890: p_numerator => 'p_elapsed_time',
891: p_denominator => 'p_executions',
892: p_rate_type => 'NP') || 'OPI_MEASURE13,
893: ' || opi_dbi_rpt_util_pkg.rate_str (

Line 893: ' || opi_dbi_rpt_util_pkg.rate_str (

889: ',' || opi_dbi_rpt_util_pkg.rate_str (
890: p_numerator => 'p_elapsed_time',
891: p_denominator => 'p_executions',
892: p_rate_type => 'NP') || 'OPI_MEASURE13,
893: ' || opi_dbi_rpt_util_pkg.rate_str (
894: p_numerator => 'c_elapsed_time',
895: p_denominator => 'c_executions',
896: p_rate_type => 'NP') || 'OPI_MEASURE2,
897: ' || opi_dbi_rpt_util_pkg.change_pct_str_basic(

Line 897: ' || opi_dbi_rpt_util_pkg.change_pct_str_basic(

893: ' || opi_dbi_rpt_util_pkg.rate_str (
894: p_numerator => 'c_elapsed_time',
895: p_denominator => 'c_executions',
896: p_rate_type => 'NP') || 'OPI_MEASURE2,
897: ' || opi_dbi_rpt_util_pkg.change_pct_str_basic(
898: p_new_numerator => 'c_elapsed_time',
899: p_new_denominator => 'c_executions',
900: p_old_numerator => 'p_elapsed_time',
901: p_old_denominator => 'c_executions',

Line 903: ' || opi_dbi_rpt_util_pkg.nvl_str (

899: p_new_denominator => 'c_executions',
900: p_old_numerator => 'p_elapsed_time',
901: p_old_denominator => 'c_executions',
902: p_measure_name => 'OPI_MEASURE3') || ',
903: ' || opi_dbi_rpt_util_pkg.nvl_str (
904: p_str => 'c_executions',
905: p_default_val => 0) || ' OPI_MEASURE4,
906: ' || opi_dbi_rpt_util_pkg.nvl_str (
907: p_str => 'c_exec_with_exceptions',

Line 906: ' || opi_dbi_rpt_util_pkg.nvl_str (

902: p_measure_name => 'OPI_MEASURE3') || ',
903: ' || opi_dbi_rpt_util_pkg.nvl_str (
904: p_str => 'c_executions',
905: p_default_val => 0) || ' OPI_MEASURE4,
906: ' || opi_dbi_rpt_util_pkg.nvl_str (
907: p_str => 'c_exec_with_exceptions',
908: p_default_val => 0) || ' OPI_MEASURE5,
909: ' || opi_dbi_rpt_util_pkg.rate_str (
910: p_numerator => 'p_exec_with_exceptions',

Line 909: ' || opi_dbi_rpt_util_pkg.rate_str (

905: p_default_val => 0) || ' OPI_MEASURE4,
906: ' || opi_dbi_rpt_util_pkg.nvl_str (
907: p_str => 'c_exec_with_exceptions',
908: p_default_val => 0) || ' OPI_MEASURE5,
909: ' || opi_dbi_rpt_util_pkg.rate_str (
910: p_numerator => 'p_exec_with_exceptions',
911: p_denominator => 'p_executions',
912: p_rate_type => 'P') || 'OPI_MEASURE15,
913: ' || opi_dbi_rpt_util_pkg.rate_str (

Line 913: ' || opi_dbi_rpt_util_pkg.rate_str (

909: ' || opi_dbi_rpt_util_pkg.rate_str (
910: p_numerator => 'p_exec_with_exceptions',
911: p_denominator => 'p_executions',
912: p_rate_type => 'P') || 'OPI_MEASURE15,
913: ' || opi_dbi_rpt_util_pkg.rate_str (
914: p_numerator => 'c_exec_with_exceptions',
915: p_denominator => 'c_executions',
916: p_rate_type => 'P') || 'OPI_MEASURE6,
917: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 917: ' || opi_dbi_rpt_util_pkg.change_pct_str (

913: ' || opi_dbi_rpt_util_pkg.rate_str (
914: p_numerator => 'c_exec_with_exceptions',
915: p_denominator => 'c_executions',
916: p_rate_type => 'P') || 'OPI_MEASURE6,
917: ' || opi_dbi_rpt_util_pkg.change_pct_str (
918: p_new_numerator => 'c_exec_with_exceptions',
919: p_new_denominator => 'c_executions',
920: p_old_numerator => 'p_exec_with_exceptions',
921: p_old_denominator => 'p_executions',

Line 923: ' || opi_dbi_rpt_util_pkg.nvl_str (

919: p_new_denominator => 'c_executions',
920: p_old_numerator => 'p_exec_with_exceptions',
921: p_old_denominator => 'p_executions',
922: p_measure_name => 'OPI_MEASURE7') || ',
923: ' || opi_dbi_rpt_util_pkg.nvl_str (
924: p_str => 'p_exceptions',
925: p_default_val => 0) || ' OPI_MEASURE16,
926: ' || opi_dbi_rpt_util_pkg.nvl_str (
927: p_str => 'c_exceptions',

Line 926: ' || opi_dbi_rpt_util_pkg.nvl_str (

922: p_measure_name => 'OPI_MEASURE7') || ',
923: ' || opi_dbi_rpt_util_pkg.nvl_str (
924: p_str => 'p_exceptions',
925: p_default_val => 0) || ' OPI_MEASURE16,
926: ' || opi_dbi_rpt_util_pkg.nvl_str (
927: p_str => 'c_exceptions',
928: p_default_val => 0) || ' OPI_MEASURE8,
929: ' || opi_dbi_rpt_util_pkg.change_str (
930: p_new_numerator => 'c_exceptions',

Line 929: ' || opi_dbi_rpt_util_pkg.change_str (

925: p_default_val => 0) || ' OPI_MEASURE16,
926: ' || opi_dbi_rpt_util_pkg.nvl_str (
927: p_str => 'c_exceptions',
928: p_default_val => 0) || ' OPI_MEASURE8,
929: ' || opi_dbi_rpt_util_pkg.change_str (
930: p_new_numerator => 'c_exceptions',
931: p_old_numerator => 'p_exceptions',
932: p_denominator => 'p_exceptions',
933: p_measure_name => 'OPI_MEASURE9') || ',

Line 934: ' || opi_dbi_rpt_util_pkg.rate_str (

930: p_new_numerator => 'c_exceptions',
931: p_old_numerator => 'p_exceptions',
932: p_denominator => 'p_exceptions',
933: p_measure_name => 'OPI_MEASURE9') || ',
934: ' || opi_dbi_rpt_util_pkg.rate_str (
935: p_numerator => 'c_elapsed_time_total',
936: p_denominator => 'c_executions_total',
937: p_rate_type => 'NP') || 'OPI_MEASURE21,
938: ' || opi_dbi_rpt_util_pkg.change_pct_str_basic(

Line 938: ' || opi_dbi_rpt_util_pkg.change_pct_str_basic(

934: ' || opi_dbi_rpt_util_pkg.rate_str (
935: p_numerator => 'c_elapsed_time_total',
936: p_denominator => 'c_executions_total',
937: p_rate_type => 'NP') || 'OPI_MEASURE21,
938: ' || opi_dbi_rpt_util_pkg.change_pct_str_basic(
939: p_new_numerator => 'c_elapsed_time_total',
940: p_new_denominator => 'c_executions_total',
941: p_old_numerator => 'p_elapsed_time_total',
942: p_old_denominator => 'c_executions_total',

Line 944: ' || opi_dbi_rpt_util_pkg.nvl_str (

940: p_new_denominator => 'c_executions_total',
941: p_old_numerator => 'p_elapsed_time_total',
942: p_old_denominator => 'c_executions_total',
943: p_measure_name => 'OPI_MEASURE22') || ',
944: ' || opi_dbi_rpt_util_pkg.nvl_str (
945: p_str => 'c_executions_total',
946: p_default_val => 0) || ' OPI_MEASURE23,
947: ' || opi_dbi_rpt_util_pkg.nvl_str (
948: p_str => 'c_exec_with_exceptions_total',

Line 947: ' || opi_dbi_rpt_util_pkg.nvl_str (

943: p_measure_name => 'OPI_MEASURE22') || ',
944: ' || opi_dbi_rpt_util_pkg.nvl_str (
945: p_str => 'c_executions_total',
946: p_default_val => 0) || ' OPI_MEASURE23,
947: ' || opi_dbi_rpt_util_pkg.nvl_str (
948: p_str => 'c_exec_with_exceptions_total',
949: p_default_val => 0) || ' OPI_MEASURE24,
950: ' || opi_dbi_rpt_util_pkg.rate_str (
951: p_numerator => 'c_exec_with_exceptions_total',

Line 950: ' || opi_dbi_rpt_util_pkg.rate_str (

946: p_default_val => 0) || ' OPI_MEASURE23,
947: ' || opi_dbi_rpt_util_pkg.nvl_str (
948: p_str => 'c_exec_with_exceptions_total',
949: p_default_val => 0) || ' OPI_MEASURE24,
950: ' || opi_dbi_rpt_util_pkg.rate_str (
951: p_numerator => 'c_exec_with_exceptions_total',
952: p_denominator => 'c_executions_total',
953: p_rate_type => 'P') || 'OPI_MEASURE25,
954: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 954: ' || opi_dbi_rpt_util_pkg.change_pct_str (

950: ' || opi_dbi_rpt_util_pkg.rate_str (
951: p_numerator => 'c_exec_with_exceptions_total',
952: p_denominator => 'c_executions_total',
953: p_rate_type => 'P') || 'OPI_MEASURE25,
954: ' || opi_dbi_rpt_util_pkg.change_pct_str (
955: p_new_numerator => 'c_exec_with_exceptions_total',
956: p_new_denominator => 'c_executions_total',
957: p_old_numerator => 'p_exec_with_exceptions_total',
958: p_old_denominator => 'p_executions_total',

Line 960: ' || opi_dbi_rpt_util_pkg.nvl_str (

956: p_new_denominator => 'c_executions_total',
957: p_old_numerator => 'p_exec_with_exceptions_total',
958: p_old_denominator => 'p_executions_total',
959: p_measure_name => 'OPI_MEASURE26') || ',
960: ' || opi_dbi_rpt_util_pkg.nvl_str (
961: p_str => 'c_exceptions_total',
962: p_default_val => 0) || ' OPI_MEASURE27,
963: ' || opi_dbi_rpt_util_pkg.change_str (
964: p_new_numerator => 'c_exceptions_total',

Line 963: ' || opi_dbi_rpt_util_pkg.change_str (

959: p_measure_name => 'OPI_MEASURE26') || ',
960: ' || opi_dbi_rpt_util_pkg.nvl_str (
961: p_str => 'c_exceptions_total',
962: p_default_val => 0) || ' OPI_MEASURE27,
963: ' || opi_dbi_rpt_util_pkg.change_str (
964: p_new_numerator => 'c_exceptions_total',
965: p_old_numerator => 'p_exceptions_total',
966: p_denominator => 'p_exceptions_total',
967: p_measure_name => 'OPI_MEASURE28');

Line 1008: opi_dbi_rpt_util_pkg.process_parameters (

1004: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1005: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
1006:
1007: -- get all the query parameters
1008: opi_dbi_rpt_util_pkg.process_parameters (
1009: p_param => p_param,
1010: p_view_by => l_view_by,
1011: p_view_by_col_name => l_view_by_col,
1012: p_comparison_type => l_comparison_type,

Line 1082: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

1078: l_sel_clause VARCHAR2(15000);
1079: l_view_by_col_name VARCHAR2(120);
1080: l_view_by_fact_col VARCHAR2(400);
1081: BEGIN
1082: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
1083: (p_view_by_dim);
1084: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
1085: (p_join_tbl);
1086:

Line 1084: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

1080: l_view_by_fact_col VARCHAR2(400);
1081: BEGIN
1082: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
1083: (p_view_by_dim);
1084: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
1085: (p_join_tbl);
1086:
1087: -- Start generating SELECT clause for query
1088: l_sel_clause :=

Line 1090: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)

1086:
1087: -- Start generating SELECT clause for query
1088: l_sel_clause :=
1089: 'SELECT
1090: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
1091: || fnd_global.newline;
1092:
1093: l_sel_clause := l_sel_clause ||
1094: ' OPI_MEASURE1

Line 1115: ',' || opi_dbi_rpt_util_pkg.nvl_str (

1111:
1112: l_sel_clause := l_sel_clause ||
1113: 'FROM ( SELECT ' || fnd_global.newline ||
1114: l_view_by_fact_col || fnd_global.newline ||
1115: ',' || opi_dbi_rpt_util_pkg.nvl_str (
1116: p_str => 'c_exceptions',
1117: p_default_val => 0) || ' OPI_MEASURE1,
1118: ' || opi_dbi_rpt_util_pkg.change_str (
1119: p_new_numerator => 'c_exceptions',

Line 1118: ' || opi_dbi_rpt_util_pkg.change_str (

1114: l_view_by_fact_col || fnd_global.newline ||
1115: ',' || opi_dbi_rpt_util_pkg.nvl_str (
1116: p_str => 'c_exceptions',
1117: p_default_val => 0) || ' OPI_MEASURE1,
1118: ' || opi_dbi_rpt_util_pkg.change_str (
1119: p_new_numerator => 'c_exceptions',
1120: p_old_numerator => 'p_exceptions',
1121: p_denominator => 'p_exceptions',
1122: p_measure_name => 'OPI_MEASURE2') || ',

Line 1123: ' || opi_dbi_rpt_util_pkg.percent_str(

1119: p_new_numerator => 'c_exceptions',
1120: p_old_numerator => 'p_exceptions',
1121: p_denominator => 'p_exceptions',
1122: p_measure_name => 'OPI_MEASURE2') || ',
1123: ' || opi_dbi_rpt_util_pkg.percent_str(
1124: p_numerator => 'c_exceptions',
1125: p_denominator => 'c_exceptions_total',
1126: p_measure_name => 'OPI_MEASURE3') || ',
1127: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1127: ' || opi_dbi_rpt_util_pkg.nvl_str (

1123: ' || opi_dbi_rpt_util_pkg.percent_str(
1124: p_numerator => 'c_exceptions',
1125: p_denominator => 'c_exceptions_total',
1126: p_measure_name => 'OPI_MEASURE3') || ',
1127: ' || opi_dbi_rpt_util_pkg.nvl_str (
1128: p_str => 'c_exceptions_total',
1129: p_default_val => 0) || ' OPI_MEASURE4,
1130: ' || opi_dbi_rpt_util_pkg.change_str (
1131: p_new_numerator => 'c_exceptions_total',

Line 1130: ' || opi_dbi_rpt_util_pkg.change_str (

1126: p_measure_name => 'OPI_MEASURE3') || ',
1127: ' || opi_dbi_rpt_util_pkg.nvl_str (
1128: p_str => 'c_exceptions_total',
1129: p_default_val => 0) || ' OPI_MEASURE4,
1130: ' || opi_dbi_rpt_util_pkg.change_str (
1131: p_new_numerator => 'c_exceptions_total',
1132: p_old_numerator => 'p_exceptions_total',
1133: p_denominator => 'p_exceptions_total',
1134: p_measure_name => 'OPI_MEASURE5') || ',

Line 1135: ' || opi_dbi_rpt_util_pkg.percent_str(

1131: p_new_numerator => 'c_exceptions_total',
1132: p_old_numerator => 'p_exceptions_total',
1133: p_denominator => 'p_exceptions_total',
1134: p_measure_name => 'OPI_MEASURE5') || ',
1135: ' || opi_dbi_rpt_util_pkg.percent_str(
1136: p_numerator => 'c_exceptions_total',
1137: p_denominator => 'c_exceptions_total',
1138: p_measure_name => 'OPI_MEASURE6');
1139: RETURN l_sel_clause;