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

Line 77: opi_dbi_rpt_util_pkg.process_parameters (

73: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
74:
75:
76: -- get all the query parameters for the RTP MV
77: opi_dbi_rpt_util_pkg.process_parameters (
78: p_param => p_param,
79: p_view_by => l_view_by,
80: p_view_by_col_name => l_view_by_col,
81: p_comparison_type => l_comparison_type,

Line 125: opi_dbi_rpt_util_pkg.process_parameters (

121:
122:
123: -- get all the query parameters for RTX MV and viewbys other than SUB
124: IF l_view_by <> 'ORGANIZATION+ORGANIZATION_SUBINVENTORY' AND l_where_clause2 not like '%fact.subinventory%' THEN
125: opi_dbi_rpt_util_pkg.process_parameters (
126: p_param => p_param,
127: p_view_by => l_view_by,
128: p_view_by_col_name => l_view_by_col,
129: p_comparison_type => l_comparison_type,

Line 267: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

263:
264: -- initialization block
265:
266: -- Column to get view by column name
267: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
268: (p_view_by_dim);
269:
270:
271: -- fact column view by's

Line 272: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

268: (p_view_by_dim);
269:
270:
271: -- fact column view by's
272: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
273: (p_join_tbl);
274:
275: -- Outer select clause
276: l_sel_clause :=

Line 278: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim);

274:
275: -- Outer select clause
276: l_sel_clause :=
277: 'SELECT
278: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim);
279: IF p_view_by_dim = 'ITEM+ENI_ITEM_ORG' THEN
280: l_sel_clause := l_sel_clause || '
281: v.description OPI_ATTRIBUTE2, --Description
282: v2.description OPI_ATTRIBUTE3, --UOM

Line 286: l_inner_qty_rcv_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (

282: v2.description OPI_ATTRIBUTE3, --UOM
283: oset.OPI_MEASURE1 OPI_MEASURE1, -- Quantity Received
284: oset.OPI_MEASURE4 OPI_MEASURE4, -- Quantity Putaway
285: ';
286: l_inner_qty_rcv_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (
287: p_str => 'c_quantity_rcv',
288: p_default_val => 0);
289: l_inner_qty_put_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (
290: p_str => 'c_qty_putaway',

Line 289: l_inner_qty_put_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (

285: ';
286: l_inner_qty_rcv_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (
287: p_str => 'c_quantity_rcv',
288: p_default_val => 0);
289: l_inner_qty_put_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (
290: p_str => 'c_qty_putaway',
291: p_default_val => 0);
292:
293: ELSE

Line 350: ' || opi_dbi_rpt_util_pkg.nvl_str (

346: (SELECT
347: ' || l_view_by_fact_col || ',
348: ' || l_inner_qty_rcv_sel_clause
349: || ' OPI_MEASURE1,
350: ' || opi_dbi_rpt_util_pkg.nvl_str (
351: p_str => 'c_rcv_txns',
352: p_default_val => 0)
353: || ' OPI_MEASURE2,
354: ' || opi_dbi_rpt_util_pkg.change_str (

Line 354: ' || opi_dbi_rpt_util_pkg.change_str (

350: ' || opi_dbi_rpt_util_pkg.nvl_str (
351: p_str => 'c_rcv_txns',
352: p_default_val => 0)
353: || ' OPI_MEASURE2,
354: ' || opi_dbi_rpt_util_pkg.change_str (
355: p_new_numerator => 'c_rcv_txns',
356: p_old_numerator => 'p_rcv_txns',
357: p_denominator => 'p_rcv_txns',
358: p_measure_name => 'OPI_MEASURE3') || ',

Line 361: ' || opi_dbi_rpt_util_pkg.nvl_str (

357: p_denominator => 'p_rcv_txns',
358: p_measure_name => 'OPI_MEASURE3') || ',
359: ' || l_inner_qty_put_sel_clause
360: || ' OPI_MEASURE4,
361: ' || opi_dbi_rpt_util_pkg.nvl_str (
362: p_str => 'c_putaways',
363: p_default_val => 0)
364: || ' OPI_MEASURE5,
365: ' || opi_dbi_rpt_util_pkg.change_str (

Line 365: ' || opi_dbi_rpt_util_pkg.change_str (

361: ' || opi_dbi_rpt_util_pkg.nvl_str (
362: p_str => 'c_putaways',
363: p_default_val => 0)
364: || ' OPI_MEASURE5,
365: ' || opi_dbi_rpt_util_pkg.change_str (
366: p_new_numerator => 'c_putaways',
367: p_old_numerator => 'p_putaways',
368: p_denominator => 'p_putaways',
369: p_measure_name => 'OPI_MEASURE6') || ',

