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

Line 48: opi_dbi_rpt_util_pkg.process_parameters (

44: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
45: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
46:
47: -- get all the query parameters
48: opi_dbi_rpt_util_pkg.process_parameters (
49: p_param => p_param,
50: p_view_by => l_view_by,
51: p_view_by_col_name => l_view_by_col,
52: p_comparison_type => l_comparison_type,

Line 166: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name

162: l_uom VARCHAR2(30);
163: l_view_by_fact_col VARCHAR2(400);
164: BEGIN
165: l_description := 'null';
166: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
167: (p_view_by_dim);
168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
169: (p_join_tbl);
170:

Line 168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns

164: BEGIN
165: l_description := 'null';
166: l_view_by_col_name := opi_dbi_rpt_util_pkg.get_view_by_col_name
167: (p_view_by_dim);
168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
169: (p_join_tbl);
170:
171:
172: opi_dbi_rpt_util_pkg.get_viewby_item_columns (p_view_by_dim, l_description, l_uom);

Line 172: opi_dbi_rpt_util_pkg.get_viewby_item_columns (p_view_by_dim, l_description, l_uom);

168: l_view_by_fact_col := opi_dbi_rpt_util_pkg.get_fact_select_columns
169: (p_join_tbl);
170:
171:
172: opi_dbi_rpt_util_pkg.get_viewby_item_columns (p_view_by_dim, l_description, l_uom);
173:
174:
175: l_sel_clause :=
176: 'SELECT

Line 177: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

173:
174:
175: l_sel_clause :=
176: 'SELECT
177: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
178: l_description || ' OPI_ATTRIBUTE1,
179: ' || l_uom || ' OPI_ATTRIBUTE2';
180:
181: l_sel_clause := l_sel_clause ||

Line 249: ',' || opi_dbi_rpt_util_pkg.nvl_str (

245:
246: l_sel_clause := l_sel_clause ||
247: 'FROM ( SELECT ' || fnd_global.newline ||
248: l_view_by_fact_col || fnd_global.newline ||
249: ',' || opi_dbi_rpt_util_pkg.nvl_str (
250: p_str => 'c_late_prod_cnt',
251: p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;
252:
253: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN

Line 256: opi_dbi_rpt_util_pkg.nvl_str (

252:
253: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
254: --{
255: l_sel_clause := l_sel_clause ||
256: opi_dbi_rpt_util_pkg.nvl_str (
257: p_str => 'c_late_prod_qty',
258: p_default_val => 0) || ' OPI_MEASURE2, '|| fnd_global.newline;
259: --}
260: ELSE

Line 267: opi_dbi_rpt_util_pkg.nvl_str (

263: --}
264: END IF;
265:
266: l_sel_clause := l_sel_clause ||
267: opi_dbi_rpt_util_pkg.nvl_str (
268: p_str => 'c_late_prod_val',
269: p_default_val => 0) || ' OPI_MEASURE3,
270: ' || opi_dbi_rpt_util_pkg.nvl_str (
271: p_str => 'c_ontime_prod_cnt',

Line 270: ' || opi_dbi_rpt_util_pkg.nvl_str (

266: l_sel_clause := l_sel_clause ||
267: opi_dbi_rpt_util_pkg.nvl_str (
268: p_str => 'c_late_prod_val',
269: p_default_val => 0) || ' OPI_MEASURE3,
270: ' || opi_dbi_rpt_util_pkg.nvl_str (
271: p_str => 'c_ontime_prod_cnt',
272: p_default_val => 0) || ' OPI_MEASURE4,'|| fnd_global.newline;
273:
274: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN

Line 277: opi_dbi_rpt_util_pkg.nvl_str (

273:
274: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
275: --{
276: l_sel_clause := l_sel_clause ||
277: opi_dbi_rpt_util_pkg.nvl_str (
278: p_str => 'c_ontime_prod_qty',
279: p_default_val => 0) || ' OPI_MEASURE5,'|| fnd_global.newline;
280: --}
281: ELSE

Line 288: opi_dbi_rpt_util_pkg.nvl_str (

284: --}
285: END IF;
286:
287: l_sel_clause := l_sel_clause ||
288: opi_dbi_rpt_util_pkg.nvl_str (
289: p_str => 'p_ontime_prod_val',
290: p_default_val => 0) || ' OPI_MEASURE6,
291: ' || opi_dbi_rpt_util_pkg.nvl_str (
292: p_str => 'c_ontime_prod_val',

Line 291: ' || opi_dbi_rpt_util_pkg.nvl_str (

287: l_sel_clause := l_sel_clause ||
288: opi_dbi_rpt_util_pkg.nvl_str (
289: p_str => 'p_ontime_prod_val',
290: p_default_val => 0) || ' OPI_MEASURE6,
291: ' || opi_dbi_rpt_util_pkg.nvl_str (
292: p_str => 'c_ontime_prod_val',
293: p_default_val => 0) || ' OPI_MEASURE7,
294: ' || opi_dbi_rpt_util_pkg.nvl_str (
295: p_str => '(c_late_prod_cnt+c_ontime_prod_cnt)',

Line 294: ' || opi_dbi_rpt_util_pkg.nvl_str (

290: p_default_val => 0) || ' OPI_MEASURE6,
291: ' || opi_dbi_rpt_util_pkg.nvl_str (
292: p_str => 'c_ontime_prod_val',
293: p_default_val => 0) || ' OPI_MEASURE7,
294: ' || opi_dbi_rpt_util_pkg.nvl_str (
295: p_str => '(c_late_prod_cnt+c_ontime_prod_cnt)',
296: p_default_val => 0) || ' OPI_MEASURE8,'|| fnd_global.newline;
297:
298: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN

Line 301: opi_dbi_rpt_util_pkg.nvl_str (

297:
298: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
299: --{
300: l_sel_clause := l_sel_clause ||
301: opi_dbi_rpt_util_pkg.nvl_str (
302: p_str => '(c_late_prod_qty+c_ontime_prod_qty)',
303: p_default_val => 0) || ' OPI_MEASURE9,'|| fnd_global.newline;
304: --}
305: ELSE

Line 312: opi_dbi_rpt_util_pkg.nvl_str (

308: --}
309: END IF;
310:
311: l_sel_clause := l_sel_clause ||
312: opi_dbi_rpt_util_pkg.nvl_str (
313: p_str => '(c_late_prod_val+c_ontime_prod_val)',
314: p_default_val => 0) || ' OPI_MEASURE10,
315: ' || opi_dbi_rpt_util_pkg.percent_str(
316: p_numerator => 'p_ontime_prod_cnt',

Line 315: ' || opi_dbi_rpt_util_pkg.percent_str(

311: l_sel_clause := l_sel_clause ||
312: opi_dbi_rpt_util_pkg.nvl_str (
313: p_str => '(c_late_prod_val+c_ontime_prod_val)',
314: p_default_val => 0) || ' OPI_MEASURE10,
315: ' || opi_dbi_rpt_util_pkg.percent_str(
316: p_numerator => 'p_ontime_prod_cnt',
317: p_denominator => '(p_late_prod_cnt+p_ontime_prod_cnt)',
318: p_measure_name => 'OPI_MEASURE24') || ',
319: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 319: ' || opi_dbi_rpt_util_pkg.percent_str(

315: ' || opi_dbi_rpt_util_pkg.percent_str(
316: p_numerator => 'p_ontime_prod_cnt',
317: p_denominator => '(p_late_prod_cnt+p_ontime_prod_cnt)',
318: p_measure_name => 'OPI_MEASURE24') || ',
319: ' || opi_dbi_rpt_util_pkg.percent_str(
320: p_numerator => 'c_ontime_prod_cnt',
321: p_denominator => '(c_late_prod_cnt+c_ontime_prod_cnt)',
322: p_measure_name => 'OPI_MEASURE11') || ',
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 => 'c_ontime_prod_cnt',
321: p_denominator => '(c_late_prod_cnt+c_ontime_prod_cnt)',
322: p_measure_name => 'OPI_MEASURE11') || ',
323: ' || opi_dbi_rpt_util_pkg.percent_str(
324: p_numerator => 'p_ontime_prod_val',
325: p_denominator => '(p_late_prod_val+p_ontime_prod_val)',
326: p_measure_name => 'OPI_MEASURE12') || ',
327: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 327: ' || opi_dbi_rpt_util_pkg.percent_str(

