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_CC_RPT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 76: opi_dbi_rpt_util_pkg.process_parameters (

72: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
73: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
74:
75: -- get all the query parameters
76: opi_dbi_rpt_util_pkg.process_parameters (
77: p_param => p_param,
78: p_view_by => l_view_by,
79: p_view_by_col_name => l_view_by_col,
80: p_comparison_type => l_comparison_type,

Line 191: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

187: l_drill_across_rep_1 := 'OPI_DBI_CC_HM_TBL_REP' ;
188: l_drill_across_rep_2 := 'OPI_DBI_CC_ADJ_TBL_REP' ;
189:
190: -- Column to get view by column name
191: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
192: (p_view_by_dim);
193:
194: -- Item Description for item view by
195: get_cc_item_columns (p_view_by_dim, l_description);

Line 198: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

194: -- Item Description for item view by
195: get_cc_item_columns (p_view_by_dim, l_description);
196:
197: -- fact column view by's
198: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
199: (p_join_tbl);
200:
201: l_drill_across := '
202: ''pFunctionName='||l_drill_across_rep_1||'&VIEW_BY_NAME=VIEW_BY_VALUE&VIEW_BY=' || p_view_by_dim || ''' OPI_DYNAMIC_URL_1,

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

205:
206: -- Outer select clause
207: l_sel_clause :=
208: 'SELECT
209: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
210: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
211: ' || l_description || ' OPI_ATTRIBUTE2,
212: ' || 'oset.OPI_MEASURE1,
213: ' || 'oset.OPI_MEASURE3,

Line 283: ' || opi_dbi_rpt_util_pkg.nvl_str (

279: ' || 'OPI_MEASURE34
280: ' || 'FROM
281: ' || '(SELECT
282: ' || l_view_by_fact_col || ',
283: ' || opi_dbi_rpt_util_pkg.nvl_str (
284: p_str => 'c_tot_entries',
285: p_default_val => 0)
286: || ' OPI_MEASURE1,
287: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 287: ' || opi_dbi_rpt_util_pkg.percent_str(

283: ' || opi_dbi_rpt_util_pkg.nvl_str (
284: p_str => 'c_tot_entries',
285: p_default_val => 0)
286: || ' OPI_MEASURE1,
287: ' || opi_dbi_rpt_util_pkg.percent_str(
288: p_numerator => 'p_hits',
289: p_denominator => 'p_tot_entries',
290: p_measure_name => 'OPI_MEASURE3') || ',
291: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 291: ' || opi_dbi_rpt_util_pkg.percent_str (

287: ' || opi_dbi_rpt_util_pkg.percent_str(
288: p_numerator => 'p_hits',
289: p_denominator => 'p_tot_entries',
290: p_measure_name => 'OPI_MEASURE3') || ',
291: ' || opi_dbi_rpt_util_pkg.percent_str (
292: p_numerator => 'c_hits',
293: p_denominator => 'c_tot_entries',
294: p_measure_name => 'OPI_MEASURE4') || ',
295: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 295: ' || opi_dbi_rpt_util_pkg.change_pct_str (

291: ' || opi_dbi_rpt_util_pkg.percent_str (
292: p_numerator => 'c_hits',
293: p_denominator => 'c_tot_entries',
294: p_measure_name => 'OPI_MEASURE4') || ',
295: ' || opi_dbi_rpt_util_pkg.change_pct_str (
296: p_new_numerator => 'c_hits',
297: p_new_denominator => 'c_tot_entries',
298: p_old_numerator => 'p_hits',
299: p_old_denominator => 'p_tot_entries',

Line 301: ' || opi_dbi_rpt_util_pkg.nvl_str (

297: p_new_denominator => 'c_tot_entries',
298: p_old_numerator => 'p_hits',
299: p_old_denominator => 'p_tot_entries',
300: p_measure_name => 'OPI_MEASURE5') || ',
301: ' || opi_dbi_rpt_util_pkg.nvl_str (
302: p_str => 'c_gross_adj_val',
303: p_default_val => 0)
304: || ' OPI_MEASURE7,
305: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 305: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

301: ' || opi_dbi_rpt_util_pkg.nvl_str (
302: p_str => 'c_gross_adj_val',
303: p_default_val => 0)
304: || ' OPI_MEASURE7,
305: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
306: p_numerator => 'p_gross_adj_val',
307: p_denominator => 'p_system_val',
308: p_measure_name => 'OPI_MEASURE8') || ',
309: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 309: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

305: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
306: p_numerator => 'p_gross_adj_val',
307: p_denominator => 'p_system_val',
308: p_measure_name => 'OPI_MEASURE8') || ',
309: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
310: p_numerator => 'c_gross_adj_val',
311: p_denominator => 'c_system_val',
312: p_measure_name => 'OPI_MEASURE9') || ',
313: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 313: ' || opi_dbi_rpt_util_pkg.change_pct_str (

309: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
310: p_numerator => 'c_gross_adj_val',
311: p_denominator => 'c_system_val',
312: p_measure_name => 'OPI_MEASURE9') || ',
313: ' || opi_dbi_rpt_util_pkg.change_pct_str (
314: p_new_numerator => 'c_gross_adj_val',
315: p_new_denominator => 'c_system_val',
316: p_old_numerator => 'p_gross_adj_val',
317: p_old_denominator => 'p_system_val',

Line 319: ' || opi_dbi_rpt_util_pkg.percent_str (

315: p_new_denominator => 'c_system_val',
316: p_old_numerator => 'p_gross_adj_val',
317: p_old_denominator => 'p_system_val',
318: p_measure_name => 'OPI_MEASURE10') || ',
319: ' || opi_dbi_rpt_util_pkg.percent_str (
320: p_numerator => 'p_exact_matches',
321: p_denominator => 'p_tot_entries',
322: p_measure_name => 'OPI_MEASURE12') || ',
323: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 323: ' || opi_dbi_rpt_util_pkg.percent_str (

319: ' || opi_dbi_rpt_util_pkg.percent_str (
320: p_numerator => 'p_exact_matches',
321: p_denominator => 'p_tot_entries',
322: p_measure_name => 'OPI_MEASURE12') || ',
323: ' || opi_dbi_rpt_util_pkg.percent_str (
324: p_numerator => 'c_exact_matches',
325: p_denominator => 'c_tot_entries',
326: p_measure_name => 'OPI_MEASURE13') || ',
327: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 327: ' || opi_dbi_rpt_util_pkg.change_pct_str (

323: ' || opi_dbi_rpt_util_pkg.percent_str (
324: p_numerator => 'c_exact_matches',
325: p_denominator => 'c_tot_entries',
326: p_measure_name => 'OPI_MEASURE13') || ',
327: ' || opi_dbi_rpt_util_pkg.change_pct_str (
328: p_new_numerator => 'c_exact_matches',
329: p_new_denominator => 'c_tot_entries',
330: p_old_numerator => 'p_exact_matches',
331: p_old_denominator => 'p_tot_entries',

Line 333: ' || opi_dbi_rpt_util_pkg.nvl_str (

