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

Line 147: opi_dbi_rpt_util_pkg.process_parameters (

143: l_cur_suffix := NULL;
144: l_filter_clause := NULL;
145:
146: -- Process the parameters using the template package.
147: opi_dbi_rpt_util_pkg.process_parameters (
148: p_param => p_param,
149: p_view_by => l_view_by,
150: p_view_by_col_name => l_view_by_col,
151: p_comparison_type => l_comparison_type,

Line 360: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

356: l_uom := NULL;
357: l_view_by_fact_col := NULL;
358:
359: -- fact column view by's
360: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
361: (p_join_tbl => p_join_tbl);
362:
363: -- Description for item view by
364: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

Line 364: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

360: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
361: (p_join_tbl => p_join_tbl);
362:
363: -- Description for item view by
364: opi_dbi_rpt_util_pkg.get_viewby_item_columns (
365: p_dim_name => p_view_by_dim,
366: p_description => l_description,
367: p_uom => l_uom);
368:

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

368:
369:
370: l_sel_clause :=
371: 'SELECT
372: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
373: || l_description || ' OPI_ATTRIBUTE1,
374: ' || l_uom || ' OPI_ATTRIBUTE2,
375: ' || 'oset.OPI_MEASURE2,
376: ' || 'oset.OPI_MEASURE3,

Line 399: ' || opi_dbi_rpt_util_pkg.raw_str

395: ' || 'OPI_MEASURE10
396: ' || 'FROM
397: ' || '(SELECT
398: ' || l_view_by_fact_col || ',
399: ' || opi_dbi_rpt_util_pkg.raw_str
400: (p_str => 'c_expired_qty')
401: || ' OPI_MEASURE2,
402: ' || opi_dbi_rpt_util_pkg.nvl_str
403: (p_str => 'c_expired_val')

Line 402: ' || opi_dbi_rpt_util_pkg.nvl_str

398: ' || l_view_by_fact_col || ',
399: ' || opi_dbi_rpt_util_pkg.raw_str
400: (p_str => 'c_expired_qty')
401: || ' OPI_MEASURE2,
402: ' || opi_dbi_rpt_util_pkg.nvl_str
403: (p_str => 'c_expired_val')
404: || ' OPI_MEASURE3,
405: ' || opi_dbi_rpt_util_pkg.raw_str
406: (p_str => 'c_onhand_qty')

Line 405: ' || opi_dbi_rpt_util_pkg.raw_str

401: || ' OPI_MEASURE2,
402: ' || opi_dbi_rpt_util_pkg.nvl_str
403: (p_str => 'c_expired_val')
404: || ' OPI_MEASURE3,
405: ' || opi_dbi_rpt_util_pkg.raw_str
406: (p_str => 'c_onhand_qty')
407: || ' OPI_MEASURE5,
408: ' || opi_dbi_rpt_util_pkg.nvl_str
409: (p_str => 'c_onhand_val')

Line 408: ' || opi_dbi_rpt_util_pkg.nvl_str

404: || ' OPI_MEASURE3,
405: ' || opi_dbi_rpt_util_pkg.raw_str
406: (p_str => 'c_onhand_qty')
407: || ' OPI_MEASURE5,
408: ' || opi_dbi_rpt_util_pkg.nvl_str
409: (p_str => 'c_onhand_val')
410: || ' OPI_MEASURE6,
411: ' || opi_dbi_rpt_util_pkg.percent_str
412: (p_numerator => 'c_expired_val',

Line 411: ' || opi_dbi_rpt_util_pkg.percent_str

407: || ' OPI_MEASURE5,
408: ' || opi_dbi_rpt_util_pkg.nvl_str
409: (p_str => 'c_onhand_val')
410: || ' OPI_MEASURE6,
411: ' || opi_dbi_rpt_util_pkg.percent_str
412: (p_numerator => 'c_expired_val',
413: p_denominator => 'c_onhand_val',
414: p_measure_name => 'OPI_MEASURE7') || ',
415: ' || opi_dbi_rpt_util_pkg.nvl_str

Line 415: ' || opi_dbi_rpt_util_pkg.nvl_str

411: ' || opi_dbi_rpt_util_pkg.percent_str
412: (p_numerator => 'c_expired_val',
413: p_denominator => 'c_onhand_val',
414: p_measure_name => 'OPI_MEASURE7') || ',
415: ' || opi_dbi_rpt_util_pkg.nvl_str
416: (p_str => 'c_expired_val_total')
417: || ' OPI_MEASURE8,
418: ' || opi_dbi_rpt_util_pkg.nvl_str
419: (p_str => 'c_onhand_val_total')

Line 418: ' || opi_dbi_rpt_util_pkg.nvl_str

414: p_measure_name => 'OPI_MEASURE7') || ',
415: ' || opi_dbi_rpt_util_pkg.nvl_str
416: (p_str => 'c_expired_val_total')
417: || ' OPI_MEASURE8,
418: ' || opi_dbi_rpt_util_pkg.nvl_str
419: (p_str => 'c_onhand_val_total')
420: || ' OPI_MEASURE9,
421: ' || opi_dbi_rpt_util_pkg.percent_str
422: (p_numerator => 'c_expired_val_total',

Line 421: ' || opi_dbi_rpt_util_pkg.percent_str

417: || ' OPI_MEASURE8,
418: ' || opi_dbi_rpt_util_pkg.nvl_str
419: (p_str => 'c_onhand_val_total')
420: || ' OPI_MEASURE9,
421: ' || opi_dbi_rpt_util_pkg.percent_str
422: (p_numerator => 'c_expired_val_total',
423: p_denominator => 'c_onhand_val_total',
424: p_measure_name => 'OPI_MEASURE10');
425:

Line 529: opi_dbi_rpt_util_pkg.process_parameters (

525: l_per_length := 0;
526:
527: -- Process the parameters using the template package for the onhand
528: -- branch.
529: opi_dbi_rpt_util_pkg.process_parameters (
530: p_param => p_param,
531: p_view_by => l_view_by,
532: p_view_by_col_name => l_view_by_col,
533: p_comparison_type => l_comparison_type,

Line 549: opi_dbi_rpt_util_pkg.process_parameters (

545: p_mv_flag_type => 'INV_VAL_UOM_LEVEL');
546:
547: -- Process the parameters using the template package for the
548: -- production consumption branch.
549: opi_dbi_rpt_util_pkg.process_parameters (
550: p_param => p_param,
551: p_view_by => l_view_by,
552: p_view_by_col_name => l_view_by_col,
553: p_comparison_type => l_comparison_type,

Line 569: opi_dbi_rpt_util_pkg.process_parameters (

565: p_mv_flag_type => 'PROD_CONS_LEVEL');
566:
567: -- Process the parameters using the template package for the
568: -- shipment consumption branch.
569: opi_dbi_rpt_util_pkg.process_parameters (
570: p_param => p_param,
571: p_view_by => l_view_by,
572: p_view_by_col_name => l_view_by_col,
573: p_comparison_type => l_comparison_type,

Line 684: l_query := opi_dbi_rpt_util_pkg.replace_n

680: ' || l_query;
681:
682: -- Make the nested pattern ITD since onhand quantity (and weight/
683: -- volume) are reported as a balance..
684: l_query := opi_dbi_rpt_util_pkg.replace_n
685: (p_orig_str => l_query,
686: p_match_str => '&RLX_NESTED_PATTERN',
687: p_replace_str => C_ROLLING_ITD_PATTERN,
688: p_start_pos => 1,

Line 886: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

882: l_uom := NULL;
883: l_view_by_fact_col := NULL;
884:
885: -- fact column view by's
886: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
887: (p_join_tbl => p_join_tbl);
888:
889: -- Description for item view by
890: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

Line 890: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

886: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
887: (p_join_tbl => p_join_tbl);
888:
889: -- Description for item view by
890: opi_dbi_rpt_util_pkg.get_viewby_item_columns (
891: p_dim_name => p_view_by_dim,
892: p_description => l_description,
893: p_uom => l_uom);
894:

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

893: p_uom => l_uom);
894:
895: l_sel_clause :=
896: 'SELECT /* outer query */
897: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
898: || l_description || ' OPI_ATTRIBUTE1,
899: ' || l_uom || ' OPI_ATTRIBUTE2,
900: ' || 'OPI_MEASURE2,
901: ' || 'OPI_MEASURE3,

Line 975: ' || opi_dbi_rpt_util_pkg.percent_str

971: ' || 'OPI_MEASURE15,
972: ' || 'OPI_MEASURE9,
973: ' || 'OPI_MEASURE16,
974: -- not truly a percentage, so multiply denom by 100
975: ' || opi_dbi_rpt_util_pkg.percent_str
976: (p_numerator => 'OPI_MEASURE3',
977: p_denominator => '(p_cons_daily_avg * 100)',
978: p_measure_name => 'OPI_MEASURE10') || ',
979: -- not truly a percentage, so multiply denom by 100

Line 980: ' || opi_dbi_rpt_util_pkg.percent_str

976: (p_numerator => 'OPI_MEASURE3',
977: p_denominator => '(p_cons_daily_avg * 100)',
978: p_measure_name => 'OPI_MEASURE10') || ',
979: -- not truly a percentage, so multiply denom by 100
980: ' || opi_dbi_rpt_util_pkg.percent_str
981: (p_numerator => 'OPI_MEASURE4',
982: p_denominator => '(OPI_MEASURE9 * 100)',
983: p_measure_name => 'OPI_MEASURE11') || ',
984: -- not truly a percentage, so multiply denom by 100

Line 985: ' || opi_dbi_rpt_util_pkg.percent_str

981: (p_numerator => 'OPI_MEASURE4',
982: p_denominator => '(OPI_MEASURE9 * 100)',
983: p_measure_name => 'OPI_MEASURE11') || ',
984: -- not truly a percentage, so multiply denom by 100
985: ' || opi_dbi_rpt_util_pkg.percent_str
986: (p_numerator => 'OPI_MEASURE12',
987: p_denominator => '(OPI_MEASURE16 * 100)',
988: p_measure_name => 'OPI_MEASURE17') || ',
989: ' || opi_dbi_rpt_util_pkg.change_pct_str

Line 989: ' || opi_dbi_rpt_util_pkg.change_pct_str

985: ' || opi_dbi_rpt_util_pkg.percent_str
986: (p_numerator => 'OPI_MEASURE12',
987: p_denominator => '(OPI_MEASURE16 * 100)',
988: p_measure_name => 'OPI_MEASURE17') || ',
989: ' || opi_dbi_rpt_util_pkg.change_pct_str
990: (p_new_numerator => 'OPI_MEASURE4',
991: p_new_denominator => '(OPI_MEASURE9 * 100)',
992: p_old_numerator => 'OPI_MEASURE3',
993: p_old_denominator => '(p_cons_daily_avg * 100)',

Line 995: ' || opi_dbi_rpt_util_pkg.change_pct_str

991: p_new_denominator => '(OPI_MEASURE9 * 100)',
992: p_old_numerator => 'OPI_MEASURE3',
993: p_old_denominator => '(p_cons_daily_avg * 100)',
994: p_measure_name => 'OPI_MEASURE18') || ',
995: ' || opi_dbi_rpt_util_pkg.change_pct_str
996: (p_new_numerator => 'OPI_MEASURE12',
997: p_new_denominator => '(OPI_MEASURE16 * 100)',
998: p_old_numerator => 'p_onhand_val_total',
999: p_old_denominator => '(p_cons_daily_avg_total * 100)',

Line 1004: ' || opi_dbi_rpt_util_pkg.raw_str

1000: p_measure_name => 'OPI_MEASURE19') || '
1001: ' || 'FROM
1002: ' || '(SELECT /* basic measure computation */
1003: ' || l_view_by_fact_col || ',
1004: ' || opi_dbi_rpt_util_pkg.raw_str
1005: (p_str => 'c_onhand_qty')
1006: || ' OPI_MEASURE2,
1007: ' || opi_dbi_rpt_util_pkg.nvl_str
1008: (p_str => 'p_onhand_val')

Line 1007: ' || opi_dbi_rpt_util_pkg.nvl_str

1003: ' || l_view_by_fact_col || ',
1004: ' || opi_dbi_rpt_util_pkg.raw_str
1005: (p_str => 'c_onhand_qty')
1006: || ' OPI_MEASURE2,
1007: ' || opi_dbi_rpt_util_pkg.nvl_str
1008: (p_str => 'p_onhand_val')
1009: || ' OPI_MEASURE3,
1010: ' || opi_dbi_rpt_util_pkg.nvl_str
1011: (p_str => 'c_onhand_val')

Line 1010: ' || opi_dbi_rpt_util_pkg.nvl_str

1006: || ' OPI_MEASURE2,
1007: ' || opi_dbi_rpt_util_pkg.nvl_str
1008: (p_str => 'p_onhand_val')
1009: || ' OPI_MEASURE3,
1010: ' || opi_dbi_rpt_util_pkg.nvl_str
1011: (p_str => 'c_onhand_val')
1012: || ' OPI_MEASURE4,
1013: ' || opi_dbi_rpt_util_pkg.nvl_str
1014: (p_str => 'c_onhand_val_total')

Line 1013: ' || opi_dbi_rpt_util_pkg.nvl_str

1009: || ' OPI_MEASURE3,
1010: ' || opi_dbi_rpt_util_pkg.nvl_str
1011: (p_str => 'c_onhand_val')
1012: || ' OPI_MEASURE4,
1013: ' || opi_dbi_rpt_util_pkg.nvl_str
1014: (p_str => 'c_onhand_val_total')
1015: || ' OPI_MEASURE12,
1016: ' || opi_dbi_rpt_util_pkg.nvl_str
1017: (p_str => 'c_prod_usage_val')

Line 1016: ' || opi_dbi_rpt_util_pkg.nvl_str

1012: || ' OPI_MEASURE4,
1013: ' || opi_dbi_rpt_util_pkg.nvl_str
1014: (p_str => 'c_onhand_val_total')
1015: || ' OPI_MEASURE12,
1016: ' || opi_dbi_rpt_util_pkg.nvl_str
1017: (p_str => 'c_prod_usage_val')
1018: || ' OPI_MEASURE6,
1019: ' || opi_dbi_rpt_util_pkg.nvl_str
1020: (p_str => 'c_prod_usage_val_total')

Line 1019: ' || opi_dbi_rpt_util_pkg.nvl_str

1015: || ' OPI_MEASURE12,
1016: ' || opi_dbi_rpt_util_pkg.nvl_str
1017: (p_str => 'c_prod_usage_val')
1018: || ' OPI_MEASURE6,
1019: ' || opi_dbi_rpt_util_pkg.nvl_str
1020: (p_str => 'c_prod_usage_val_total')
1021: || ' OPI_MEASURE13,
1022: ' || opi_dbi_rpt_util_pkg.nvl_str
1023: (p_str => 'c_cogs_val')

Line 1022: ' || opi_dbi_rpt_util_pkg.nvl_str

1018: || ' OPI_MEASURE6,
1019: ' || opi_dbi_rpt_util_pkg.nvl_str
1020: (p_str => 'c_prod_usage_val_total')
1021: || ' OPI_MEASURE13,
1022: ' || opi_dbi_rpt_util_pkg.nvl_str
1023: (p_str => 'c_cogs_val')
1024: || ' OPI_MEASURE7,
1025: ' || opi_dbi_rpt_util_pkg.nvl_str
1026: (p_str => 'c_cogs_val_total')

Line 1025: ' || opi_dbi_rpt_util_pkg.nvl_str

1021: || ' OPI_MEASURE13,
1022: ' || opi_dbi_rpt_util_pkg.nvl_str
1023: (p_str => 'c_cogs_val')
1024: || ' OPI_MEASURE7,
1025: ' || opi_dbi_rpt_util_pkg.nvl_str
1026: (p_str => 'c_cogs_val_total')
1027: || ' OPI_MEASURE14,
1028: ' || opi_dbi_rpt_util_pkg.nvl_str
1029: (p_str =>

Line 1028: ' || opi_dbi_rpt_util_pkg.nvl_str

1024: || ' OPI_MEASURE7,
1025: ' || opi_dbi_rpt_util_pkg.nvl_str
1026: (p_str => 'c_cogs_val_total')
1027: || ' OPI_MEASURE14,
1028: ' || opi_dbi_rpt_util_pkg.nvl_str
1029: (p_str =>
1030: opi_dbi_rpt_util_pkg.nvl_str
1031: ('c_prod_usage_val') || ' + ' ||
1032: opi_dbi_rpt_util_pkg.nvl_str

Line 1030: opi_dbi_rpt_util_pkg.nvl_str

1026: (p_str => 'c_cogs_val_total')
1027: || ' OPI_MEASURE14,
1028: ' || opi_dbi_rpt_util_pkg.nvl_str
1029: (p_str =>
1030: opi_dbi_rpt_util_pkg.nvl_str
1031: ('c_prod_usage_val') || ' + ' ||
1032: opi_dbi_rpt_util_pkg.nvl_str
1033: ('c_cogs_val'))
1034: || ' OPI_MEASURE8,

Line 1032: opi_dbi_rpt_util_pkg.nvl_str

1028: ' || opi_dbi_rpt_util_pkg.nvl_str
1029: (p_str =>
1030: opi_dbi_rpt_util_pkg.nvl_str
1031: ('c_prod_usage_val') || ' + ' ||
1032: opi_dbi_rpt_util_pkg.nvl_str
1033: ('c_cogs_val'))
1034: || ' OPI_MEASURE8,
1035: ' || opi_dbi_rpt_util_pkg.nvl_str
1036: (p_str =>

Line 1035: ' || opi_dbi_rpt_util_pkg.nvl_str

1031: ('c_prod_usage_val') || ' + ' ||
1032: opi_dbi_rpt_util_pkg.nvl_str
1033: ('c_cogs_val'))
1034: || ' OPI_MEASURE8,
1035: ' || opi_dbi_rpt_util_pkg.nvl_str
1036: (p_str =>
1037: opi_dbi_rpt_util_pkg.nvl_str
1038: ('c_prod_usage_val_total') || ' + ' ||
1039: opi_dbi_rpt_util_pkg.nvl_str

Line 1037: opi_dbi_rpt_util_pkg.nvl_str

1033: ('c_cogs_val'))
1034: || ' OPI_MEASURE8,
1035: ' || opi_dbi_rpt_util_pkg.nvl_str
1036: (p_str =>
1037: opi_dbi_rpt_util_pkg.nvl_str
1038: ('c_prod_usage_val_total') || ' + ' ||
1039: opi_dbi_rpt_util_pkg.nvl_str
1040: ('c_cogs_val_total'))
1041: || ' OPI_MEASURE15,

Line 1039: opi_dbi_rpt_util_pkg.nvl_str

1035: ' || opi_dbi_rpt_util_pkg.nvl_str
1036: (p_str =>
1037: opi_dbi_rpt_util_pkg.nvl_str
1038: ('c_prod_usage_val_total') || ' + ' ||
1039: opi_dbi_rpt_util_pkg.nvl_str
1040: ('c_cogs_val_total'))
1041: || ' OPI_MEASURE15,
1042: -- not truly a percentage, so multiply denom by 100
1043: ' || opi_dbi_rpt_util_pkg.percent_str_basic

Line 1043: ' || opi_dbi_rpt_util_pkg.percent_str_basic

1039: opi_dbi_rpt_util_pkg.nvl_str
1040: ('c_cogs_val_total'))
1041: || ' OPI_MEASURE15,
1042: -- not truly a percentage, so multiply denom by 100
1043: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1044: (p_numerator =>
1045: opi_dbi_rpt_util_pkg.neg_str (
1046: opi_dbi_rpt_util_pkg.nvl_str
1047: ('c_prod_usage_val') || ' + ' ||

Line 1045: opi_dbi_rpt_util_pkg.neg_str (

1041: || ' OPI_MEASURE15,
1042: -- not truly a percentage, so multiply denom by 100
1043: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1044: (p_numerator =>
1045: opi_dbi_rpt_util_pkg.neg_str (
1046: opi_dbi_rpt_util_pkg.nvl_str
1047: ('c_prod_usage_val') || ' + ' ||
1048: opi_dbi_rpt_util_pkg.nvl_str
1049: ('c_cogs_val')),

Line 1046: opi_dbi_rpt_util_pkg.nvl_str

1042: -- not truly a percentage, so multiply denom by 100
1043: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1044: (p_numerator =>
1045: opi_dbi_rpt_util_pkg.neg_str (
1046: opi_dbi_rpt_util_pkg.nvl_str
1047: ('c_prod_usage_val') || ' + ' ||
1048: opi_dbi_rpt_util_pkg.nvl_str
1049: ('c_cogs_val')),
1050: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),

Line 1048: opi_dbi_rpt_util_pkg.nvl_str

1044: (p_numerator =>
1045: opi_dbi_rpt_util_pkg.neg_str (
1046: opi_dbi_rpt_util_pkg.nvl_str
1047: ('c_prod_usage_val') || ' + ' ||
1048: opi_dbi_rpt_util_pkg.nvl_str
1049: ('c_cogs_val')),
1050: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),
1051: p_measure_name => 'OPI_MEASURE9') || ',
1052: -- not truly a percentage, so multiply denom by 100

Line 1053: ' || opi_dbi_rpt_util_pkg.percent_str_basic

1049: ('c_cogs_val')),
1050: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),
1051: p_measure_name => 'OPI_MEASURE9') || ',
1052: -- not truly a percentage, so multiply denom by 100
1053: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1054: (p_numerator =>
1055: opi_dbi_rpt_util_pkg.neg_str (
1056: opi_dbi_rpt_util_pkg.nvl_str
1057: ('c_prod_usage_val_total') || ' + ' ||

Line 1055: opi_dbi_rpt_util_pkg.neg_str (

1051: p_measure_name => 'OPI_MEASURE9') || ',
1052: -- not truly a percentage, so multiply denom by 100
1053: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1054: (p_numerator =>
1055: opi_dbi_rpt_util_pkg.neg_str (
1056: opi_dbi_rpt_util_pkg.nvl_str
1057: ('c_prod_usage_val_total') || ' + ' ||
1058: opi_dbi_rpt_util_pkg.nvl_str
1059: ('c_cogs_val_total')),

Line 1056: opi_dbi_rpt_util_pkg.nvl_str

1052: -- not truly a percentage, so multiply denom by 100
1053: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1054: (p_numerator =>
1055: opi_dbi_rpt_util_pkg.neg_str (
1056: opi_dbi_rpt_util_pkg.nvl_str
1057: ('c_prod_usage_val_total') || ' + ' ||
1058: opi_dbi_rpt_util_pkg.nvl_str
1059: ('c_cogs_val_total')),
1060: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),

Line 1058: opi_dbi_rpt_util_pkg.nvl_str

1054: (p_numerator =>
1055: opi_dbi_rpt_util_pkg.neg_str (
1056: opi_dbi_rpt_util_pkg.nvl_str
1057: ('c_prod_usage_val_total') || ' + ' ||
1058: opi_dbi_rpt_util_pkg.nvl_str
1059: ('c_cogs_val_total')),
1060: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),
1061: p_measure_name => 'OPI_MEASURE16') || ',
1062: ' || ' null OPI_MEASURE10,

Line 1068: ' || opi_dbi_rpt_util_pkg.nvl_str

1064: ' || ' null OPI_MEASURE17,
1065: ' || ' null OPI_MEASURE18,
1066: ' || ' null OPI_MEASURE19,
1067: ' || ' p_onhand_val_total,
1068: ' || opi_dbi_rpt_util_pkg.nvl_str
1069: (p_str =>
1070: opi_dbi_rpt_util_pkg.nvl_str
1071: ('p_prod_usage_val') || ' + ' ||
1072: opi_dbi_rpt_util_pkg.nvl_str

Line 1070: opi_dbi_rpt_util_pkg.nvl_str

1066: ' || ' null OPI_MEASURE19,
1067: ' || ' p_onhand_val_total,
1068: ' || opi_dbi_rpt_util_pkg.nvl_str
1069: (p_str =>
1070: opi_dbi_rpt_util_pkg.nvl_str
1071: ('p_prod_usage_val') || ' + ' ||
1072: opi_dbi_rpt_util_pkg.nvl_str
1073: ('p_cogs_val'))
1074: || ' p_total_cons_val,

Line 1072: opi_dbi_rpt_util_pkg.nvl_str

1068: ' || opi_dbi_rpt_util_pkg.nvl_str
1069: (p_str =>
1070: opi_dbi_rpt_util_pkg.nvl_str
1071: ('p_prod_usage_val') || ' + ' ||
1072: opi_dbi_rpt_util_pkg.nvl_str
1073: ('p_cogs_val'))
1074: || ' p_total_cons_val,
1075: ' || opi_dbi_rpt_util_pkg.nvl_str
1076: (p_str =>

Line 1075: ' || opi_dbi_rpt_util_pkg.nvl_str

1071: ('p_prod_usage_val') || ' + ' ||
1072: opi_dbi_rpt_util_pkg.nvl_str
1073: ('p_cogs_val'))
1074: || ' p_total_cons_val,
1075: ' || opi_dbi_rpt_util_pkg.nvl_str
1076: (p_str =>
1077: opi_dbi_rpt_util_pkg.nvl_str
1078: ('p_prod_usage_val_total') || ' + ' ||
1079: opi_dbi_rpt_util_pkg.nvl_str

Line 1077: opi_dbi_rpt_util_pkg.nvl_str

1073: ('p_cogs_val'))
1074: || ' p_total_cons_val,
1075: ' || opi_dbi_rpt_util_pkg.nvl_str
1076: (p_str =>
1077: opi_dbi_rpt_util_pkg.nvl_str
1078: ('p_prod_usage_val_total') || ' + ' ||
1079: opi_dbi_rpt_util_pkg.nvl_str
1080: ('p_cogs_val_total'))
1081: || ' p_total_cons_val_total,

Line 1079: opi_dbi_rpt_util_pkg.nvl_str

1075: ' || opi_dbi_rpt_util_pkg.nvl_str
1076: (p_str =>
1077: opi_dbi_rpt_util_pkg.nvl_str
1078: ('p_prod_usage_val_total') || ' + ' ||
1079: opi_dbi_rpt_util_pkg.nvl_str
1080: ('p_cogs_val_total'))
1081: || ' p_total_cons_val_total,
1082: -- not truly a percentage, so multiply denom by 100
1083: ' || opi_dbi_rpt_util_pkg.percent_str_basic

Line 1083: ' || opi_dbi_rpt_util_pkg.percent_str_basic

1079: opi_dbi_rpt_util_pkg.nvl_str
1080: ('p_cogs_val_total'))
1081: || ' p_total_cons_val_total,
1082: -- not truly a percentage, so multiply denom by 100
1083: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1084: (p_numerator =>
1085: opi_dbi_rpt_util_pkg.neg_str (
1086: opi_dbi_rpt_util_pkg.nvl_str
1087: ('p_prod_usage_val') || ' + ' ||

Line 1085: opi_dbi_rpt_util_pkg.neg_str (

1081: || ' p_total_cons_val_total,
1082: -- not truly a percentage, so multiply denom by 100
1083: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1084: (p_numerator =>
1085: opi_dbi_rpt_util_pkg.neg_str (
1086: opi_dbi_rpt_util_pkg.nvl_str
1087: ('p_prod_usage_val') || ' + ' ||
1088: opi_dbi_rpt_util_pkg.nvl_str
1089: ('p_cogs_val')),

Line 1086: opi_dbi_rpt_util_pkg.nvl_str

1082: -- not truly a percentage, so multiply denom by 100
1083: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1084: (p_numerator =>
1085: opi_dbi_rpt_util_pkg.neg_str (
1086: opi_dbi_rpt_util_pkg.nvl_str
1087: ('p_prod_usage_val') || ' + ' ||
1088: opi_dbi_rpt_util_pkg.nvl_str
1089: ('p_cogs_val')),
1090: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),

Line 1088: opi_dbi_rpt_util_pkg.nvl_str

1084: (p_numerator =>
1085: opi_dbi_rpt_util_pkg.neg_str (
1086: opi_dbi_rpt_util_pkg.nvl_str
1087: ('p_prod_usage_val') || ' + ' ||
1088: opi_dbi_rpt_util_pkg.nvl_str
1089: ('p_cogs_val')),
1090: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),
1091: p_measure_name => 'p_cons_daily_avg') || ',
1092: -- not truly a percentage, so multiply denom by 100

Line 1093: ' || opi_dbi_rpt_util_pkg.percent_str_basic

1089: ('p_cogs_val')),
1090: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),
1091: p_measure_name => 'p_cons_daily_avg') || ',
1092: -- not truly a percentage, so multiply denom by 100
1093: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1094: (p_numerator =>
1095: opi_dbi_rpt_util_pkg.neg_str (
1096: opi_dbi_rpt_util_pkg.nvl_str
1097: ('p_prod_usage_val_total') || ' + ' ||

Line 1095: opi_dbi_rpt_util_pkg.neg_str (

1091: p_measure_name => 'p_cons_daily_avg') || ',
1092: -- not truly a percentage, so multiply denom by 100
1093: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1094: (p_numerator =>
1095: opi_dbi_rpt_util_pkg.neg_str (
1096: opi_dbi_rpt_util_pkg.nvl_str
1097: ('p_prod_usage_val_total') || ' + ' ||
1098: opi_dbi_rpt_util_pkg.nvl_str
1099: ('p_cogs_val_total')),

Line 1096: opi_dbi_rpt_util_pkg.nvl_str

1092: -- not truly a percentage, so multiply denom by 100
1093: ' || opi_dbi_rpt_util_pkg.percent_str_basic
1094: (p_numerator =>
1095: opi_dbi_rpt_util_pkg.neg_str (
1096: opi_dbi_rpt_util_pkg.nvl_str
1097: ('p_prod_usage_val_total') || ' + ' ||
1098: opi_dbi_rpt_util_pkg.nvl_str
1099: ('p_cogs_val_total')),
1100: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),

Line 1098: opi_dbi_rpt_util_pkg.nvl_str

1094: (p_numerator =>
1095: opi_dbi_rpt_util_pkg.neg_str (
1096: opi_dbi_rpt_util_pkg.nvl_str
1097: ('p_prod_usage_val_total') || ' + ' ||
1098: opi_dbi_rpt_util_pkg.nvl_str
1099: ('p_cogs_val_total')),
1100: p_denominator => ('(:OPI_INV_DOH_PER_LEN * 100)'),
1101: p_measure_name => 'p_cons_daily_avg_total');
1102:

Line 1196: opi_dbi_rpt_util_pkg.process_parameters (

1192: l_viewby_rank_clause := NULL;
1193:
1194: -- Process the parameters using the template package for the
1195: -- shipment consumption branch.
1196: opi_dbi_rpt_util_pkg.process_parameters (
1197: p_param => p_param,
1198: p_view_by => l_view_by,
1199: p_view_by_col_name => l_view_by_col,
1200: p_comparison_type => l_comparison_type,

Line 1707: opi_dbi_rpt_util_pkg.get_security_where_clauses

1703: -- If only the Viewby is Item grade, must outer join mln
1704: IF (p_param(i).parameter_name = 'ORGANIZATION+ORGANIZATION') THEN
1705: -- {
1706: l_security_where_clause :=
1707: opi_dbi_rpt_util_pkg.get_security_where_clauses
1708: (p_org_value => p_param(i).parameter_value,
1709: p_trend => 'N');
1710: -- }
1711: END IF;

Line 1761: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

1757: l_uom := NULL;
1758: l_view_by_fact_col := NULL;
1759:
1760: -- fact column view by's
1761: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
1762: (p_join_tbl => p_join_tbl);
1763:
1764: -- It is fine to sum primary_qty in the secondary qty measures
1765: -- in the rank clause. Since the report is item specific, the

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

1767: -- and hence the sort order on the primary and secondary quantity
1768: -- is the same.
1769: l_sel_clause :=
1770: 'SELECT /* outer select */
1771: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
1772: || 'v2.unit_of_measure OPI_ATTRIBUTE1,
1773: ' || 'oset.OPI_MEASURE2,
1774: ' || 'oset.OPI_MEASURE5,
1775: ' || 'v3.unit_of_measure OPI_ATTRIBUTE2,

Line 1790: ' || opi_dbi_rpt_util_pkg.raw_str

1786: ' || 'OPI_MEASURE6
1787: ' || 'FROM
1788: ' || '(SELECT /* measure computation */
1789: ' || l_view_by_fact_col || ',
1790: ' || opi_dbi_rpt_util_pkg.raw_str
1791: (p_str => 'c_primary_qty')
1792: || ' OPI_MEASURE2,
1793: ' || opi_dbi_rpt_util_pkg.nvl_str
1794: (p_str => 'c_primary_qty_total')

Line 1793: ' || opi_dbi_rpt_util_pkg.nvl_str

1789: ' || l_view_by_fact_col || ',
1790: ' || opi_dbi_rpt_util_pkg.raw_str
1791: (p_str => 'c_primary_qty')
1792: || ' OPI_MEASURE2,
1793: ' || opi_dbi_rpt_util_pkg.nvl_str
1794: (p_str => 'c_primary_qty_total')
1795: || ' OPI_MEASURE5,
1796: ' || opi_dbi_rpt_util_pkg.raw_str
1797: (p_str => 'c_secondary_qty')

Line 1796: ' || opi_dbi_rpt_util_pkg.raw_str

1792: || ' OPI_MEASURE2,
1793: ' || opi_dbi_rpt_util_pkg.nvl_str
1794: (p_str => 'c_primary_qty_total')
1795: || ' OPI_MEASURE5,
1796: ' || opi_dbi_rpt_util_pkg.raw_str
1797: (p_str => 'c_secondary_qty')
1798: || ' OPI_MEASURE4,
1799: ' || opi_dbi_rpt_util_pkg.nvl_str
1800: (p_str => 'c_secondary_qty_total')

Line 1799: ' || opi_dbi_rpt_util_pkg.nvl_str

1795: || ' OPI_MEASURE5,
1796: ' || opi_dbi_rpt_util_pkg.raw_str
1797: (p_str => 'c_secondary_qty')
1798: || ' OPI_MEASURE4,
1799: ' || opi_dbi_rpt_util_pkg.nvl_str
1800: (p_str => 'c_secondary_qty_total')
1801: || ' OPI_MEASURE6
1802: ' || ' FROM ( /* OLTP select */
1803: ' || ' SELECT