323: ' || opi_dbi_rpt_util_pkg.percent_str(
324: p_numerator => 'p_ontime_prod_val',
325: p_denominator => '(p_late_prod_val+p_ontime_prod_val)',
326: p_measure_name => 'OPI_MEASURE12') || ',
327: ' || opi_dbi_rpt_util_pkg.percent_str(
328: p_numerator => 'c_ontime_prod_val',
329: p_denominator => '(c_late_prod_val+c_ontime_prod_val)',
330: p_measure_name => 'OPI_MEASURE13') || ',
331: ' || opi_dbi_rpt_util_pkg.rate_str (

Line 331: ' || opi_dbi_rpt_util_pkg.rate_str (

327: ' || opi_dbi_rpt_util_pkg.percent_str(
328: p_numerator => 'c_ontime_prod_val',
329: p_denominator => '(c_late_prod_val+c_ontime_prod_val)',
330: p_measure_name => 'OPI_MEASURE13') || ',
331: ' || opi_dbi_rpt_util_pkg.rate_str (
332: p_numerator => 'c_ontime_prod_val',
333: p_denominator => '(c_late_prod_val+c_ontime_prod_val)',
334: p_rate_type => 'NP') || '-' ||
335: opi_dbi_rpt_util_pkg.rate_str (

Line 335: opi_dbi_rpt_util_pkg.rate_str (

331: ' || opi_dbi_rpt_util_pkg.rate_str (
332: p_numerator => 'c_ontime_prod_val',
333: p_denominator => '(c_late_prod_val+c_ontime_prod_val)',
334: p_rate_type => 'NP') || '-' ||
335: opi_dbi_rpt_util_pkg.rate_str (
336: p_numerator => 'p_ontime_prod_val',
337: p_denominator => '(p_late_prod_val+p_ontime_prod_val)',
338: p_rate_type => 'NP') || 'OPI_MEASURE14,
339: ' || opi_dbi_rpt_util_pkg.nvl_str (

Line 339: ' || opi_dbi_rpt_util_pkg.nvl_str (

335: opi_dbi_rpt_util_pkg.rate_str (
336: p_numerator => 'p_ontime_prod_val',
337: p_denominator => '(p_late_prod_val+p_ontime_prod_val)',
338: p_rate_type => 'NP') || 'OPI_MEASURE14,
339: ' || opi_dbi_rpt_util_pkg.nvl_str (
340: p_str => 'c_late_prod_cnt_total',
341: p_default_val => 0) || ' OPI_MEASURE15,
342: ' || opi_dbi_rpt_util_pkg.nvl_str (
343: p_str => 'c_late_prod_val_total',

