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 FND_GLOBAL

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 209: ,OPI_MEASURE28'|| fnd_global.newline;

205: ,OPI_MEASURE23
206: ,OPI_MEASURE25
207: ,OPI_MEASURE26
208: ,OPI_MEASURE27
209: ,OPI_MEASURE28'|| fnd_global.newline;
210:
211: l_sel_clause := l_sel_clause ||
212: 'FROM ( SELECT
213: rank() over (&ORDER_BY_CLAUSE nulls last '||', '||l_view_by_fact_col||') - 1 rnk

Line 244: ,OPI_MEASURE28'|| fnd_global.newline;

240: ,OPI_MEASURE23
241: ,OPI_MEASURE25
242: ,OPI_MEASURE26
243: ,OPI_MEASURE27
244: ,OPI_MEASURE28'|| fnd_global.newline;
245:
246: l_sel_clause := l_sel_clause ||
247: 'FROM ( SELECT ' || fnd_global.newline ||
248: l_view_by_fact_col || fnd_global.newline ||

Line 247: 'FROM ( SELECT ' || fnd_global.newline ||

243: ,OPI_MEASURE27
244: ,OPI_MEASURE28'|| fnd_global.newline;
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;

Line 248: l_view_by_fact_col || fnd_global.newline ||

244: ,OPI_MEASURE28'|| fnd_global.newline;
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:

Line 251: p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;

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
254: --{
255: l_sel_clause := l_sel_clause ||

Line 258: p_default_val => 0) || ' OPI_MEASURE2, '|| fnd_global.newline;

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
261: --{
262: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE2, '|| fnd_global.newline;

Line 262: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE2, '|| fnd_global.newline;

258: p_default_val => 0) || ' OPI_MEASURE2, '|| fnd_global.newline;
259: --}
260: ELSE
261: --{
262: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE2, '|| fnd_global.newline;
263: --}
264: END IF;
265:
266: l_sel_clause := l_sel_clause ||

Line 272: p_default_val => 0) || ' OPI_MEASURE4,'|| fnd_global.newline;

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
275: --{
276: l_sel_clause := l_sel_clause ||

Line 279: p_default_val => 0) || ' OPI_MEASURE5,'|| fnd_global.newline;

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
282: --{
283: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE5, '|| fnd_global.newline;

Line 283: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE5, '|| fnd_global.newline;

279: p_default_val => 0) || ' OPI_MEASURE5,'|| fnd_global.newline;
280: --}
281: ELSE
282: --{
283: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE5, '|| fnd_global.newline;
284: --}
285: END IF;
286:
287: l_sel_clause := l_sel_clause ||

Line 296: p_default_val => 0) || ' OPI_MEASURE8,'|| fnd_global.newline;

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
299: --{
300: l_sel_clause := l_sel_clause ||

Line 303: p_default_val => 0) || ' OPI_MEASURE9,'|| fnd_global.newline;

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
306: --{
307: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE9, '|| fnd_global.newline;

Line 307: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE9, '|| fnd_global.newline;

303: p_default_val => 0) || ' OPI_MEASURE9,'|| fnd_global.newline;
304: --}
305: ELSE
306: --{
307: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE9, '|| fnd_global.newline;
308: --}
309: END IF;
310:
311: l_sel_clause := l_sel_clause ||