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_RPT_PKG dependencies on FND_GLOBAL

Line 106: l_query := GET_PICK_EX_SEL_CLAUSE (l_view_by, l_join_tbl) || fnd_global.newline

102: --Add filtering condition to suppress rows
103: l_filter_where := 'OPI_MEASURE11 > 0 or OPI_MEASURE1 > 0';
104:
105: --Generate Final Query
106: l_query := GET_PICK_EX_SEL_CLAUSE (l_view_by, l_join_tbl) || fnd_global.newline
107: || 'from
108: ' || poa_dbi_template_pkg.status_sql (
109: p_fact_name => l_mv,
110: p_where_clause => l_where_clause,

Line 173: || fnd_global.newline ||' ' || l_description ||

169: -- Start generating SELECT clause for query
170: l_sel_clause :=
171: 'SELECT
172: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
173: || fnd_global.newline ||' ' || l_description ||
174: ' OPI_ATTRIBUTE10 ';
175:
176: l_sel_clause := l_sel_clause ||'
177: ,OPI_MEASURE11

Line 202: ,OPI_MEASURE33 '|| fnd_global.newline;

198: ,OPI_MEASURE29
199: ,OPI_MEASURE30
200: ,OPI_MEASURE31
201: ,OPI_MEASURE32
202: ,OPI_MEASURE33 '|| fnd_global.newline;
203:
204: l_sel_clause := l_sel_clause || 'FROM ( SELECT
205: rank() over (&ORDER_BY_CLAUSE nulls last '||', '||l_view_by_fact_col||') - 1 rnk
206: ,'||l_view_by_fact_col;

Line 234: ,OPI_MEASURE33 '|| fnd_global.newline;

230: ,OPI_MEASURE29
231: ,OPI_MEASURE30
232: ,OPI_MEASURE31
233: ,OPI_MEASURE32
234: ,OPI_MEASURE33 '|| fnd_global.newline;
235:
236: l_sel_clause := l_sel_clause ||
237: 'FROM ( SELECT ' || fnd_global.newline ||'
238: ' || l_view_by_fact_col || ',

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

233: ,OPI_MEASURE32
234: ,OPI_MEASURE33 '|| fnd_global.newline;
235:
236: l_sel_clause := l_sel_clause ||
237: 'FROM ( SELECT ' || fnd_global.newline ||'
238: ' || l_view_by_fact_col || ',
239: ' || opi_dbi_rpt_util_pkg.nvl_str (
240: p_str => 'p_picks',
241: p_default_val => 0) || ' OPI_MEASURE11,

Line 409: l_query := GET_PICK_REASON_SEL_CLAUSE (l_view_by, l_join_tbl) || fnd_global.newline

405: p_grand_total => 'Y',
406: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
407: p_to_date_type => 'RLX');
408:
409: l_query := GET_PICK_REASON_SEL_CLAUSE (l_view_by, l_join_tbl) || fnd_global.newline
410: || 'from
411: ' || poa_dbi_template_pkg.status_sql (
412: p_fact_name => l_mv,
413: p_where_clause => l_where_clause,

Line 467: || fnd_global.newline;

463: -- Start generating SELECT clause for query
464: l_sel_clause :=
465: 'SELECT
466: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
467: || fnd_global.newline;
468:
469: l_sel_clause := l_sel_clause ||
470: 'OPI_MEASURE1
471: ,OPI_MEASURE2

Line 475: ,OPI_MEASURE6' || fnd_global.newline ||

471: ,OPI_MEASURE2
472: ,OPI_MEASURE3
473: ,OPI_MEASURE4
474: ,OPI_MEASURE5
475: ,OPI_MEASURE6' || fnd_global.newline ||
476: 'FROM
477: (SELECT (rank () over
478: (&ORDER_BY_CLAUSE nulls last,
479: ' || l_view_by_fact_col || ')) - 1 rnk,

Line 486: OPI_MEASURE6'|| fnd_global.newline;

482: OPI_MEASURE2,
483: OPI_MEASURE3,
484: OPI_MEASURE4,
485: OPI_MEASURE5,
486: OPI_MEASURE6'|| fnd_global.newline;
487:
488: l_sel_clause := l_sel_clause ||
489: 'FROM ( SELECT ' || fnd_global.newline ||'
490: ' || l_view_by_fact_col || ',

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

485: OPI_MEASURE5,
486: OPI_MEASURE6'|| fnd_global.newline;
487:
488: l_sel_clause := l_sel_clause ||
489: 'FROM ( SELECT ' || fnd_global.newline ||'
490: ' || l_view_by_fact_col || ',
491: ' || opi_dbi_rpt_util_pkg.nvl_str (
492: p_str => 'c_exceptions',
493: p_default_val => 0) || ' OPI_MEASURE1,

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