Line 342: ' || opi_dbi_rpt_util_pkg.nvl_str (

338: p_rate_type => 'NP') || 'OPI_MEASURE14,
339: ' || opi_dbi_rpt_util_pkg.nvl_str (
340: p_str => 'c_late_prod_cnt_total',
341: p_default_val => 0) || ' OPI_MEASURE15,
342: ' || opi_dbi_rpt_util_pkg.nvl_str (
343: p_str => 'c_late_prod_val_total',
344: p_default_val => 0) || ' OPI_MEASURE16,
345: ' || opi_dbi_rpt_util_pkg.nvl_str (
346: p_str => 'c_ontime_prod_cnt_total',

Line 345: ' || opi_dbi_rpt_util_pkg.nvl_str (

341: p_default_val => 0) || ' OPI_MEASURE15,
342: ' || opi_dbi_rpt_util_pkg.nvl_str (
343: p_str => 'c_late_prod_val_total',
344: p_default_val => 0) || ' OPI_MEASURE16,
345: ' || opi_dbi_rpt_util_pkg.nvl_str (
346: p_str => 'c_ontime_prod_cnt_total',
347: p_default_val => 0) || ' OPI_MEASURE17,
348: ' || opi_dbi_rpt_util_pkg.nvl_str (
349: p_str => 'c_ontime_prod_val_total',