329: p_new_denominator => 'c_tot_entries',
330: p_old_numerator => 'p_exact_matches',
331: p_old_denominator => 'p_tot_entries',
332: p_measure_name => 'OPI_MEASURE14') || ',
333: ' || opi_dbi_rpt_util_pkg.nvl_str (
334: p_str => 'c_tot_entries_total',
335: p_default_val => 0)
336: || ' OPI_MEASURE15,
337: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 337: ' || opi_dbi_rpt_util_pkg.percent_str (

333: ' || opi_dbi_rpt_util_pkg.nvl_str (
334: p_str => 'c_tot_entries_total',
335: p_default_val => 0)
336: || ' OPI_MEASURE15,
337: ' || opi_dbi_rpt_util_pkg.percent_str (
338: p_numerator =>'c_hits_total',
339: p_denominator =>'c_tot_entries_total',
340: p_measure_name => 'OPI_MEASURE16') || ',
341: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 341: ' || opi_dbi_rpt_util_pkg.change_pct_str (

337: ' || opi_dbi_rpt_util_pkg.percent_str (
338: p_numerator =>'c_hits_total',
339: p_denominator =>'c_tot_entries_total',
340: p_measure_name => 'OPI_MEASURE16') || ',
341: ' || opi_dbi_rpt_util_pkg.change_pct_str (
342: p_new_numerator => 'c_hits_total',
343: p_new_denominator => 'c_tot_entries_total',
344: p_old_numerator => 'p_hits_total',
345: p_old_denominator => 'p_tot_entries_total',

Line 347: ' || opi_dbi_rpt_util_pkg.nvl_str (

343: p_new_denominator => 'c_tot_entries_total',
344: p_old_numerator => 'p_hits_total',
345: p_old_denominator => 'p_tot_entries_total',
346: p_measure_name => 'OPI_MEASURE17') || ',
347: ' || opi_dbi_rpt_util_pkg.nvl_str (
348: p_str => 'c_gross_adj_val_total',
349: p_default_val => 0)
350: || ' OPI_MEASURE18,
351: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 351: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

347: ' || opi_dbi_rpt_util_pkg.nvl_str (
348: p_str => 'c_gross_adj_val_total',
349: p_default_val => 0)
350: || ' OPI_MEASURE18,
351: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
352: p_numerator =>'c_gross_adj_val_total',
353: p_denominator =>'c_system_val_total',
354: p_measure_name => 'OPI_MEASURE19') || ',
355: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 355: ' || opi_dbi_rpt_util_pkg.change_pct_str (

351: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
352: p_numerator =>'c_gross_adj_val_total',
353: p_denominator =>'c_system_val_total',
354: p_measure_name => 'OPI_MEASURE19') || ',
355: ' || opi_dbi_rpt_util_pkg.change_pct_str (
356: p_new_numerator => 'c_gross_adj_val_total',
357: p_new_denominator => 'c_system_val_total',
358: p_old_numerator => 'p_gross_adj_val_total',
359: p_old_denominator => 'p_system_val_total',

Line 361: ' || opi_dbi_rpt_util_pkg.percent_str (

357: p_new_denominator => 'c_system_val_total',
358: p_old_numerator => 'p_gross_adj_val_total',
359: p_old_denominator => 'p_system_val_total',
360: p_measure_name => 'OPI_MEASURE20') || ',
361: ' || opi_dbi_rpt_util_pkg.percent_str (
362: p_numerator =>'c_exact_matches_total',
363: p_denominator => 'c_tot_entries_total',
364: p_measure_name => 'OPI_MEASURE21') || ',
365: ' || opi_dbi_rpt_util_pkg.change_pct_str(

Line 365: ' || opi_dbi_rpt_util_pkg.change_pct_str(

361: ' || opi_dbi_rpt_util_pkg.percent_str (
362: p_numerator =>'c_exact_matches_total',
363: p_denominator => 'c_tot_entries_total',
364: p_measure_name => 'OPI_MEASURE21') || ',
365: ' || opi_dbi_rpt_util_pkg.change_pct_str(
366: p_new_numerator => 'c_exact_matches_total',
367: p_new_denominator => 'c_tot_entries_total',
368: p_old_numerator => 'p_exact_matches_total',
369: p_old_denominator => 'p_tot_entries_total',

Line 371: ' || opi_dbi_rpt_util_pkg.percent_str (

367: p_new_denominator => 'c_tot_entries_total',
368: p_old_numerator => 'p_exact_matches_total',
369: p_old_denominator => 'p_tot_entries_total',
370: p_measure_name => 'OPI_MEASURE22') ||',
371: ' || opi_dbi_rpt_util_pkg.percent_str (
372: p_numerator =>'c_hits',
373: p_denominator => 'c_tot_entries',
374: p_measure_name => 'OPI_MEASURE23') || ',
375: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 375: ' || opi_dbi_rpt_util_pkg.percent_str (

371: ' || opi_dbi_rpt_util_pkg.percent_str (
372: p_numerator =>'c_hits',
373: p_denominator => 'c_tot_entries',
374: p_measure_name => 'OPI_MEASURE23') || ',
375: ' || opi_dbi_rpt_util_pkg.percent_str (
376: p_numerator =>'p_hits',
377: p_denominator => 'p_tot_entries',
378: p_measure_name => 'OPI_MEASURE24') || ',
379: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 379: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

375: ' || opi_dbi_rpt_util_pkg.percent_str (
376: p_numerator =>'p_hits',
377: p_denominator => 'p_tot_entries',
378: p_measure_name => 'OPI_MEASURE24') || ',
379: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
380: p_numerator =>'c_gross_adj_val',
381: p_denominator => 'c_system_val',
382: p_measure_name => 'OPI_MEASURE25') || ',
383: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 383: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

379: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
380: p_numerator =>'c_gross_adj_val',
381: p_denominator => 'c_system_val',
382: p_measure_name => 'OPI_MEASURE25') || ',
383: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
384: p_numerator =>'p_gross_adj_val',
385: p_denominator => 'p_system_val',
386: p_measure_name => 'OPI_MEASURE26') || ',
387: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 387: ' || opi_dbi_rpt_util_pkg.percent_str (

383: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
384: p_numerator =>'p_gross_adj_val',
385: p_denominator => 'p_system_val',
386: p_measure_name => 'OPI_MEASURE26') || ',
387: ' || opi_dbi_rpt_util_pkg.percent_str (
388: p_numerator =>'c_exact_matches',
389: p_denominator => 'c_tot_entries',
390: p_measure_name => 'OPI_MEASURE27') || ',
391: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 391: ' || opi_dbi_rpt_util_pkg.percent_str (

387: ' || opi_dbi_rpt_util_pkg.percent_str (
388: p_numerator =>'c_exact_matches',
389: p_denominator => 'c_tot_entries',
390: p_measure_name => 'OPI_MEASURE27') || ',
391: ' || opi_dbi_rpt_util_pkg.percent_str (
392: p_numerator =>'p_exact_matches',
393: p_denominator => 'p_tot_entries',
394: p_measure_name => 'OPI_MEASURE28') || ',
395: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 395: ' || opi_dbi_rpt_util_pkg.percent_str (