833:
834: -- Start generating SELECT clause for query
835: l_sel_clause :=
836: 'SELECT
837: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline;
838:
839: l_sel_clause := l_sel_clause ||'
840: OPI_MEASURE13
841: ,OPI_MEASURE2

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

854: ,OPI_MEASURE24
855: ,OPI_MEASURE25
856: ,OPI_MEASURE26
857: ,OPI_MEASURE27
858: ,OPI_MEASURE28'|| fnd_global.newline;
859:
860: l_sel_clause := l_sel_clause ||
861: 'FROM ( SELECT
862: rank() over (&ORDER_BY_CLAUSE nulls last '||', '||l_view_by_fact_col||') - 1 rnk

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

880: ,OPI_MEASURE24
881: ,OPI_MEASURE25
882: ,OPI_MEASURE26
883: ,OPI_MEASURE27
884: ,OPI_MEASURE28'|| fnd_global.newline;
885:
886: l_sel_clause := l_sel_clause ||
887: 'FROM ( SELECT ' || fnd_global.newline ||
888: l_view_by_fact_col || fnd_global.newline ||

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

883: ,OPI_MEASURE27
884: ,OPI_MEASURE28'|| fnd_global.newline;
885:
886: l_sel_clause := l_sel_clause ||
887: 'FROM ( SELECT ' || fnd_global.newline ||
888: l_view_by_fact_col || fnd_global.newline ||
889: ',' || opi_dbi_rpt_util_pkg.rate_str (
890: p_numerator => 'p_elapsed_time',
891: p_denominator => 'p_executions',

Line 888: l_view_by_fact_col || fnd_global.newline ||

884: ,OPI_MEASURE28'|| fnd_global.newline;
885:
886: l_sel_clause := l_sel_clause ||
887: 'FROM ( SELECT ' || fnd_global.newline ||
888: l_view_by_fact_col || fnd_global.newline ||
889: ',' || opi_dbi_rpt_util_pkg.rate_str (
890: p_numerator => 'p_elapsed_time',
891: p_denominator => 'p_executions',
892: p_rate_type => 'NP') || 'OPI_MEASURE13,

Line 1091: || fnd_global.newline;

1087: -- Start generating SELECT clause for query
1088: l_sel_clause :=
1089: 'SELECT
1090: ' || opi_dbi_rpt_util_pkg.get_viewby_select_clause (p_view_by_dim)
1091: || fnd_global.newline;
1092:
1093: l_sel_clause := l_sel_clause ||
1094: ' OPI_MEASURE1
1095: ,OPI_MEASURE2

Line 1110: OPI_MEASURE6'|| fnd_global.newline;

1106: OPI_MEASURE2,
1107: OPI_MEASURE3,
1108: OPI_MEASURE4,
1109: OPI_MEASURE5,
1110: OPI_MEASURE6'|| fnd_global.newline;
1111:
1112: l_sel_clause := l_sel_clause ||
1113: 'FROM ( SELECT ' || fnd_global.newline ||
1114: l_view_by_fact_col || fnd_global.newline ||

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

1109: OPI_MEASURE5,
1110: OPI_MEASURE6'|| fnd_global.newline;
1111:
1112: l_sel_clause := l_sel_clause ||
1113: 'FROM ( SELECT ' || fnd_global.newline ||
1114: l_view_by_fact_col || fnd_global.newline ||
1115: ',' || opi_dbi_rpt_util_pkg.nvl_str (
1116: p_str => 'c_exceptions',
1117: p_default_val => 0) || ' OPI_MEASURE1,

Line 1114: l_view_by_fact_col || fnd_global.newline ||

1110: OPI_MEASURE6'|| fnd_global.newline;
1111:
1112: l_sel_clause := l_sel_clause ||
1113: 'FROM ( SELECT ' || fnd_global.newline ||
1114: l_view_by_fact_col || fnd_global.newline ||
1115: ',' || opi_dbi_rpt_util_pkg.nvl_str (
1116: p_str => 'c_exceptions',
1117: p_default_val => 0) || ' OPI_MEASURE1,
1118: ' || opi_dbi_rpt_util_pkg.change_str (