Line 348: ' || opi_dbi_rpt_util_pkg.nvl_str (

344: p_default_val => 0) || ' OPI_MEASURE16,
345: ' || opi_dbi_rpt_util_pkg.nvl_str (
346: p_str => 'c_ontime_prod_cnt_total',
347: p_default_val => 0) || ' OPI_MEASURE17,
348: ' || opi_dbi_rpt_util_pkg.nvl_str (
349: p_str => 'c_ontime_prod_val_total',
350: p_default_val => 0) || ' OPI_MEASURE18,
351: ' || opi_dbi_rpt_util_pkg.nvl_str (
352: p_str => '(c_late_prod_cnt_total+c_ontime_prod_cnt_total)',

Line 351: ' || opi_dbi_rpt_util_pkg.nvl_str (

347: p_default_val => 0) || ' OPI_MEASURE17,
348: ' || opi_dbi_rpt_util_pkg.nvl_str (
349: p_str => 'c_ontime_prod_val_total',
350: p_default_val => 0) || ' OPI_MEASURE18,
351: ' || opi_dbi_rpt_util_pkg.nvl_str (
352: p_str => '(c_late_prod_cnt_total+c_ontime_prod_cnt_total)',
353: p_default_val => 0) || ' OPI_MEASURE19,
354: ' || opi_dbi_rpt_util_pkg.nvl_str (
355: p_str => '(c_late_prod_val_total+c_ontime_prod_val_total)',

Line 354: ' || opi_dbi_rpt_util_pkg.nvl_str (

350: p_default_val => 0) || ' OPI_MEASURE18,
351: ' || opi_dbi_rpt_util_pkg.nvl_str (
352: p_str => '(c_late_prod_cnt_total+c_ontime_prod_cnt_total)',
353: p_default_val => 0) || ' OPI_MEASURE19,
354: ' || opi_dbi_rpt_util_pkg.nvl_str (
355: p_str => '(c_late_prod_val_total+c_ontime_prod_val_total)',
356: p_default_val => 0) || ' OPI_MEASURE20,
357: ' || opi_dbi_rpt_util_pkg.percent_str(
358: p_numerator => 'c_ontime_prod_cnt_total',

Line 357: ' || opi_dbi_rpt_util_pkg.percent_str(

353: p_default_val => 0) || ' OPI_MEASURE19,
354: ' || opi_dbi_rpt_util_pkg.nvl_str (
355: p_str => '(c_late_prod_val_total+c_ontime_prod_val_total)',
356: p_default_val => 0) || ' OPI_MEASURE20,
357: ' || opi_dbi_rpt_util_pkg.percent_str(
358: p_numerator => 'c_ontime_prod_cnt_total',
359: p_denominator => '(c_late_prod_cnt_total+c_ontime_prod_cnt_total)',
360: p_measure_name => 'OPI_MEASURE21') || ',
361: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 361: ' || opi_dbi_rpt_util_pkg.percent_str(

357: ' || opi_dbi_rpt_util_pkg.percent_str(
358: p_numerator => 'c_ontime_prod_cnt_total',
359: p_denominator => '(c_late_prod_cnt_total+c_ontime_prod_cnt_total)',
360: p_measure_name => 'OPI_MEASURE21') || ',
361: ' || opi_dbi_rpt_util_pkg.percent_str(
362: p_numerator => 'c_ontime_prod_val_total',
363: p_denominator => '(c_late_prod_val_total+c_ontime_prod_val_total)',
364: p_measure_name => 'OPI_MEASURE22') || ',
365: ' || opi_dbi_rpt_util_pkg.rate_str (