391: ' || opi_dbi_rpt_util_pkg.percent_str (
392: p_numerator =>'p_exact_matches',
393: p_denominator => 'p_tot_entries',
394: p_measure_name => 'OPI_MEASURE28') || ',
395: ' || opi_dbi_rpt_util_pkg.percent_str (
396: p_numerator =>'c_hits_total',
397: p_denominator => 'c_tot_entries_total',
398: p_measure_name => 'OPI_MEASURE29') || ',
399: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 399: ' || opi_dbi_rpt_util_pkg.percent_str (

395: ' || opi_dbi_rpt_util_pkg.percent_str (
396: p_numerator =>'c_hits_total',
397: p_denominator => 'c_tot_entries_total',
398: p_measure_name => 'OPI_MEASURE29') || ',
399: ' || opi_dbi_rpt_util_pkg.percent_str (
400: p_numerator =>'p_hits_total',
401: p_denominator => 'p_tot_entries_total',
402: p_measure_name => 'OPI_MEASURE30') || ',
403: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 403: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

399: ' || opi_dbi_rpt_util_pkg.percent_str (
400: p_numerator =>'p_hits_total',
401: p_denominator => 'p_tot_entries_total',
402: p_measure_name => 'OPI_MEASURE30') || ',
403: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
404: p_numerator =>'c_gross_adj_val_total',
405: p_denominator => 'c_system_val_total',
406: p_measure_name => 'OPI_MEASURE31') || ',
407: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 407: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

403: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
404: p_numerator =>'c_gross_adj_val_total',
405: p_denominator => 'c_system_val_total',
406: p_measure_name => 'OPI_MEASURE31') || ',
407: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
408: p_numerator =>'p_gross_adj_val_total',
409: p_denominator => 'p_system_val_total',
410: p_measure_name => 'OPI_MEASURE32') || ',
411: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 411: ' || opi_dbi_rpt_util_pkg.percent_str (

407: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
408: p_numerator =>'p_gross_adj_val_total',
409: p_denominator => 'p_system_val_total',
410: p_measure_name => 'OPI_MEASURE32') || ',
411: ' || opi_dbi_rpt_util_pkg.percent_str (
412: p_numerator =>'c_exact_matches_total',
413: p_denominator => 'c_tot_entries_total',
414: p_measure_name => 'OPI_MEASURE33') || ',
415: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 415: ' || opi_dbi_rpt_util_pkg.percent_str (

411: ' || opi_dbi_rpt_util_pkg.percent_str (
412: p_numerator =>'c_exact_matches_total',
413: p_denominator => 'c_tot_entries_total',
414: p_measure_name => 'OPI_MEASURE33') || ',
415: ' || opi_dbi_rpt_util_pkg.percent_str (
416: p_numerator =>'p_exact_matches_total',
417: p_denominator => 'p_tot_entries_total',
418: p_measure_name => 'OPI_MEASURE34') ;
419:

Line 500: opi_dbi_rpt_util_pkg.process_parameters (

496: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
497: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
498:
499: -- get all the query parameters
500: opi_dbi_rpt_util_pkg.process_parameters (
501: p_param => p_param,
502: p_view_by => l_view_by,
503: p_view_by_col_name => l_view_by_col,
504: p_comparison_type => l_comparison_type,

Line 608: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'iset.c_tot_entries')

604:
605: l_sel_clause :=
606: 'SELECT
607: ' || ' cal.name VIEWBY,
608: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'iset.c_tot_entries')
609: || ' OPI_MEASURE1,
610: ' || opi_dbi_rpt_util_pkg.percent_str (
611: p_numerator =>'iset.p_hits',
612: p_denominator => 'iset.p_tot_entries',

Line 610: ' || opi_dbi_rpt_util_pkg.percent_str (

606: 'SELECT
607: ' || ' cal.name VIEWBY,
608: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'iset.c_tot_entries')
609: || ' OPI_MEASURE1,
610: ' || opi_dbi_rpt_util_pkg.percent_str (
611: p_numerator =>'iset.p_hits',
612: p_denominator => 'iset.p_tot_entries',
613: p_measure_name => 'OPI_MEASURE3') || ',
614: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 614: ' || opi_dbi_rpt_util_pkg.percent_str (

610: ' || opi_dbi_rpt_util_pkg.percent_str (
611: p_numerator =>'iset.p_hits',
612: p_denominator => 'iset.p_tot_entries',
613: p_measure_name => 'OPI_MEASURE3') || ',
614: ' || opi_dbi_rpt_util_pkg.percent_str (
615: p_numerator =>'iset.c_hits',
616: p_denominator => 'iset.c_tot_entries',
617: p_measure_name => 'OPI_MEASURE4') || ',
618: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 618: ' || opi_dbi_rpt_util_pkg.change_pct_str (

614: ' || opi_dbi_rpt_util_pkg.percent_str (
615: p_numerator =>'iset.c_hits',
616: p_denominator => 'iset.c_tot_entries',
617: p_measure_name => 'OPI_MEASURE4') || ',
618: ' || opi_dbi_rpt_util_pkg.change_pct_str (
619: p_new_numerator => 'iset.c_hits',
620: p_new_denominator => 'iset.c_tot_entries',
621: p_old_numerator => 'iset.p_hits',
622: p_old_denominator => 'iset.p_tot_entries',

Line 624: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'iset.c_gross_adj_val')

620: p_new_denominator => 'iset.c_tot_entries',
621: p_old_numerator => 'iset.p_hits',
622: p_old_denominator => 'iset.p_tot_entries',
623: p_measure_name => 'OPI_MEASURE5') || ',
624: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'iset.c_gross_adj_val')
625: || ' OPI_MEASURE7,
626: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
627: p_numerator =>'iset.p_gross_adj_val',
628: p_denominator => 'iset.p_system_val',

Line 626: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

622: p_old_denominator => 'iset.p_tot_entries',
623: p_measure_name => 'OPI_MEASURE5') || ',
624: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'iset.c_gross_adj_val')
625: || ' OPI_MEASURE7,
626: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
627: p_numerator =>'iset.p_gross_adj_val',
628: p_denominator => 'iset.p_system_val',
629: p_measure_name => 'OPI_MEASURE8') || ',
630: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 630: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

626: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
627: p_numerator =>'iset.p_gross_adj_val',
628: p_denominator => 'iset.p_system_val',
629: p_measure_name => 'OPI_MEASURE8') || ',
630: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
631: p_numerator =>'iset.c_gross_adj_val',
632: p_denominator => 'iset.c_system_val',
633: p_measure_name => 'OPI_MEASURE9') || ',
634: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 634: ' || opi_dbi_rpt_util_pkg.change_pct_str (

630: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
631: p_numerator =>'iset.c_gross_adj_val',
632: p_denominator => 'iset.c_system_val',
633: p_measure_name => 'OPI_MEASURE9') || ',
634: ' || opi_dbi_rpt_util_pkg.change_pct_str (
635: p_new_numerator => 'iset.c_gross_adj_val',
636: p_new_denominator => 'iset.c_system_val',
637: p_old_numerator => 'iset.p_gross_adj_val',
638: p_old_denominator => 'iset.p_system_val',

Line 640: ' || opi_dbi_rpt_util_pkg.percent_str (