Line 370: ' || opi_dbi_rpt_util_pkg.rate_str (

366: p_new_numerator => 'c_putaways',
367: p_old_numerator => 'p_putaways',
368: p_denominator => 'p_putaways',
369: p_measure_name => 'OPI_MEASURE6') || ',
370: ' || opi_dbi_rpt_util_pkg.rate_str (
371: p_numerator => '24*c_rtp_cyc_time',
372: p_denominator => 'c_putaways',
373: p_rate_type => 'NP')
374: || 'OPI_MEASURE7,

Line 375: ' || (opi_dbi_rpt_util_pkg.rate_str (

371: p_numerator => '24*c_rtp_cyc_time',
372: p_denominator => 'c_putaways',
373: p_rate_type => 'NP')
374: || 'OPI_MEASURE7,
375: ' || (opi_dbi_rpt_util_pkg.rate_str (
376: p_numerator => '24*c_rtp_cyc_time',
377: p_denominator => 'c_putaways',
378: p_rate_type => 'NP')) || '-'
379: || (opi_dbi_rpt_util_pkg.rate_str (

Line 379: || (opi_dbi_rpt_util_pkg.rate_str (

375: ' || (opi_dbi_rpt_util_pkg.rate_str (
376: p_numerator => '24*c_rtp_cyc_time',
377: p_denominator => 'c_putaways',
378: p_rate_type => 'NP')) || '-'
379: || (opi_dbi_rpt_util_pkg.rate_str (
380: p_numerator => '24*p_rtp_cyc_time',
381: p_denominator => 'p_putaways',
382: p_rate_type => 'NP'))
383: || ' OPI_MEASURE8,

Line 384: ' || opi_dbi_rpt_util_pkg.nvl_str (

380: p_numerator => '24*p_rtp_cyc_time',
381: p_denominator => 'p_putaways',
382: p_rate_type => 'NP'))
383: || ' OPI_MEASURE8,
384: ' || opi_dbi_rpt_util_pkg.nvl_str (
385: p_str => 'c_rcv_txns_total',
386: p_default_val => 0)
387: || ' OPI_MEASURE9,
388: ' || opi_dbi_rpt_util_pkg.change_str (

Line 388: ' || opi_dbi_rpt_util_pkg.change_str (

384: ' || opi_dbi_rpt_util_pkg.nvl_str (
385: p_str => 'c_rcv_txns_total',
386: p_default_val => 0)
387: || ' OPI_MEASURE9,
388: ' || opi_dbi_rpt_util_pkg.change_str (
389: p_new_numerator => 'c_rcv_txns_total',
390: p_old_numerator => 'p_rcv_txns_total',
391: p_denominator => 'p_rcv_txns_total',
392: p_measure_name => 'OPI_MEASURE10') || ',

Line 393: ' || opi_dbi_rpt_util_pkg.nvl_str (

389: p_new_numerator => 'c_rcv_txns_total',
390: p_old_numerator => 'p_rcv_txns_total',
391: p_denominator => 'p_rcv_txns_total',
392: p_measure_name => 'OPI_MEASURE10') || ',
393: ' || opi_dbi_rpt_util_pkg.nvl_str (
394: p_str => 'c_putaways_total',
395: p_default_val => 0)
396: || ' OPI_MEASURE11,
397: ' || opi_dbi_rpt_util_pkg.change_str (

Line 397: ' || opi_dbi_rpt_util_pkg.change_str (

393: ' || opi_dbi_rpt_util_pkg.nvl_str (
394: p_str => 'c_putaways_total',
395: p_default_val => 0)
396: || ' OPI_MEASURE11,
397: ' || opi_dbi_rpt_util_pkg.change_str (
398: p_new_numerator => 'c_putaways_total',
399: p_old_numerator => 'p_putaways_total',
400: p_denominator => 'p_putaways_total',
401: p_measure_name => 'OPI_MEASURE12') || ',

Line 402: ' || opi_dbi_rpt_util_pkg.rate_str (

398: p_new_numerator => 'c_putaways_total',
399: p_old_numerator => 'p_putaways_total',
400: p_denominator => 'p_putaways_total',
401: p_measure_name => 'OPI_MEASURE12') || ',
402: ' || opi_dbi_rpt_util_pkg.rate_str (
403: p_numerator => '24*c_rtp_cyc_time_total',
404: p_denominator => 'c_putaways_total',
405: p_rate_type => 'NP')
406: || 'OPI_MEASURE13,

Line 407: ' || (opi_dbi_rpt_util_pkg.rate_str (

403: p_numerator => '24*c_rtp_cyc_time_total',
404: p_denominator => 'c_putaways_total',
405: p_rate_type => 'NP')
406: || 'OPI_MEASURE13,
407: ' || (opi_dbi_rpt_util_pkg.rate_str (
408: p_numerator => '24*c_rtp_cyc_time_total',
409: p_denominator => 'c_putaways_total',
410: p_rate_type => 'NP')) || '-'
411: || (opi_dbi_rpt_util_pkg.rate_str (

Line 411: || (opi_dbi_rpt_util_pkg.rate_str (

407: ' || (opi_dbi_rpt_util_pkg.rate_str (
408: p_numerator => '24*c_rtp_cyc_time_total',
409: p_denominator => 'c_putaways_total',
410: p_rate_type => 'NP')) || '-'
411: || (opi_dbi_rpt_util_pkg.rate_str (
412: p_numerator => '24*p_rtp_cyc_time_total',
413: p_denominator => 'p_putaways_total',
414: p_rate_type => 'NP'))
415: || ' OPI_MEASURE14,

Line 416: ' || opi_dbi_rpt_util_pkg.rate_str (

412: p_numerator => '24*p_rtp_cyc_time_total',
413: p_denominator => 'p_putaways_total',
414: p_rate_type => 'NP'))
415: || ' OPI_MEASURE14,
416: ' || opi_dbi_rpt_util_pkg.rate_str (
417: p_numerator => '24*p_rtp_cyc_time_total',
418: p_denominator => 'p_putaways_total',
419: p_rate_type => 'NP')
420: || 'OPI_MEASURE15,

Line 421: ' || opi_dbi_rpt_util_pkg.nvl_str (

417: p_numerator => '24*p_rtp_cyc_time_total',
418: p_denominator => 'p_putaways_total',
419: p_rate_type => 'NP')
420: || 'OPI_MEASURE15,
421: ' || opi_dbi_rpt_util_pkg.nvl_str (
422: p_str => 'p_rcv_txns',
423: p_default_val => 0)
424: || ' OPI_ATTRIBUTE5,
425: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 425: ' || opi_dbi_rpt_util_pkg.nvl_str (

421: ' || opi_dbi_rpt_util_pkg.nvl_str (
422: p_str => 'p_rcv_txns',
423: p_default_val => 0)
424: || ' OPI_ATTRIBUTE5,
425: ' || opi_dbi_rpt_util_pkg.nvl_str (
426: p_str => 'p_putaways',
427: p_default_val => 0)
428: || ' OPI_ATTRIBUTE7,
429: ' || opi_dbi_rpt_util_pkg.rate_str (

Line 429: ' || opi_dbi_rpt_util_pkg.rate_str (

425: ' || opi_dbi_rpt_util_pkg.nvl_str (
426: p_str => 'p_putaways',
427: p_default_val => 0)
428: || ' OPI_ATTRIBUTE7,
429: ' || opi_dbi_rpt_util_pkg.rate_str (
430: p_numerator => '24*p_rtp_cyc_time',
431: p_denominator => 'p_putaways',
432: p_rate_type => 'NP')
433: || 'OPI_ATTRIBUTE9

Line 505: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

501:
502: -- initialization block
503:
504: -- Column to get view by column name
505: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
506: (p_view_by_dim);
507:
508:
509: -- fact column view by's

Line 510: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

506: (p_view_by_dim);
507:
508:
509: -- fact column view by's
510: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
511: (p_join_tbl);
512:
513: -- Outer select clause
514: l_sel_clause :=

Line 516: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim);

512:
513: -- Outer select clause
514: l_sel_clause :=
515: 'SELECT
516: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim);
517:
518: IF p_view_by_dim = 'ITEM+ENI_ITEM_ORG' THEN
519: l_sel_clause := l_sel_clause || '
520: v.description OPI_ATTRIBUTE2, --Description

