APPS.OPI_DBI_CURR_PROD_DEL_RPT_PKG dependencies on FND_GLOBAL

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

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

Line 194: ,OPI_MEASURE16'|| fnd_global.newline;

190: ,OPI_MEASURE12
191: ,OPI_MEASURE13
192: ,OPI_MEASURE14
193: ,OPI_MEASURE15
194: ,OPI_MEASURE16'|| fnd_global.newline;
195:
196: l_sel_clause := l_sel_clause ||
197: 'FROM ( SELECT
198: rank() over (&ORDER_BY_CLAUSE nulls last '||', '||l_view_by_fact_col||') - 1 rnk

Line 215: ,OPI_MEASURE16'|| fnd_global.newline;

211: ,OPI_MEASURE12
212: ,OPI_MEASURE13
213: ,OPI_MEASURE14
214: ,OPI_MEASURE15
215: ,OPI_MEASURE16'|| fnd_global.newline;
216:
217: l_sel_clause := l_sel_clause ||
218: 'FROM ( SELECT ' || fnd_global.newline ||
219: l_view_by_fact_col || fnd_global.newline ||

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

214: ,OPI_MEASURE15
215: ,OPI_MEASURE16'|| fnd_global.newline;
216:
217: l_sel_clause := l_sel_clause ||
218: 'FROM ( SELECT ' || fnd_global.newline ||
219: l_view_by_fact_col || fnd_global.newline ||
220: ',' || opi_dbi_rpt_util_pkg.nvl_str (
221: p_str => 'c_late_jobs_cnt',
222: p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;

Line 219: l_view_by_fact_col || fnd_global.newline ||

215: ,OPI_MEASURE16'|| fnd_global.newline;
216:
217: l_sel_clause := l_sel_clause ||
218: 'FROM ( SELECT ' || fnd_global.newline ||
219: l_view_by_fact_col || fnd_global.newline ||
220: ',' || opi_dbi_rpt_util_pkg.nvl_str (
221: p_str => 'c_late_jobs_cnt',
222: p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;
223:

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

218: 'FROM ( SELECT ' || fnd_global.newline ||
219: l_view_by_fact_col || fnd_global.newline ||
220: ',' || opi_dbi_rpt_util_pkg.nvl_str (
221: p_str => 'c_late_jobs_cnt',
222: p_default_val => 0) || ' OPI_MEASURE1, '|| fnd_global.newline;
223:
224: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
225: --{
226: l_sel_clause := l_sel_clause ||

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

225: --{
226: l_sel_clause := l_sel_clause ||
227: opi_dbi_rpt_util_pkg.nvl_str (
228: p_str => 'c_late_jobs_qty',
229: p_default_val => 0) || ' OPI_MEASURE2, '|| fnd_global.newline;
230: --}
231: ELSE
232: --{
233: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE2, '|| fnd_global.newline;

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

229: p_default_val => 0) || ' OPI_MEASURE2, '|| fnd_global.newline;
230: --}
231: ELSE
232: --{
233: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE2, '|| fnd_global.newline;
234: --}
235: END IF;
236:
237: l_sel_clause := l_sel_clause ||

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

239: p_str => 'c_late_jobs_val',
240: p_default_val => 0) || ' OPI_MEASURE3,
241: ' || opi_dbi_rpt_util_pkg.nvl_str (
242: p_str => 'c_open_jobs_cnt',
243: p_default_val => 0) || ' OPI_MEASURE4,'|| fnd_global.newline;
244:
245: IF (p_view_by_dim = 'ITEM+ENI_ITEM_ORG') THEN
246: --{
247: l_sel_clause := l_sel_clause ||

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

246: --{
247: l_sel_clause := l_sel_clause ||
248: opi_dbi_rpt_util_pkg.nvl_str (
249: p_str => 'c_open_jobs_qty',
250: p_default_val => 0) || ' OPI_MEASURE5,'|| fnd_global.newline;
251: --}
252: ELSE
253: --{
254: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE5, '|| fnd_global.newline;

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

250: p_default_val => 0) || ' OPI_MEASURE5,'|| fnd_global.newline;
251: --}
252: ELSE
253: --{
254: l_sel_clause := l_sel_clause || 'NULL OPI_MEASURE5, '|| fnd_global.newline;
255: --}
256: END IF;
257:
258: l_sel_clause := l_sel_clause ||