636: p_new_denominator => 'iset.c_system_val',
637: p_old_numerator => 'iset.p_gross_adj_val',
638: p_old_denominator => 'iset.p_system_val',
639: p_measure_name => 'OPI_MEASURE10') || ',
640: ' || opi_dbi_rpt_util_pkg.percent_str (
641: p_numerator =>'iset.p_exact_matches',
642: p_denominator => 'iset.p_tot_entries',
643: p_measure_name => 'OPI_MEASURE12') || ',
644: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 644: ' || opi_dbi_rpt_util_pkg.percent_str (

640: ' || opi_dbi_rpt_util_pkg.percent_str (
641: p_numerator =>'iset.p_exact_matches',
642: p_denominator => 'iset.p_tot_entries',
643: p_measure_name => 'OPI_MEASURE12') || ',
644: ' || opi_dbi_rpt_util_pkg.percent_str (
645: p_numerator =>'iset.c_exact_matches',
646: p_denominator => 'iset.c_tot_entries',
647: p_measure_name => 'OPI_MEASURE13') || ',
648: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 648: ' || opi_dbi_rpt_util_pkg.change_pct_str (

644: ' || opi_dbi_rpt_util_pkg.percent_str (
645: p_numerator =>'iset.c_exact_matches',
646: p_denominator => 'iset.c_tot_entries',
647: p_measure_name => 'OPI_MEASURE13') || ',
648: ' || opi_dbi_rpt_util_pkg.change_pct_str (
649: p_new_numerator => 'iset.c_exact_matches',
650: p_new_denominator => 'iset.c_tot_entries',
651: p_old_numerator => 'iset.p_exact_matches',
652: p_old_denominator => 'iset.p_tot_entries',

Line 694: opi_dbi_rpt_util_pkg.process_parameters (

690: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
691:
692:
693: -- get all the query parameters
694: opi_dbi_rpt_util_pkg.process_parameters (
695: p_param => p_param,
696: p_view_by => l_view_by,
697: p_view_by_col_name => l_view_by_col,
698: p_comparison_type => l_comparison_type,

Line 798: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

794:
795: BEGIN
796:
797: -- Column to get view by column name
798: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
799: (p_view_by_dim);
800:
801:
802: -- Description for item view by

Line 806: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

802: -- Description for item view by
803: get_cc_item_columns (p_view_by_dim, l_description);
804:
805: -- fact column view by's
806: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
807: (p_join_tbl);
808:
809: -- Outer select clause
810: l_sel_clause :=

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

808:
809: -- Outer select clause
810: l_sel_clause :=
811: 'SELECT
812: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
813: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
814: ' || l_description || ' OPI_ATTRIBUTE2,
815: ' || 'oset.OPI_MEASURE1,
816: ' || 'oset.OPI_MEASURE3,

Line 869: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'c_tot_entries')

865: ' || 'OPI_MEASURE26
866: ' || 'FROM
867: ' || '(SELECT
868: ' || l_view_by_fact_col || ',
869: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'c_tot_entries')
870: || ' OPI_MEASURE1,
871: ' || opi_dbi_rpt_util_pkg.nvl_str (
872: p_str => 'c_hits')
873: || ' OPI_MEASURE3,

Line 871: ' || opi_dbi_rpt_util_pkg.nvl_str (

867: ' || '(SELECT
868: ' || l_view_by_fact_col || ',
869: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'c_tot_entries')
870: || ' OPI_MEASURE1,
871: ' || opi_dbi_rpt_util_pkg.nvl_str (
872: p_str => 'c_hits')
873: || ' OPI_MEASURE3,
874: ' || opi_dbi_rpt_util_pkg.percent_str (
875: p_numerator =>'p_hits',

Line 874: ' || opi_dbi_rpt_util_pkg.percent_str (

870: || ' OPI_MEASURE1,
871: ' || opi_dbi_rpt_util_pkg.nvl_str (
872: p_str => 'c_hits')
873: || ' OPI_MEASURE3,
874: ' || opi_dbi_rpt_util_pkg.percent_str (
875: p_numerator =>'p_hits',
876: p_denominator => 'p_tot_entries',
877: p_measure_name => 'OPI_MEASURE4') || ',
878: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 878: ' || opi_dbi_rpt_util_pkg.percent_str (

874: ' || opi_dbi_rpt_util_pkg.percent_str (
875: p_numerator =>'p_hits',
876: p_denominator => 'p_tot_entries',
877: p_measure_name => 'OPI_MEASURE4') || ',
878: ' || opi_dbi_rpt_util_pkg.percent_str (
879: p_numerator =>'c_hits',
880: p_denominator => 'c_tot_entries',
881: p_measure_name => 'OPI_MEASURE5') || ',
882: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 882: ' || opi_dbi_rpt_util_pkg.change_pct_str (

878: ' || opi_dbi_rpt_util_pkg.percent_str (
879: p_numerator =>'c_hits',
880: p_denominator => 'c_tot_entries',
881: p_measure_name => 'OPI_MEASURE5') || ',
882: ' || opi_dbi_rpt_util_pkg.change_pct_str (
883: p_new_numerator => 'c_hits',
884: p_new_denominator => 'c_tot_entries',
885: p_old_numerator => 'p_hits',
886: p_old_denominator => 'p_tot_entries',

Line 888: ' || opi_dbi_rpt_util_pkg.nvl_str (

884: p_new_denominator => 'c_tot_entries',
885: p_old_numerator => 'p_hits',
886: p_old_denominator => 'p_tot_entries',
887: p_measure_name => 'OPI_MEASURE6') || ',
888: ' || opi_dbi_rpt_util_pkg.nvl_str (
889: p_str => 'c_misses')
890: || ' OPI_MEASURE8,
891: ' || opi_dbi_rpt_util_pkg.percent_str (
892: p_numerator =>'p_misses',

Line 891: ' || opi_dbi_rpt_util_pkg.percent_str (

887: p_measure_name => 'OPI_MEASURE6') || ',
888: ' || opi_dbi_rpt_util_pkg.nvl_str (
889: p_str => 'c_misses')
890: || ' OPI_MEASURE8,
891: ' || opi_dbi_rpt_util_pkg.percent_str (
892: p_numerator =>'p_misses',
893: p_denominator => 'p_tot_entries',
894: p_measure_name => 'OPI_MEASURE9') || ',
895: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 895: ' || opi_dbi_rpt_util_pkg.percent_str (

891: ' || opi_dbi_rpt_util_pkg.percent_str (
892: p_numerator =>'p_misses',
893: p_denominator => 'p_tot_entries',
894: p_measure_name => 'OPI_MEASURE9') || ',
895: ' || opi_dbi_rpt_util_pkg.percent_str (
896: p_numerator =>'c_misses',
897: p_denominator => 'c_tot_entries',
898: p_measure_name => 'OPI_MEASURE10') || ',
899: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 899: ' || opi_dbi_rpt_util_pkg.change_pct_str (

895: ' || opi_dbi_rpt_util_pkg.percent_str (
896: p_numerator =>'c_misses',
897: p_denominator => 'c_tot_entries',
898: p_measure_name => 'OPI_MEASURE10') || ',
899: ' || opi_dbi_rpt_util_pkg.change_pct_str (
900: p_new_numerator => 'c_misses',
901: p_new_denominator => 'c_tot_entries',
902: p_old_numerator => 'p_misses',
903: p_old_denominator => 'p_tot_entries',

