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

Line 80: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

76: l_uom := NULL;
77: l_view_by_fact_col := NULL;
78:
79: -- fact column view by's
80: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
81: (p_join_tbl);
82:
83: -- Description for item view by
84: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

Line 84: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

80: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
81: (p_join_tbl);
82:
83: -- Description for item view by
84: opi_dbi_rpt_util_pkg.get_viewby_item_columns (
85: p_view_by_dim, l_description, l_uom);
86:
87:
88: l_sel_clause :=

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

86:
87:
88: l_sel_clause :=
89: 'SELECT
90: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
91: || l_description || ' OPI_ATTRIBUTE1,
92: ' || l_uom || ' OPI_ATTRIBUTE2,
93: ' || 'oset.OPI_MEASURE1,
94: ' || 'oset.OPI_MEASURE2,

Line 127: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')

123: ' || 'OPI_MEASURE13
124: ' || 'FROM
125: ' || '(SELECT
126: ' || l_view_by_fact_col || ',
127: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')
128: || ' OPI_MEASURE1,
129: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume')
130: || ' OPI_MEASURE2,
131: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')

Line 129: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume')

125: ' || '(SELECT
126: ' || l_view_by_fact_col || ',
127: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')
128: || ' OPI_MEASURE1,
129: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume')
130: || ' OPI_MEASURE2,
131: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
132: || ' OPI_MEASURE3,
133: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',

Line 131: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')

127: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')
128: || ' OPI_MEASURE1,
129: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume')
130: || ' OPI_MEASURE2,
131: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
132: || ' OPI_MEASURE3,
133: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',
134: 'p_utilized_volume',
135: 'p_utilized_volume',

Line 133: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',

129: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume')
130: || ' OPI_MEASURE2,
131: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
132: || ' OPI_MEASURE3,
133: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',
134: 'p_utilized_volume',
135: 'p_utilized_volume',
136: 'OPI_MEASURE4') || ',
137: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored')

Line 137: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored')

133: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',
134: 'p_utilized_volume',
135: 'p_utilized_volume',
136: 'OPI_MEASURE4') || ',
137: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored')
138: || ' OPI_MEASURE5,
139: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored')
140: || ' OPI_MEASURE6,
141: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',

Line 139: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored')

135: 'p_utilized_volume',
136: 'OPI_MEASURE4') || ',
137: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored')
138: || ' OPI_MEASURE5,
139: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored')
140: || ' OPI_MEASURE6,
141: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',
142: 'p_weight_stored',
143: 'p_weight_stored',

Line 141: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',

137: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored')
138: || ' OPI_MEASURE5,
139: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored')
140: || ' OPI_MEASURE6,
141: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',
142: 'p_weight_stored',
143: 'p_weight_stored',
144: 'OPI_MEASURE7') || ',
145: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume_total')

Line 145: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume_total')

141: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',
142: 'p_weight_stored',
143: 'p_weight_stored',
144: 'OPI_MEASURE7') || ',
145: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume_total')
146: || ' OPI_MEASURE8,
147: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
148: || ' OPI_MEASURE9,
149: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume_total',

Line 147: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')

143: 'p_weight_stored',
144: 'OPI_MEASURE7') || ',
145: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume_total')
146: || ' OPI_MEASURE8,
147: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
148: || ' OPI_MEASURE9,
149: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume_total',
150: 'p_utilized_volume_total',
151: 'p_utilized_volume_total',

Line 149: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume_total',

145: ' || opi_dbi_rpt_util_pkg.raw_str ('p_utilized_volume_total')
146: || ' OPI_MEASURE8,
147: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
148: || ' OPI_MEASURE9,
149: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume_total',
150: 'p_utilized_volume_total',
151: 'p_utilized_volume_total',
152: 'OPI_MEASURE10') || ',
153: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored_total')

Line 153: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored_total')

149: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume_total',
150: 'p_utilized_volume_total',
151: 'p_utilized_volume_total',
152: 'OPI_MEASURE10') || ',
153: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored_total')
154: || ' OPI_MEASURE11,
155: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored_total')
156: || ' OPI_MEASURE12,
157: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored_total',

Line 155: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored_total')

151: 'p_utilized_volume_total',
152: 'OPI_MEASURE10') || ',
153: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored_total')
154: || ' OPI_MEASURE11,
155: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored_total')
156: || ' OPI_MEASURE12,
157: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored_total',
158: 'p_weight_stored_total',
159: 'p_weight_stored_total',

Line 157: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored_total',

153: ' || opi_dbi_rpt_util_pkg.raw_str ('p_weight_stored_total')
154: || ' OPI_MEASURE11,
155: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_stored_total')
156: || ' OPI_MEASURE12,
157: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored_total',
158: 'p_weight_stored_total',
159: 'p_weight_stored_total',
160: 'OPI_MEASURE13') ;
161:

Line 332: opi_dbi_rpt_util_pkg.process_parameters (

328: l_cur_suffix := NULL;
329: l_filter_clause := NULL;
330:
331: -- Process the parameters using the template package.
332: opi_dbi_rpt_util_pkg.process_parameters (
333: p_param => p_param,
334: p_view_by => l_view_by,
335: p_view_by_col_name => l_view_by_col,
336: p_comparison_type => l_comparison_type,

Line 454: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_utilized_volume')

450:
451: l_sel_clause :=
452: 'SELECT
453: ' || ' cal.name VIEWBY,
454: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_utilized_volume')
455: || ' OPI_MEASURE1,
456: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_utilized_volume')
457: || ' OPI_MEASURE2,
458: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',

Line 456: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_utilized_volume')

452: 'SELECT
453: ' || ' cal.name VIEWBY,
454: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_utilized_volume')
455: || ' OPI_MEASURE1,
456: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_utilized_volume')
457: || ' OPI_MEASURE2,
458: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',
459: 'p_utilized_volume',
460: 'p_utilized_volume',

Line 458: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',

454: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_utilized_volume')
455: || ' OPI_MEASURE1,
456: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_utilized_volume')
457: || ' OPI_MEASURE2,
458: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',
459: 'p_utilized_volume',
460: 'p_utilized_volume',
461: 'OPI_MEASURE3') || ',
462: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_weight_stored')

Line 462: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_weight_stored')

458: ' || opi_dbi_rpt_util_pkg.change_str ('c_utilized_volume',
459: 'p_utilized_volume',
460: 'p_utilized_volume',
461: 'OPI_MEASURE3') || ',
462: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_weight_stored')
463: || ' OPI_MEASURE4,
464: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_weight_stored')
465: || ' OPI_MEASURE5,
466: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',

Line 464: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_weight_stored')

460: 'p_utilized_volume',
461: 'OPI_MEASURE3') || ',
462: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_weight_stored')
463: || ' OPI_MEASURE4,
464: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_weight_stored')
465: || ' OPI_MEASURE5,
466: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',
467: 'p_weight_stored',
468: 'p_weight_stored',

Line 466: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',

462: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.p_weight_stored')
463: || ' OPI_MEASURE4,
464: ' || opi_dbi_rpt_util_pkg.raw_str ('iset.c_weight_stored')
465: || ' OPI_MEASURE5,
466: ' || opi_dbi_rpt_util_pkg.change_str ('c_weight_stored',
467: 'p_weight_stored',
468: 'p_weight_stored',
469: 'OPI_MEASURE6') ;
470:

Line 544: opi_dbi_rpt_util_pkg.process_parameters (

540: l_aggr_level_flag := NULL;
541: l_cur_suffix := NULL;
542:
543: -- Process the parameters using the template package.
544: opi_dbi_rpt_util_pkg.process_parameters (
545: p_param => p_param,
546: p_view_by => l_view_by,
547: p_view_by_col_name => l_view_by_col,
548: p_comparison_type => l_comparison_type,

Line 664: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

660: -- initialization block
661: l_sel_clause := NULL;
662:
663: -- fact column view by's
664: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
665: (p_join_tbl);
666:
667: -- Description for item view by
668: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

Line 668: opi_dbi_rpt_util_pkg.get_viewby_item_columns (

664: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
665: (p_join_tbl);
666:
667: -- Description for item view by
668: opi_dbi_rpt_util_pkg.get_viewby_item_columns (
669: p_view_by_dim, l_description, l_uom);
670:
671:
672: -- Denominators for the volume/weight utilization.

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

686: END IF;
687:
688: l_sel_clause :=
689: 'SELECT
690: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
691: || l_description || ' OPI_ATTRIBUTE1,
692: ' || l_uom || ' OPI_ATTRIBUTE2,
693: ' || 'oset.OPI_MEASURE1,
694: ' || 'oset.OPI_MEASURE2,

Line 727: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')

723: ' || 'OPI_MEASURE13
724: ' || 'FROM
725: ' || '(SELECT
726: ' || l_view_by_fact_col || ',
727: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')
728: || ' OPI_MEASURE1,
729: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
730: || ' OPI_MEASURE2,
731: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity')

Line 729: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')

725: ' || '(SELECT
726: ' || l_view_by_fact_col || ',
727: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')
728: || ' OPI_MEASURE1,
729: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
730: || ' OPI_MEASURE2,
731: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity')
732: || ' OPI_MEASURE3,
733: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_utilized_volume',

Line 731: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity')

727: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_qty')
728: || ' OPI_MEASURE1,
729: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
730: || ' OPI_MEASURE2,
731: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity')
732: || ' OPI_MEASURE3,
733: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_utilized_volume',
734: l_vol_utz_denom,
735: 'OPI_MEASURE4') || ',

Line 733: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_utilized_volume',

729: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume')
730: || ' OPI_MEASURE2,
731: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity')
732: || ' OPI_MEASURE3,
733: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_utilized_volume',
734: l_vol_utz_denom,
735: 'OPI_MEASURE4') || ',
736: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight')
737: || ' OPI_MEASURE5,

Line 736: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight')

732: || ' OPI_MEASURE3,
733: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_utilized_volume',
734: l_vol_utz_denom,
735: 'OPI_MEASURE4') || ',
736: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight')
737: || ' OPI_MEASURE5,
738: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity')
739: || ' OPI_MEASURE6,
740: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_stored_weight',

Line 738: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity')

734: l_vol_utz_denom,
735: 'OPI_MEASURE4') || ',
736: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight')
737: || ' OPI_MEASURE5,
738: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity')
739: || ' OPI_MEASURE6,
740: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_stored_weight',
741: l_wt_utz_denom,
742: 'OPI_MEASURE7') || ',

Line 740: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_stored_weight',

736: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight')
737: || ' OPI_MEASURE5,
738: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity')
739: || ' OPI_MEASURE6,
740: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_stored_weight',
741: l_wt_utz_denom,
742: 'OPI_MEASURE7') || ',
743: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
744: || ' OPI_MEASURE8,

Line 743: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')

739: || ' OPI_MEASURE6,
740: ' || opi_dbi_rpt_util_pkg.percent_str_basic ('c_stored_weight',
741: l_wt_utz_denom,
742: 'OPI_MEASURE7') || ',
743: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
744: || ' OPI_MEASURE8,
745: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity_total')
746: || ' OPI_MEASURE9,
747: ' || opi_dbi_rpt_util_pkg.percent_str_basic

Line 745: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity_total')

741: l_wt_utz_denom,
742: 'OPI_MEASURE7') || ',
743: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
744: || ' OPI_MEASURE8,
745: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity_total')
746: || ' OPI_MEASURE9,
747: ' || opi_dbi_rpt_util_pkg.percent_str_basic
748: ('c_utilized_volume_total',
749: 'c_volume_capacity_total',

Line 747: ' || opi_dbi_rpt_util_pkg.percent_str_basic

743: ' || opi_dbi_rpt_util_pkg.raw_str ('c_utilized_volume_total')
744: || ' OPI_MEASURE8,
745: ' || opi_dbi_rpt_util_pkg.raw_str ('c_volume_capacity_total')
746: || ' OPI_MEASURE9,
747: ' || opi_dbi_rpt_util_pkg.percent_str_basic
748: ('c_utilized_volume_total',
749: 'c_volume_capacity_total',
750: 'OPI_MEASURE10') || ',
751: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight_total')

Line 751: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight_total')

747: ' || opi_dbi_rpt_util_pkg.percent_str_basic
748: ('c_utilized_volume_total',
749: 'c_volume_capacity_total',
750: 'OPI_MEASURE10') || ',
751: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight_total')
752: || ' OPI_MEASURE11,
753: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity_total')
754: || ' OPI_MEASURE12,
755: ' || opi_dbi_rpt_util_pkg.percent_str_basic

Line 753: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity_total')

749: 'c_volume_capacity_total',
750: 'OPI_MEASURE10') || ',
751: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight_total')
752: || ' OPI_MEASURE11,
753: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity_total')
754: || ' OPI_MEASURE12,
755: ' || opi_dbi_rpt_util_pkg.percent_str_basic
756: ('c_stored_weight_total',
757: 'c_weight_capacity_total',

Line 755: ' || opi_dbi_rpt_util_pkg.percent_str_basic

751: ' || opi_dbi_rpt_util_pkg.raw_str ('c_stored_weight_total')
752: || ' OPI_MEASURE11,
753: ' || opi_dbi_rpt_util_pkg.raw_str ('c_weight_capacity_total')
754: || ' OPI_MEASURE12,
755: ' || opi_dbi_rpt_util_pkg.percent_str_basic
756: ('c_stored_weight_total',
757: 'c_weight_capacity_total',
758: 'OPI_MEASURE13') ;
759:

Line 1015: opi_dbi_rpt_util_pkg.process_parameters (

1011: l_comparison_type := NULL;
1012:
1013: -- Get all the report query parameters for the item
1014: -- side of the query.
1015: opi_dbi_rpt_util_pkg.process_parameters (
1016: p_param => p_param,
1017: p_view_by => l_view_by,
1018: p_view_by_col_name => l_view_by_col,
1019: p_comparison_type => l_comparison_type,

Line 1062: opi_dbi_rpt_util_pkg.process_parameters (

1058:
1059:
1060: -- Get all the report query parameters for the subinventory
1061: -- side of the query.
1062: opi_dbi_rpt_util_pkg.process_parameters (
1063: p_param => p_param,
1064: p_view_by => l_view_by,
1065: p_view_by_col_name => l_view_by_col,
1066: p_comparison_type => l_comparison_type,

Line 1114: IF (l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_ORG OR

1110: -- for the viewby Org and Sub, as opposed to the view by Item and Cat.
1111: -- The viewby Org/Sub report is a basic union all report with no
1112: -- calendar. The viewby Cat/Item contains only grand totals for the
1113: -- capacity. There are no other possible viewby's.
1114: IF (l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_ORG OR
1115: l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_SUB) THEN
1116: -- Need a query of form:
1117: /*
1118: select sum (....)

Line 1115: l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_SUB) THEN

1111: -- The viewby Org/Sub report is a basic union all report with no
1112: -- calendar. The viewby Cat/Item contains only grand totals for the
1113: -- capacity. There are no other possible viewby's.
1114: IF (l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_ORG OR
1115: l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_SUB) THEN
1116: -- Need a query of form:
1117: /*
1118: select sum (....)
1119: ...

Line 1256: ELSIF (l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_ITEM OR

1252: ' || ' ) ) ) oset,
1253: ' || l_viewby_rank_clause;
1254:
1255:
1256: ELSIF (l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_ITEM OR
1257: l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_INV_CAT) THEN
1258: -- Need a query of form:
1259: /*
1260: select sum (....)

Line 1257: l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_INV_CAT) THEN

1253: ' || l_viewby_rank_clause;
1254:
1255:
1256: ELSIF (l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_ITEM OR
1257: l_view_by = opi_dbi_rpt_util_pkg.C_VIEWBY_INV_CAT) THEN
1258: -- Need a query of form:
1259: /*
1260: select sum (....)
1261: ...