Line 526: l_inner_qty_put_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (

522: null OPI_MEASURE1, -- Quantity Received
523: oset.OPI_MEASURE4 OPI_MEASURE4, -- Quantity Putaway
524: ';
525: l_inner_qty_rcv_sel_clause:= ' NULL ';
526: l_inner_qty_put_sel_clause:= opi_dbi_rpt_util_pkg.nvl_str (
527: p_str => 'c_qty_putaway',
528: p_default_val => 0);
529:
530: ELSE

Line 591: ' || opi_dbi_rpt_util_pkg.nvl_str (

587: null OPI_MEASURE2,
588: null OPI_MEASURE3,
589: ' || l_inner_qty_put_sel_clause
590: || ' OPI_MEASURE4,
591: ' || opi_dbi_rpt_util_pkg.nvl_str (
592: p_str => 'c_putaways',
593: p_default_val => 0)
594: || ' OPI_MEASURE5,
595: ' || opi_dbi_rpt_util_pkg.change_str (

Line 595: ' || opi_dbi_rpt_util_pkg.change_str (

591: ' || opi_dbi_rpt_util_pkg.nvl_str (
592: p_str => 'c_putaways',
593: p_default_val => 0)
594: || ' OPI_MEASURE5,
595: ' || opi_dbi_rpt_util_pkg.change_str (
596: p_new_numerator => 'c_putaways',
597: p_old_numerator => 'p_putaways',
598: p_denominator => 'p_putaways',
599: p_measure_name => 'OPI_MEASURE6') || ',

Line 600: ' || opi_dbi_rpt_util_pkg.rate_str (

596: p_new_numerator => 'c_putaways',
597: p_old_numerator => 'p_putaways',
598: p_denominator => 'p_putaways',
599: p_measure_name => 'OPI_MEASURE6') || ',
600: ' || opi_dbi_rpt_util_pkg.rate_str (
601: p_numerator => '24*c_rtp_cyc_time',
602: p_denominator => 'c_putaways',
603: p_rate_type => 'NP')
604: || 'OPI_MEASURE7,

Line 605: ' || (opi_dbi_rpt_util_pkg.rate_str (

601: p_numerator => '24*c_rtp_cyc_time',
602: p_denominator => 'c_putaways',
603: p_rate_type => 'NP')
604: || 'OPI_MEASURE7,
605: ' || (opi_dbi_rpt_util_pkg.rate_str (
606: p_numerator => '24*c_rtp_cyc_time',
607: p_denominator => 'c_putaways',
608: p_rate_type => 'NP')) || '-'
609: || (opi_dbi_rpt_util_pkg.rate_str (

Line 609: || (opi_dbi_rpt_util_pkg.rate_str (

605: ' || (opi_dbi_rpt_util_pkg.rate_str (
606: p_numerator => '24*c_rtp_cyc_time',
607: p_denominator => 'c_putaways',
608: p_rate_type => 'NP')) || '-'
609: || (opi_dbi_rpt_util_pkg.rate_str (
610: p_numerator => '24*p_rtp_cyc_time',
611: p_denominator => 'p_putaways',
612: p_rate_type => 'NP'))
613: || ' OPI_MEASURE8,

Line 616: ' || opi_dbi_rpt_util_pkg.nvl_str (

612: p_rate_type => 'NP'))
613: || ' OPI_MEASURE8,
614: null OPI_MEASURE9,
615: null OPI_MEASURE10,
616: ' || opi_dbi_rpt_util_pkg.nvl_str (
617: p_str => 'c_putaways_total',
618: p_default_val => 0)
619: || ' OPI_MEASURE11,
620: ' || opi_dbi_rpt_util_pkg.change_str (

Line 620: ' || opi_dbi_rpt_util_pkg.change_str (

616: ' || opi_dbi_rpt_util_pkg.nvl_str (
617: p_str => 'c_putaways_total',
618: p_default_val => 0)
619: || ' OPI_MEASURE11,
620: ' || opi_dbi_rpt_util_pkg.change_str (
621: p_new_numerator => 'c_putaways_total',
622: p_old_numerator => 'p_putaways_total',
623: p_denominator => 'p_putaways_total',
624: p_measure_name => 'OPI_MEASURE12') || ',

Line 625: ' || opi_dbi_rpt_util_pkg.rate_str (

621: p_new_numerator => 'c_putaways_total',
622: p_old_numerator => 'p_putaways_total',
623: p_denominator => 'p_putaways_total',
624: p_measure_name => 'OPI_MEASURE12') || ',
625: ' || opi_dbi_rpt_util_pkg.rate_str (
626: p_numerator => '24*c_rtp_cyc_time_total',
627: p_denominator => 'c_putaways_total',
628: p_rate_type => 'NP')
629: || 'OPI_MEASURE13,

Line 630: ' || (opi_dbi_rpt_util_pkg.rate_str (

626: p_numerator => '24*c_rtp_cyc_time_total',
627: p_denominator => 'c_putaways_total',
628: p_rate_type => 'NP')
629: || 'OPI_MEASURE13,
630: ' || (opi_dbi_rpt_util_pkg.rate_str (
631: p_numerator => '24*c_rtp_cyc_time_total',
632: p_denominator => 'c_putaways_total',
633: p_rate_type => 'NP')) || '-'
634: || (opi_dbi_rpt_util_pkg.rate_str (

Line 634: || (opi_dbi_rpt_util_pkg.rate_str (

630: ' || (opi_dbi_rpt_util_pkg.rate_str (
631: p_numerator => '24*c_rtp_cyc_time_total',
632: p_denominator => 'c_putaways_total',
633: p_rate_type => 'NP')) || '-'
634: || (opi_dbi_rpt_util_pkg.rate_str (
635: p_numerator => '24*p_rtp_cyc_time_total',
636: p_denominator => 'p_putaways_total',
637: p_rate_type => 'NP'))
638: || ' OPI_MEASURE14,

Line 639: ' || opi_dbi_rpt_util_pkg.rate_str (

635: p_numerator => '24*p_rtp_cyc_time_total',
636: p_denominator => 'p_putaways_total',
637: p_rate_type => 'NP'))
638: || ' OPI_MEASURE14,
639: ' || opi_dbi_rpt_util_pkg.rate_str (
640: p_numerator => '24*p_rtp_cyc_time_total',
641: p_denominator => 'p_putaways_total',
642: p_rate_type => 'NP')
643: || 'OPI_MEASURE15,

Line 645: ' || opi_dbi_rpt_util_pkg.nvl_str (

641: p_denominator => 'p_putaways_total',
642: p_rate_type => 'NP')
643: || 'OPI_MEASURE15,
644: null OPI_ATTRIBUTE5,
645: ' || opi_dbi_rpt_util_pkg.nvl_str (
646: p_str => 'p_putaways',
647: p_default_val => 0)
648: || ' OPI_ATTRIBUTE7,
649:

Line 650: ' || opi_dbi_rpt_util_pkg.rate_str (

646: p_str => 'p_putaways',
647: p_default_val => 0)
648: || ' OPI_ATTRIBUTE7,
649:
650: ' || opi_dbi_rpt_util_pkg.rate_str (
651: p_numerator => '24*p_rtp_cyc_time',
652: p_denominator => 'p_putaways',
653: p_rate_type => 'NP')
654: || 'OPI_ATTRIBUTE9

Line 713: opi_dbi_rpt_util_pkg.process_parameters (

709:
710: -- get all the query parameters for putaway side
711:
712:
713: opi_dbi_rpt_util_pkg.process_parameters (
714: p_param => p_param,
715: p_view_by => l_view_by,
716: p_view_by_col_name => l_view_by_col,
717: p_comparison_type => l_comparison_type,

Line 750: opi_dbi_rpt_util_pkg.process_parameters (

746:
747: -- get all the query parameters for receiving side
748:
749: IF l_where_clause2 not like '%fact.subinventory%' THEN
750: opi_dbi_rpt_util_pkg.process_parameters (
751: p_param => p_param,
752: p_view_by => l_view_by,
753: p_view_by_col_name => l_view_by_col,
754: p_comparison_type => l_comparison_type,

Line 879: ' || opi_dbi_rpt_util_pkg.nvl_str (

875:
876: l_sel_clause :=
877: 'SELECT
878: ' || ' cal_name VIEWBY,
879: ' || opi_dbi_rpt_util_pkg.nvl_str (
880: p_str => 'p_rcv_txns',
881: p_default_val => 0)
882: || ' OPI_ATTRIBUTE5,
883: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 883: ' || opi_dbi_rpt_util_pkg.nvl_str (

879: ' || opi_dbi_rpt_util_pkg.nvl_str (
880: p_str => 'p_rcv_txns',
881: p_default_val => 0)
882: || ' OPI_ATTRIBUTE5,
883: ' || opi_dbi_rpt_util_pkg.nvl_str (
884: p_str => 'c_rcv_txns',
885: p_default_val => 0)
886: || ' OPI_MEASURE1,
887: ' || opi_dbi_rpt_util_pkg.change_str (

Line 887: ' || opi_dbi_rpt_util_pkg.change_str (

883: ' || opi_dbi_rpt_util_pkg.nvl_str (
884: p_str => 'c_rcv_txns',
885: p_default_val => 0)
886: || ' OPI_MEASURE1,
887: ' || opi_dbi_rpt_util_pkg.change_str (
888: p_new_numerator => 'c_rcv_txns',
889: p_old_numerator => 'p_rcv_txns',
890: p_denominator => 'p_rcv_txns',
891: p_measure_name => 'OPI_MEASURE2') || ',

Line 892: ' || opi_dbi_rpt_util_pkg.nvl_str (

888: p_new_numerator => 'c_rcv_txns',
889: p_old_numerator => 'p_rcv_txns',
890: p_denominator => 'p_rcv_txns',
891: p_measure_name => 'OPI_MEASURE2') || ',
892: ' || opi_dbi_rpt_util_pkg.nvl_str (
893: p_str => 'p_putaways',
894: p_default_val => 0)
895: || ' OPI_ATTRIBUTE6,
896: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 896: ' || opi_dbi_rpt_util_pkg.nvl_str (

892: ' || opi_dbi_rpt_util_pkg.nvl_str (
893: p_str => 'p_putaways',
894: p_default_val => 0)
895: || ' OPI_ATTRIBUTE6,
896: ' || opi_dbi_rpt_util_pkg.nvl_str (
897: p_str => 'c_putaways',
898: p_default_val => 0)
899: || ' OPI_MEASURE3,
900: ' || opi_dbi_rpt_util_pkg.change_str (

Line 900: ' || opi_dbi_rpt_util_pkg.change_str (

896: ' || opi_dbi_rpt_util_pkg.nvl_str (
897: p_str => 'c_putaways',
898: p_default_val => 0)
899: || ' OPI_MEASURE3,
900: ' || opi_dbi_rpt_util_pkg.change_str (
901: p_new_numerator => 'c_putaways',
902: p_old_numerator => 'p_putaways',
903: p_denominator => 'p_putaways',
904: p_measure_name => 'OPI_MEASURE4') || ',

Line 905: ' || opi_dbi_rpt_util_pkg.rate_str (

901: p_new_numerator => 'c_putaways',
902: p_old_numerator => 'p_putaways',
903: p_denominator => 'p_putaways',
904: p_measure_name => 'OPI_MEASURE4') || ',
905: ' || opi_dbi_rpt_util_pkg.rate_str (
906: p_numerator => '24*p_rtp_cyc_time',
907: p_denominator => 'p_putaways',
908: p_rate_type => 'NP')
909: || 'OPI_ATTRIBUTE7,

Line 910: ' || opi_dbi_rpt_util_pkg.rate_str (

906: p_numerator => '24*p_rtp_cyc_time',
907: p_denominator => 'p_putaways',
908: p_rate_type => 'NP')
909: || 'OPI_ATTRIBUTE7,
910: ' || opi_dbi_rpt_util_pkg.rate_str (
911: p_numerator => '24*c_rtp_cyc_time',
912: p_denominator => 'c_putaways',
913: p_rate_type => 'NP')
914: || 'OPI_MEASURE5,

Line 915: ' || (opi_dbi_rpt_util_pkg.rate_str (

911: p_numerator => '24*c_rtp_cyc_time',
912: p_denominator => 'c_putaways',
913: p_rate_type => 'NP')
914: || 'OPI_MEASURE5,
915: ' || (opi_dbi_rpt_util_pkg.rate_str (
916: p_numerator => '24*c_rtp_cyc_time',
917: p_denominator => 'c_putaways',
918: p_rate_type => 'NP')) || '-'
919: || (opi_dbi_rpt_util_pkg.rate_str (

Line 919: || (opi_dbi_rpt_util_pkg.rate_str (

915: ' || (opi_dbi_rpt_util_pkg.rate_str (
916: p_numerator => '24*c_rtp_cyc_time',
917: p_denominator => 'c_putaways',
918: p_rate_type => 'NP')) || '-'
919: || (opi_dbi_rpt_util_pkg.rate_str (
920: p_numerator => '24*p_rtp_cyc_time',
921: p_denominator => 'p_putaways',
922: p_rate_type => 'NP'))
923: || ' OPI_MEASURE6'

Line 953: ' || opi_dbi_rpt_util_pkg.nvl_str (

949: ' || ' cal.name VIEWBY,
950: null OPI_ATTRIBUTE5,
951: null OPI_MEASURE1,
952: null OPI_MEASURE2,
953: ' || opi_dbi_rpt_util_pkg.nvl_str (
954: p_str => 'p_putaways',
955: p_default_val => 0)
956: || ' OPI_ATTRIBUTE6,
957: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 957: ' || opi_dbi_rpt_util_pkg.nvl_str (

953: ' || opi_dbi_rpt_util_pkg.nvl_str (
954: p_str => 'p_putaways',
955: p_default_val => 0)
956: || ' OPI_ATTRIBUTE6,
957: ' || opi_dbi_rpt_util_pkg.nvl_str (
958: p_str => 'c_putaways',
959: p_default_val => 0)
960: || ' OPI_MEASURE3,
961: ' || opi_dbi_rpt_util_pkg.change_str (

Line 961: ' || opi_dbi_rpt_util_pkg.change_str (

957: ' || opi_dbi_rpt_util_pkg.nvl_str (
958: p_str => 'c_putaways',
959: p_default_val => 0)
960: || ' OPI_MEASURE3,
961: ' || opi_dbi_rpt_util_pkg.change_str (
962: p_new_numerator => 'c_putaways',
963: p_old_numerator => 'p_putaways',
964: p_denominator => 'p_putaways',
965: p_measure_name => 'OPI_MEASURE4') || ',

Line 966: ' || opi_dbi_rpt_util_pkg.rate_str (

962: p_new_numerator => 'c_putaways',
963: p_old_numerator => 'p_putaways',
964: p_denominator => 'p_putaways',
965: p_measure_name => 'OPI_MEASURE4') || ',
966: ' || opi_dbi_rpt_util_pkg.rate_str (
967: p_numerator => '24*p_rtp_cyc_time',
968: p_denominator => 'p_putaways',
969: p_rate_type => 'NP')
970: || 'OPI_ATTRIBUTE7,

Line 971: ' || opi_dbi_rpt_util_pkg.rate_str (

967: p_numerator => '24*p_rtp_cyc_time',
968: p_denominator => 'p_putaways',
969: p_rate_type => 'NP')
970: || 'OPI_ATTRIBUTE7,
971: ' || opi_dbi_rpt_util_pkg.rate_str (
972: p_numerator => '24*c_rtp_cyc_time',
973: p_denominator => 'c_putaways',
974: p_rate_type => 'NP')
975: || 'OPI_MEASURE5,

Line 976: ' || (opi_dbi_rpt_util_pkg.rate_str (

972: p_numerator => '24*c_rtp_cyc_time',
973: p_denominator => 'c_putaways',
974: p_rate_type => 'NP')
975: || 'OPI_MEASURE5,
976: ' || (opi_dbi_rpt_util_pkg.rate_str (
977: p_numerator => '24*c_rtp_cyc_time',
978: p_denominator => 'c_putaways',
979: p_rate_type => 'NP')) || '-'
980: || (opi_dbi_rpt_util_pkg.rate_str (

Line 980: || (opi_dbi_rpt_util_pkg.rate_str (

976: ' || (opi_dbi_rpt_util_pkg.rate_str (
977: p_numerator => '24*c_rtp_cyc_time',
978: p_denominator => 'c_putaways',
979: p_rate_type => 'NP')) || '-'
980: || (opi_dbi_rpt_util_pkg.rate_str (
981: p_numerator => '24*p_rtp_cyc_time',
982: p_denominator => 'p_putaways',
983: p_rate_type => 'NP'))
984: || ' OPI_MEASURE6';