Line 905: ' || opi_dbi_rpt_util_pkg.nvl_str (

901: p_new_denominator => 'c_tot_entries',
902: p_old_numerator => 'p_misses',
903: p_old_denominator => 'p_tot_entries',
904: p_measure_name => 'OPI_MEASURE11') || ',
905: ' || opi_dbi_rpt_util_pkg.nvl_str (
906: p_str => 'c_exact_matches')
907: || ' OPI_MEASURE13,
908: ' || opi_dbi_rpt_util_pkg.percent_str (
909: p_numerator =>'p_exact_matches',

Line 908: ' || opi_dbi_rpt_util_pkg.percent_str (

904: p_measure_name => 'OPI_MEASURE11') || ',
905: ' || opi_dbi_rpt_util_pkg.nvl_str (
906: p_str => 'c_exact_matches')
907: || ' OPI_MEASURE13,
908: ' || opi_dbi_rpt_util_pkg.percent_str (
909: p_numerator =>'p_exact_matches',
910: p_denominator => 'p_tot_entries',
911: p_measure_name => 'OPI_MEASURE14') || ',
912: ' || opi_dbi_rpt_util_pkg.percent_str (

Line 912: ' || opi_dbi_rpt_util_pkg.percent_str (

908: ' || opi_dbi_rpt_util_pkg.percent_str (
909: p_numerator =>'p_exact_matches',
910: p_denominator => 'p_tot_entries',
911: p_measure_name => 'OPI_MEASURE14') || ',
912: ' || opi_dbi_rpt_util_pkg.percent_str (
913: p_numerator =>'c_exact_matches',
914: p_denominator => 'c_tot_entries',
915: p_measure_name => 'OPI_MEASURE15') || ',
916: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 916: ' || opi_dbi_rpt_util_pkg.change_pct_str (

912: ' || opi_dbi_rpt_util_pkg.percent_str (
913: p_numerator =>'c_exact_matches',
914: p_denominator => 'c_tot_entries',
915: p_measure_name => 'OPI_MEASURE15') || ',
916: ' || opi_dbi_rpt_util_pkg.change_pct_str (
917: p_new_numerator => 'c_exact_matches',
918: p_new_denominator => 'c_tot_entries',
919: p_old_numerator => 'p_exact_matches',
920: p_old_denominator => 'p_tot_entries',

Line 922: ' || opi_dbi_rpt_util_pkg.nvl_str (

918: p_new_denominator => 'c_tot_entries',
919: p_old_numerator => 'p_exact_matches',
920: p_old_denominator => 'p_tot_entries',
921: p_measure_name => 'OPI_MEASURE16') || ',
922: ' || opi_dbi_rpt_util_pkg.nvl_str (
923: p_str => 'c_tot_entries_total')
924: || ' OPI_MEASURE17,
925: ' || opi_dbi_rpt_util_pkg.nvl_str (
926: p_str => 'c_hits_total')

Line 925: ' || opi_dbi_rpt_util_pkg.nvl_str (

921: p_measure_name => 'OPI_MEASURE16') || ',
922: ' || opi_dbi_rpt_util_pkg.nvl_str (
923: p_str => 'c_tot_entries_total')
924: || ' OPI_MEASURE17,
925: ' || opi_dbi_rpt_util_pkg.nvl_str (
926: p_str => 'c_hits_total')
927: || ' OPI_MEASURE18,
928: ' || opi_dbi_rpt_util_pkg.percent_str (
929: p_numerator =>'c_hits_total',

Line 928: ' || opi_dbi_rpt_util_pkg.percent_str (

924: || ' OPI_MEASURE17,
925: ' || opi_dbi_rpt_util_pkg.nvl_str (
926: p_str => 'c_hits_total')
927: || ' OPI_MEASURE18,
928: ' || opi_dbi_rpt_util_pkg.percent_str (
929: p_numerator =>'c_hits_total',
930: p_denominator => 'c_tot_entries_total',
931: p_measure_name => 'OPI_MEASURE19') || ',
932: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 932: ' || opi_dbi_rpt_util_pkg.change_pct_str (

928: ' || opi_dbi_rpt_util_pkg.percent_str (
929: p_numerator =>'c_hits_total',
930: p_denominator => 'c_tot_entries_total',
931: p_measure_name => 'OPI_MEASURE19') || ',
932: ' || opi_dbi_rpt_util_pkg.change_pct_str (
933: p_new_numerator => 'c_hits_total',
934: p_new_denominator => 'c_tot_entries_total',
935: p_old_numerator => 'p_hits_total',
936: p_old_denominator => 'p_tot_entries_total',

Line 938: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'c_misses_total')

934: p_new_denominator => 'c_tot_entries_total',
935: p_old_numerator => 'p_hits_total',
936: p_old_denominator => 'p_tot_entries_total',
937: p_measure_name => 'OPI_MEASURE20') || ',
938: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'c_misses_total')
939: || ' OPI_MEASURE21,
940: ' || opi_dbi_rpt_util_pkg.percent_str (
941: p_numerator =>'c_misses_total',
942: p_denominator => 'c_tot_entries_total',

Line 940: ' || opi_dbi_rpt_util_pkg.percent_str (

936: p_old_denominator => 'p_tot_entries_total',
937: p_measure_name => 'OPI_MEASURE20') || ',
938: ' || opi_dbi_rpt_util_pkg.nvl_str (p_str => 'c_misses_total')
939: || ' OPI_MEASURE21,
940: ' || opi_dbi_rpt_util_pkg.percent_str (
941: p_numerator =>'c_misses_total',
942: p_denominator => 'c_tot_entries_total',
943: p_measure_name => 'OPI_MEASURE22') || ',
944: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 944: ' || opi_dbi_rpt_util_pkg.change_pct_str (

940: ' || opi_dbi_rpt_util_pkg.percent_str (
941: p_numerator =>'c_misses_total',
942: p_denominator => 'c_tot_entries_total',
943: p_measure_name => 'OPI_MEASURE22') || ',
944: ' || opi_dbi_rpt_util_pkg.change_pct_str (
945: p_new_numerator => 'c_misses_total',
946: p_new_denominator => 'c_tot_entries_total',
947: p_old_numerator => 'p_misses_total',
948: p_old_denominator => 'p_tot_entries_total',

Line 950: ' || opi_dbi_rpt_util_pkg.nvl_str (

946: p_new_denominator => 'c_tot_entries_total',
947: p_old_numerator => 'p_misses_total',
948: p_old_denominator => 'p_tot_entries_total',
949: p_measure_name => 'OPI_MEASURE23') || ',
950: ' || opi_dbi_rpt_util_pkg.nvl_str (
951: p_str => 'c_exact_matches_total')
952: || ' OPI_MEASURE24,
953: ' || opi_dbi_rpt_util_pkg.percent_str (
954: p_numerator =>'c_exact_matches_total',

Line 953: ' || opi_dbi_rpt_util_pkg.percent_str (

949: p_measure_name => 'OPI_MEASURE23') || ',
950: ' || opi_dbi_rpt_util_pkg.nvl_str (
951: p_str => 'c_exact_matches_total')
952: || ' OPI_MEASURE24,
953: ' || opi_dbi_rpt_util_pkg.percent_str (
954: p_numerator =>'c_exact_matches_total',
955: p_denominator => 'c_tot_entries_total',
956: p_measure_name => 'OPI_MEASURE25') || ',
957: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 957: ' || opi_dbi_rpt_util_pkg.change_pct_str (