Line 365: ' || opi_dbi_rpt_util_pkg.rate_str (

361: ' || opi_dbi_rpt_util_pkg.percent_str(
362: p_numerator => 'c_ontime_prod_val_total',
363: p_denominator => '(c_late_prod_val_total+c_ontime_prod_val_total)',
364: p_measure_name => 'OPI_MEASURE22') || ',
365: ' || opi_dbi_rpt_util_pkg.rate_str (
366: p_numerator => 'c_ontime_prod_val_total',
367: p_denominator => '(c_late_prod_val_total+c_ontime_prod_val_total)',
368: p_rate_type => 'NP') || '-' ||
369: opi_dbi_rpt_util_pkg.rate_str (

Line 369: opi_dbi_rpt_util_pkg.rate_str (

365: ' || opi_dbi_rpt_util_pkg.rate_str (
366: p_numerator => 'c_ontime_prod_val_total',
367: p_denominator => '(c_late_prod_val_total+c_ontime_prod_val_total)',
368: p_rate_type => 'NP') || '-' ||
369: opi_dbi_rpt_util_pkg.rate_str (
370: p_numerator => 'p_ontime_prod_val_total',
371: p_denominator => '(p_late_prod_val_total+p_ontime_prod_val_total)',
372: p_rate_type => 'NP') || 'OPI_MEASURE23,
373: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 373: ' || opi_dbi_rpt_util_pkg.percent_str(

369: opi_dbi_rpt_util_pkg.rate_str (
370: p_numerator => 'p_ontime_prod_val_total',
371: p_denominator => '(p_late_prod_val_total+p_ontime_prod_val_total)',
372: p_rate_type => 'NP') || 'OPI_MEASURE23,
373: ' || opi_dbi_rpt_util_pkg.percent_str(
374: p_numerator => 'c_ontime_prod_val',
375: p_denominator => '(c_late_prod_val+c_ontime_prod_val)',
376: p_measure_name => 'OPI_MEASURE25') || ',
377: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 377: ' || opi_dbi_rpt_util_pkg.percent_str(

373: ' || opi_dbi_rpt_util_pkg.percent_str(
374: p_numerator => 'c_ontime_prod_val',
375: p_denominator => '(c_late_prod_val+c_ontime_prod_val)',
376: p_measure_name => 'OPI_MEASURE25') || ',
377: ' || opi_dbi_rpt_util_pkg.percent_str(
378: p_numerator => 'p_ontime_prod_val',
379: p_denominator => '(p_late_prod_val+p_ontime_prod_val)',
380: p_measure_name => 'OPI_MEASURE26') || ',
381: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 381: ' || opi_dbi_rpt_util_pkg.percent_str(

377: ' || opi_dbi_rpt_util_pkg.percent_str(
378: p_numerator => 'p_ontime_prod_val',
379: p_denominator => '(p_late_prod_val+p_ontime_prod_val)',
380: p_measure_name => 'OPI_MEASURE26') || ',
381: ' || opi_dbi_rpt_util_pkg.percent_str(
382: p_numerator => 'c_ontime_prod_val_total',
383: p_denominator => '(c_late_prod_val_total+c_ontime_prod_val_total)',
384: p_measure_name => 'OPI_MEASURE27') || ',
385: ' || opi_dbi_rpt_util_pkg.percent_str(

Line 385: ' || opi_dbi_rpt_util_pkg.percent_str(

381: ' || opi_dbi_rpt_util_pkg.percent_str(
382: p_numerator => 'c_ontime_prod_val_total',
383: p_denominator => '(c_late_prod_val_total+c_ontime_prod_val_total)',
384: p_measure_name => 'OPI_MEASURE27') || ',
385: ' || opi_dbi_rpt_util_pkg.percent_str(
386: p_numerator => 'p_ontime_prod_val_total',
387: p_denominator => '(p_late_prod_val_total+p_ontime_prod_val_total)',
388: p_measure_name => 'OPI_MEASURE28');
389: