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

Line 75: opi_dbi_rpt_util_pkg.process_parameters (p_param,

71:
72: END LOOP;
73:
74: -- get all the query parameters
75: opi_dbi_rpt_util_pkg.process_parameters (p_param,
76: l_view_by,
77: l_view_by_col,
78: l_comparison_type,
79: l_xtd,

Line 154: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

150:
151: -- Main Outer query
152:
153: -- Column to get view by column name
154: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
155: (p_view_by_dim);
156:
157: -- Quantity columns for
158: get_qty_columns (p_view_by_dim, l_description, l_uom, l_qty1,

Line 163: 'SELECT '|| opi_dbi_rpt_util_pkg.get_viewby_select_clause(p_view_by_dim) ||

159: l_qty2, l_qty3);
160:
161: -- Outer select clause
162: l_sel_clause :=
163: 'SELECT '|| opi_dbi_rpt_util_pkg.get_viewby_select_clause(p_view_by_dim) ||
164: l_view_by_col_name || ' OPI_ATTRIBUTE1,';
165:
166: IF ((p_view_by_dim = 'RESOURCE+ENI_RESOURCE') AND
167: (upper(p_org) <> 'ALL') AND

Line 177: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',

173:
174: l_sel_clause := l_sel_clause ||
175: l_qty2 || ' OPI_MEASURE1,
176: ' || l_qty1 || ' OPI_MEASURE2,
177: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',
178: 'oset.p_actual_qty',
179: ' OPI_MEASURE3') || ',
180: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',
181: 'oset.c_actual_qty',

Line 180: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',

176: ' || l_qty1 || ' OPI_MEASURE2,
177: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',
178: 'oset.p_actual_qty',
179: ' OPI_MEASURE3') || ',
180: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',
181: 'oset.c_actual_qty',
182: ' OPI_MEASURE4') || ',
183: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',
184: 'oset.c_actual_qty',

Line 183: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',

179: ' OPI_MEASURE3') || ',
180: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',
181: 'oset.c_actual_qty',
182: ' OPI_MEASURE4') || ',
183: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',
184: 'oset.c_actual_qty',
185: '') || ' -
186: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',
187: 'oset.p_actual_qty',

Line 186: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',

182: ' OPI_MEASURE4') || ',
183: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty',
184: 'oset.c_actual_qty',
185: '') || ' -
186: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',
187: 'oset.p_actual_qty',
188: '') || ' OPI_MEASURE5 ,
189: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_std_usage_qty_total')
190: || ' OPI_MEASURE7 ,

Line 189: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_std_usage_qty_total')

185: '') || ' -
186: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty',
187: 'oset.p_actual_qty',
188: '') || ' OPI_MEASURE5 ,
189: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_std_usage_qty_total')
190: || ' OPI_MEASURE7 ,
191: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty_total')
192: || ' OPI_MEASURE8 ,
193: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',

Line 191: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty_total')

187: 'oset.p_actual_qty',
188: '') || ' OPI_MEASURE5 ,
189: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_std_usage_qty_total')
190: || ' OPI_MEASURE7 ,
191: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty_total')
192: || ' OPI_MEASURE8 ,
193: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',
194: 'oset.c_actual_qty_total',
195: ' OPI_MEASURE9') || ',

Line 193: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',

189: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_std_usage_qty_total')
190: || ' OPI_MEASURE7 ,
191: ' || opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty_total')
192: || ' OPI_MEASURE8 ,
193: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',
194: 'oset.c_actual_qty_total',
195: ' OPI_MEASURE9') || ',
196: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',
197: 'oset.c_actual_qty_total',

Line 196: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',

192: || ' OPI_MEASURE8 ,
193: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',
194: 'oset.c_actual_qty_total',
195: ' OPI_MEASURE9') || ',
196: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',
197: 'oset.c_actual_qty_total',
198: '') || ' -
199: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty_total',
200: 'oset.p_actual_qty_total',

Line 199: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty_total',

195: ' OPI_MEASURE9') || ',
196: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.c_std_usage_qty_total',
197: 'oset.c_actual_qty_total',
198: '') || ' -
199: ' || opi_dbi_rpt_util_pkg.percent_str ('oset.p_std_usage_qty_total',
200: 'oset.p_actual_qty_total',
201: '') || ' OPI_MEASURE10 ';
202:
203: RETURN l_sel_clause;

Line 226: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty');

222: /*
223: p_description := 'v.description';
224: p_uom := 'v2.unit_of_measure';
225: */
226: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty');
227: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str
228: ('oset.c_std_usage_qty');
229: p_qty3 := opi_dbi_rpt_util_pkg.percent_str
230: ('oset.c_std_usage_qty',

Line 227: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str

223: p_description := 'v.description';
224: p_uom := 'v2.unit_of_measure';
225: */
226: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty');
227: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str
228: ('oset.c_std_usage_qty');
229: p_qty3 := opi_dbi_rpt_util_pkg.percent_str
230: ('oset.c_std_usage_qty',
231: 'oset.c_actual_qty',

Line 229: p_qty3 := opi_dbi_rpt_util_pkg.percent_str

225: */
226: p_qty1 := opi_dbi_rpt_util_pkg.nvl_str ('oset.c_actual_qty');
227: p_qty2 := opi_dbi_rpt_util_pkg.nvl_str
228: ('oset.c_std_usage_qty');
229: p_qty3 := opi_dbi_rpt_util_pkg.percent_str
230: ('oset.c_std_usage_qty',
231: 'oset.c_actual_qty',
232: '');
233: END;

Line 280: opi_dbi_rpt_util_pkg.process_parameters (p_param,

276: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
277: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
278:
279: -- get all the query parameters
280: opi_dbi_rpt_util_pkg.process_parameters (p_param,
281: l_view_by,
282: l_view_by_col,
283: l_comparison_type,
284: l_xtd,

Line 362: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_qty')

358: l_sel_clause :=
359: 'SELECT
360: ' || ' cal.name VIEWBY,
361: ' || ' cal.name OPI_ATTRIBUTE1,
362: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_qty')
363: || ' OPI_MEASURE1,
364: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_qty')
365: || ' OPI_MEASURE2,
366: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',

Line 364: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_qty')

360: ' || ' cal.name VIEWBY,
361: ' || ' cal.name OPI_ATTRIBUTE1,
362: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_qty')
363: || ' OPI_MEASURE1,
364: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_qty')
365: || ' OPI_MEASURE2,
366: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
367: 'iset.p_actual_qty',
368: 'OPI_MEASURE3') || ',

Line 366: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',

362: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_std_usage_qty')
363: || ' OPI_MEASURE1,
364: ' || opi_dbi_rpt_util_pkg.nvl_str ('iset.c_actual_qty')
365: || ' OPI_MEASURE2,
366: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
367: 'iset.p_actual_qty',
368: 'OPI_MEASURE3') || ',
369: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
370: 'iset.c_actual_qty ',

Line 369: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',

365: || ' OPI_MEASURE2,
366: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
367: 'iset.p_actual_qty',
368: 'OPI_MEASURE3') || ',
369: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
370: 'iset.c_actual_qty ',
371: 'OPI_MEASURE4') || ',
372: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
373: 'iset.c_actual_qty',

Line 372: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',

368: 'OPI_MEASURE3') || ',
369: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
370: 'iset.c_actual_qty ',
371: 'OPI_MEASURE4') || ',
372: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
373: 'iset.c_actual_qty',
374: '') || ' -
375: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
376: 'iset.p_actual_qty',

Line 375: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',

371: 'OPI_MEASURE4') || ',
372: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.c_std_usage_qty',
373: 'iset.c_actual_qty',
374: '') || ' -
375: ' || opi_dbi_rpt_util_pkg.percent_str ('iset.p_std_usage_qty',
376: 'iset.p_actual_qty',
377: '') || ' OPI_MEASURE5 ';
378:
379: RETURN l_sel_clause;