953: ' || opi_dbi_rpt_util_pkg.percent_str (
954: p_numerator =>'c_exact_matches_total',
955: p_denominator => 'c_tot_entries_total',
956: p_measure_name => 'OPI_MEASURE25') || ',
957: ' || opi_dbi_rpt_util_pkg.change_pct_str (
958: p_new_numerator => 'c_exact_matches_total',
959: p_new_denominator => 'c_tot_entries_total',
960: p_old_numerator => 'p_exact_matches_total',
961: p_old_denominator => 'p_tot_entries_total',

Line 1006: opi_dbi_rpt_util_pkg.process_parameters (

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

Line 1134: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

1130: l_view_by_fact_col VARCHAR2(400);
1131: BEGIN
1132:
1133: -- Column to get view by column name
1134: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
1135: (p_view_by_dim);
1136:
1137: -- Item Description for item view by
1138: get_cc_item_columns (p_view_by_dim, l_item, 'ITEM');

Line 1142: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

1138: get_cc_item_columns (p_view_by_dim, l_item, 'ITEM');
1139: get_cc_item_columns (p_view_by_dim, l_uom, 'UOM');
1140:
1141: -- fact column view by's
1142: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
1143: (p_join_tbl);
1144:
1145: -- Outer select clause
1146: l_sel_clause :=

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

1144:
1145: -- Outer select clause
1146: l_sel_clause :=
1147: 'SELECT
1148: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
1149: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
1150: ' || l_item || ' OPI_ATTRIBUTE2,
1151: ' || l_uom || ' OPI_ATTRIBUTE3,
1152: ' || 'oset.OPI_MEASURE2,

Line 1206: ' || opi_dbi_rpt_util_pkg.nvl_str (

1202: ' || 'OPI_MEASURE27
1203: ' || 'FROM
1204: ' || '(SELECT
1205: ' || l_view_by_fact_col || ',
1206: ' || opi_dbi_rpt_util_pkg.nvl_str (
1207: p_str => 'c_tot_entries',
1208: p_default_val => 0)
1209: || ' OPI_MEASURE2,
1210: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1210: ' || opi_dbi_rpt_util_pkg.nvl_str (

1206: ' || opi_dbi_rpt_util_pkg.nvl_str (
1207: p_str => 'c_tot_entries',
1208: p_default_val => 0)
1209: || ' OPI_MEASURE2,
1210: ' || opi_dbi_rpt_util_pkg.nvl_str (
1211: p_str => 'c_adjustments',
1212: p_default_val => 0)
1213: || ' OPI_MEASURE3,
1214: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1214: ' || opi_dbi_rpt_util_pkg.nvl_str (

1210: ' || opi_dbi_rpt_util_pkg.nvl_str (
1211: p_str => 'c_adjustments',
1212: p_default_val => 0)
1213: || ' OPI_MEASURE3,
1214: ' || opi_dbi_rpt_util_pkg.nvl_str (
1215: p_str => 'c_system_qty',
1216: p_default_val => 0)
1217: || ' OPI_MEASURE5,
1218: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1218: ' || opi_dbi_rpt_util_pkg.nvl_str (

1214: ' || opi_dbi_rpt_util_pkg.nvl_str (
1215: p_str => 'c_system_qty',
1216: p_default_val => 0)
1217: || ' OPI_MEASURE5,
1218: ' || opi_dbi_rpt_util_pkg.nvl_str (
1219: p_str => 'c_system_val',
1220: p_default_val => 0)
1221: || ' OPI_MEASURE6,
1222: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1222: ' || opi_dbi_rpt_util_pkg.nvl_str (

1218: ' || opi_dbi_rpt_util_pkg.nvl_str (
1219: p_str => 'c_system_val',
1220: p_default_val => 0)
1221: || ' OPI_MEASURE6,
1222: ' || opi_dbi_rpt_util_pkg.nvl_str (
1223: p_str => 'c_gross_adj_qty',
1224: p_default_val => 0)
1225: || ' OPI_MEASURE8,
1226: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1226: ' || opi_dbi_rpt_util_pkg.nvl_str (

1222: ' || opi_dbi_rpt_util_pkg.nvl_str (
1223: p_str => 'c_gross_adj_qty',
1224: p_default_val => 0)
1225: || ' OPI_MEASURE8,
1226: ' || opi_dbi_rpt_util_pkg.nvl_str (
1227: p_str => 'c_gross_adj_val',
1228: p_default_val => 0)
1229: || ' OPI_MEASURE9,
1230: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 1230: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

1226: ' || opi_dbi_rpt_util_pkg.nvl_str (
1227: p_str => 'c_gross_adj_val',
1228: p_default_val => 0)
1229: || ' OPI_MEASURE9,
1230: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1231: p_numerator => 'p_gross_adj_val',
1232: p_denominator => 'p_system_val',
1233: p_measure_name => 'OPI_MEASURE10') || ',
1234: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 1234: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

1230: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1231: p_numerator => 'p_gross_adj_val',
1232: p_denominator => 'p_system_val',
1233: p_measure_name => 'OPI_MEASURE10') || ',
1234: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1235: p_numerator => 'c_gross_adj_val',
1236: p_denominator => 'c_system_val',
1237: p_measure_name => 'OPI_MEASURE11') || ',
1238: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 1238: ' || opi_dbi_rpt_util_pkg.change_pct_str (

1234: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1235: p_numerator => 'c_gross_adj_val',
1236: p_denominator => 'c_system_val',
1237: p_measure_name => 'OPI_MEASURE11') || ',
1238: ' || opi_dbi_rpt_util_pkg.change_pct_str (
1239: p_new_numerator => 'c_gross_adj_val',
1240: p_new_denominator => 'c_system_val',
1241: p_old_numerator => 'p_gross_adj_val',
1242: p_old_denominator => 'p_system_val',

Line 1244: ' || opi_dbi_rpt_util_pkg.nvl_str (

1240: p_new_denominator => 'c_system_val',
1241: p_old_numerator => 'p_gross_adj_val',
1242: p_old_denominator => 'p_system_val',
1243: p_measure_name => 'OPI_MEASURE12') || ',
1244: ' || opi_dbi_rpt_util_pkg.nvl_str (
1245: p_str => 'c_net_adj_qty',
1246: p_default_val => 0)
1247: || ' OPI_MEASURE14,
1248: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1248: ' || opi_dbi_rpt_util_pkg.nvl_str (

1244: ' || opi_dbi_rpt_util_pkg.nvl_str (
1245: p_str => 'c_net_adj_qty',
1246: p_default_val => 0)
1247: || ' OPI_MEASURE14,
1248: ' || opi_dbi_rpt_util_pkg.nvl_str (
1249: p_str => 'c_net_adj_val',
1250: p_default_val => 0)
1251: || ' OPI_MEASURE15,
1252: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 1252: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

1248: ' || opi_dbi_rpt_util_pkg.nvl_str (
1249: p_str => 'c_net_adj_val',
1250: p_default_val => 0)
1251: || ' OPI_MEASURE15,
1252: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1253: p_numerator => 'p_net_adj_val',
1254: p_denominator => 'p_system_val',
1255: p_measure_name => 'OPI_MEASURE16') || ',
1256: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 1256: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

1252: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1253: p_numerator => 'p_net_adj_val',
1254: p_denominator => 'p_system_val',
1255: p_measure_name => 'OPI_MEASURE16') || ',
1256: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1257: p_numerator => 'c_net_adj_val',
1258: p_denominator => 'c_system_val',
1259: p_measure_name => 'OPI_MEASURE17') || ',
1260: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 1260: ' || opi_dbi_rpt_util_pkg.change_pct_str (

1256: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1257: p_numerator => 'c_net_adj_val',
1258: p_denominator => 'c_system_val',
1259: p_measure_name => 'OPI_MEASURE17') || ',
1260: ' || opi_dbi_rpt_util_pkg.change_pct_str (
1261: p_new_numerator => 'c_net_adj_val',
1262: p_new_denominator => 'c_system_val',
1263: p_old_numerator => 'p_net_adj_val',
1264: p_old_denominator => 'p_system_val',

Line 1266: ' || opi_dbi_rpt_util_pkg.nvl_str (

1262: p_new_denominator => 'c_system_val',
1263: p_old_numerator => 'p_net_adj_val',
1264: p_old_denominator => 'p_system_val',
1265: p_measure_name => 'OPI_MEASURE18') || ',
1266: ' || opi_dbi_rpt_util_pkg.nvl_str (
1267: p_str => 'c_tot_entries_total',
1268: p_default_val => 0)
1269: || ' OPI_MEASURE19,
1270: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1270: ' || opi_dbi_rpt_util_pkg.nvl_str (

1266: ' || opi_dbi_rpt_util_pkg.nvl_str (
1267: p_str => 'c_tot_entries_total',
1268: p_default_val => 0)
1269: || ' OPI_MEASURE19,
1270: ' || opi_dbi_rpt_util_pkg.nvl_str (
1271: p_str => 'c_adjustments_total',
1272: p_default_val => 0)
1273: || ' OPI_MEASURE20,
1274: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1274: ' || opi_dbi_rpt_util_pkg.nvl_str (

1270: ' || opi_dbi_rpt_util_pkg.nvl_str (
1271: p_str => 'c_adjustments_total',
1272: p_default_val => 0)
1273: || ' OPI_MEASURE20,
1274: ' || opi_dbi_rpt_util_pkg.nvl_str (
1275: p_str => 'c_system_val_total',
1276: p_default_val => 0)
1277: || ' OPI_MEASURE21,
1278: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1278: ' || opi_dbi_rpt_util_pkg.nvl_str (

1274: ' || opi_dbi_rpt_util_pkg.nvl_str (
1275: p_str => 'c_system_val_total',
1276: p_default_val => 0)
1277: || ' OPI_MEASURE21,
1278: ' || opi_dbi_rpt_util_pkg.nvl_str (
1279: p_str => 'c_gross_adj_val_total',
1280: p_default_val => 0)
1281: || ' OPI_MEASURE22,
1282: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 1282: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

1278: ' || opi_dbi_rpt_util_pkg.nvl_str (
1279: p_str => 'c_gross_adj_val_total',
1280: p_default_val => 0)
1281: || ' OPI_MEASURE22,
1282: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1283: p_numerator =>'c_gross_adj_val_total',
1284: p_denominator =>'c_system_val_total',
1285: p_measure_name => 'OPI_MEASURE23') || ',
1286: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 1286: ' || opi_dbi_rpt_util_pkg.change_pct_str (

1282: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1283: p_numerator =>'c_gross_adj_val_total',
1284: p_denominator =>'c_system_val_total',
1285: p_measure_name => 'OPI_MEASURE23') || ',
1286: ' || opi_dbi_rpt_util_pkg.change_pct_str (
1287: p_new_numerator => 'c_gross_adj_val_total',
1288: p_new_denominator => 'c_system_val_total',
1289: p_old_numerator => 'p_gross_adj_val_total',
1290: p_old_denominator => 'p_system_val_total',

Line 1292: ' || opi_dbi_rpt_util_pkg.nvl_str (

1288: p_new_denominator => 'c_system_val_total',
1289: p_old_numerator => 'p_gross_adj_val_total',
1290: p_old_denominator => 'p_system_val_total',
1291: p_measure_name => 'OPI_MEASURE24') || ',
1292: ' || opi_dbi_rpt_util_pkg.nvl_str (
1293: p_str => 'c_net_adj_val_total',
1294: p_default_val => 0)
1295: || ' OPI_MEASURE25,
1296: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

Line 1296: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (

1292: ' || opi_dbi_rpt_util_pkg.nvl_str (
1293: p_str => 'c_net_adj_val_total',
1294: p_default_val => 0)
1295: || ' OPI_MEASURE25,
1296: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1297: p_numerator =>'c_net_adj_val_total',
1298: p_denominator =>'c_system_val_total',
1299: p_measure_name => 'OPI_MEASURE26') || ',
1300: ' || opi_dbi_rpt_util_pkg.change_pct_str (

Line 1300: ' || opi_dbi_rpt_util_pkg.change_pct_str (

1296: ' || opi_dbi_rpt_util_pkg.pos_denom_percent_str (
1297: p_numerator =>'c_net_adj_val_total',
1298: p_denominator =>'c_system_val_total',
1299: p_measure_name => 'OPI_MEASURE26') || ',
1300: ' || opi_dbi_rpt_util_pkg.change_pct_str (
1301: p_new_numerator => 'c_net_adj_val_total',
1302: p_new_denominator => 'c_system_val_total',
1303: p_old_numerator => 'p_net_adj_val_total',
1304: p_old_denominator => 'p_system_val_total',

Line 1348: opi_dbi_rpt_util_pkg.process_parameters (

1344: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1345: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1346:
1347: -- get all the query parameters
1348: opi_dbi_rpt_util_pkg.process_parameters (
1349: p_param => p_param,
1350: p_view_by => l_view_by,
1351: p_view_by_col_name => l_view_by_col,
1352: p_comparison_type => l_comparison_type,

Line 1484: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

1480:
1481: BEGIN
1482:
1483: -- Column to get view by column name
1484: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
1485: (p_view_by_dim);
1486:
1487: -- Item Description for item view by
1488: get_cc_item_columns (p_view_by_dim, l_item, 'ITEM');

Line 1492: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

1488: get_cc_item_columns (p_view_by_dim, l_item, 'ITEM');
1489: get_cc_item_columns (p_view_by_dim, l_uom, 'UOM');
1490:
1491: -- fact column view by's
1492: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
1493: (p_join_tbl);
1494:
1495: -- Outer select clause
1496: l_sel_clause :=

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

1494:
1495: -- Outer select clause
1496: l_sel_clause :=
1497: 'SELECT
1498: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
1499: || l_view_by_col_name || ' OPI_ATTRIBUTE1,
1500: ' || l_item || ' OPI_ATTRIBUTE2,
1501: ' || l_uom || ' OPI_ATTRIBUTE3,
1502: ' || 'oset.OPI_MEASURE1,

Line 1540: ' || opi_dbi_rpt_util_pkg.nvl_str (

1536: ' || 'OPI_MEASURE19
1537: ' || 'FROM
1538: ' || '(SELECT
1539: ' || l_view_by_fact_col || ',
1540: ' || opi_dbi_rpt_util_pkg.nvl_str (
1541: p_str => 'c_tot_entries',
1542: p_default_val => 0)
1543: || ' OPI_MEASURE1,
1544: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1544: ' || opi_dbi_rpt_util_pkg.nvl_str (

1540: ' || opi_dbi_rpt_util_pkg.nvl_str (
1541: p_str => 'c_tot_entries',
1542: p_default_val => 0)
1543: || ' OPI_MEASURE1,
1544: ' || opi_dbi_rpt_util_pkg.nvl_str (
1545: p_str => 'c_system_qty',
1546: p_default_val => 0)
1547: || ' OPI_MEASURE3,
1548: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1548: ' || opi_dbi_rpt_util_pkg.nvl_str (

1544: ' || opi_dbi_rpt_util_pkg.nvl_str (
1545: p_str => 'c_system_qty',
1546: p_default_val => 0)
1547: || ' OPI_MEASURE3,
1548: ' || opi_dbi_rpt_util_pkg.nvl_str (
1549: p_str => 'c_system_val',
1550: p_default_val => 0)
1551: || ' OPI_MEASURE4,
1552: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1552: ' || opi_dbi_rpt_util_pkg.nvl_str (

1548: ' || opi_dbi_rpt_util_pkg.nvl_str (
1549: p_str => 'c_system_val',
1550: p_default_val => 0)
1551: || ' OPI_MEASURE4,
1552: ' || opi_dbi_rpt_util_pkg.nvl_str (
1553: p_str => 'c_positive_adj_qty',
1554: p_default_val => 0)
1555: || ' OPI_MEASURE6,
1556: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1556: ' || opi_dbi_rpt_util_pkg.nvl_str (

1552: ' || opi_dbi_rpt_util_pkg.nvl_str (
1553: p_str => 'c_positive_adj_qty',
1554: p_default_val => 0)
1555: || ' OPI_MEASURE6,
1556: ' || opi_dbi_rpt_util_pkg.nvl_str (
1557: p_str => 'c_positive_adj_val',
1558: p_default_val => 0)
1559: || ' OPI_MEASURE7,
1560: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1560: ' || opi_dbi_rpt_util_pkg.nvl_str (

1556: ' || opi_dbi_rpt_util_pkg.nvl_str (
1557: p_str => 'c_positive_adj_val',
1558: p_default_val => 0)
1559: || ' OPI_MEASURE7,
1560: ' || opi_dbi_rpt_util_pkg.nvl_str (
1561: p_str => 'c_negative_adj_qty',
1562: p_default_val => 0)
1563: || ' OPI_MEASURE9,
1564: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1564: ' || opi_dbi_rpt_util_pkg.nvl_str (

1560: ' || opi_dbi_rpt_util_pkg.nvl_str (
1561: p_str => 'c_negative_adj_qty',
1562: p_default_val => 0)
1563: || ' OPI_MEASURE9,
1564: ' || opi_dbi_rpt_util_pkg.nvl_str (
1565: p_str => 'c_negative_adj_val',
1566: p_default_val => 0)
1567: || ' OPI_MEASURE10,
1568: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1568: ' || opi_dbi_rpt_util_pkg.nvl_str (

1564: ' || opi_dbi_rpt_util_pkg.nvl_str (
1565: p_str => 'c_negative_adj_val',
1566: p_default_val => 0)
1567: || ' OPI_MEASURE10,
1568: ' || opi_dbi_rpt_util_pkg.nvl_str (
1569: p_str => 'c_gross_adj_val',
1570: p_default_val => 0)
1571: || ' OPI_MEASURE12,
1572: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1572: ' || opi_dbi_rpt_util_pkg.nvl_str (

1568: ' || opi_dbi_rpt_util_pkg.nvl_str (
1569: p_str => 'c_gross_adj_val',
1570: p_default_val => 0)
1571: || ' OPI_MEASURE12,
1572: ' || opi_dbi_rpt_util_pkg.nvl_str (
1573: p_str => 'c_net_adj_val',
1574: p_default_val => 0)
1575: || ' OPI_MEASURE13,
1576: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1576: ' || opi_dbi_rpt_util_pkg.nvl_str (

1572: ' || opi_dbi_rpt_util_pkg.nvl_str (
1573: p_str => 'c_net_adj_val',
1574: p_default_val => 0)
1575: || ' OPI_MEASURE13,
1576: ' || opi_dbi_rpt_util_pkg.nvl_str (
1577: p_str => 'c_tot_entries_total',
1578: p_default_val => 0)
1579: || ' OPI_MEASURE14,
1580: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1580: ' || opi_dbi_rpt_util_pkg.nvl_str (

1576: ' || opi_dbi_rpt_util_pkg.nvl_str (
1577: p_str => 'c_tot_entries_total',
1578: p_default_val => 0)
1579: || ' OPI_MEASURE14,
1580: ' || opi_dbi_rpt_util_pkg.nvl_str (
1581: p_str => 'c_system_val_total',
1582: p_default_val => 0)
1583: || ' OPI_MEASURE15,
1584: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1584: ' || opi_dbi_rpt_util_pkg.nvl_str (

1580: ' || opi_dbi_rpt_util_pkg.nvl_str (
1581: p_str => 'c_system_val_total',
1582: p_default_val => 0)
1583: || ' OPI_MEASURE15,
1584: ' || opi_dbi_rpt_util_pkg.nvl_str (
1585: p_str => 'c_positive_adj_val_total',
1586: p_default_val => 0)
1587: || ' OPI_MEASURE16,
1588: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1588: ' || opi_dbi_rpt_util_pkg.nvl_str (

1584: ' || opi_dbi_rpt_util_pkg.nvl_str (
1585: p_str => 'c_positive_adj_val_total',
1586: p_default_val => 0)
1587: || ' OPI_MEASURE16,
1588: ' || opi_dbi_rpt_util_pkg.nvl_str (
1589: p_str => 'c_negative_adj_val_total',
1590: p_default_val => 0)
1591: || ' OPI_MEASURE17,
1592: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1592: ' || opi_dbi_rpt_util_pkg.nvl_str (

1588: ' || opi_dbi_rpt_util_pkg.nvl_str (
1589: p_str => 'c_negative_adj_val_total',
1590: p_default_val => 0)
1591: || ' OPI_MEASURE17,
1592: ' || opi_dbi_rpt_util_pkg.nvl_str (
1593: p_str => 'c_gross_adj_val_total',
1594: p_default_val => 0)
1595: || ' OPI_MEASURE18,
1596: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 1596: ' || opi_dbi_rpt_util_pkg.nvl_str (

1592: ' || opi_dbi_rpt_util_pkg.nvl_str (
1593: p_str => 'c_gross_adj_val_total',
1594: p_default_val => 0)
1595: || ' OPI_MEASURE18,
1596: ' || opi_dbi_rpt_util_pkg.nvl_str (
1597: p_str => 'c_net_adj_val_total',
1598: p_default_val => 0)
1599: || ' OPI_MEASURE19';
1600: