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.ISC_DEPOT_MTTR_PKG dependencies on FND_GLOBAL

Line 174: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

170:
171: l_drill_down_rep_1 := get_drill_down (p_view_by_dim => p_view_by_dim, p_function_name => 'ISC_DEPOT_MTTR_TBL_REP');
172:
173: l_sel_clause :=
174: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
175: l_description || ' BIV_ATTRIBUTE10 ';
176:
177: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
178: , p_col_name => 'BIV_ATTRIBUTE1'

Line 183: ) || fnd_global.newline ;

179: , p_alias_name => 'BIV_ATTRIBUTE1'
180: , p_total_flag => 'N'
181: , p_prefix => NULL
182: , p_suffix => NULL
183: ) || fnd_global.newline ;
184:
185: l_sel_clause := l_sel_clause ||
186: ',BIV_MEASURE11
187: ,BIV_MEASURE1

Line 199: ,BIV_MEASURE30 '|| fnd_global.newline;

195: ,BIV_MEASURE24
196: ,BIV_MEASURE27
197: ,BIV_MEASURE28
198: ,BIV_MEASURE29
199: ,BIV_MEASURE30 '|| fnd_global.newline;
200:
201: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
202: , p_col_name => 'BIV_MEASURE5'
203: , p_alias_name => 'BIV_MEASURE5'

Line 207: ) || fnd_global.newline ;

203: , p_alias_name => 'BIV_MEASURE5'
204: , p_total_flag => 'N'
205: , p_prefix => NULL
206: , p_suffix => NULL
207: ) || fnd_global.newline ;
208:
209: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
210: , p_col_name => 'BIV_MEASURE25'
211: , p_alias_name => 'BIV_MEASURE25'

Line 215: ) || fnd_global.newline ;

211: , p_alias_name => 'BIV_MEASURE25'
212: , p_total_flag => 'N'
213: , p_prefix => NULL
214: , p_suffix => NULL
215: ) || fnd_global.newline ;
216:
217:
218: l_sel_clause := l_sel_clause || ' ,'||l_drill_down_rep_1||' BIV_DYNAMIC_URL1' || fnd_global.newline;
219:

Line 218: l_sel_clause := l_sel_clause || ' ,'||l_drill_down_rep_1||' BIV_DYNAMIC_URL1' || fnd_global.newline;

214: , p_suffix => NULL
215: ) || fnd_global.newline ;
216:
217:
218: l_sel_clause := l_sel_clause || ' ,'||l_drill_down_rep_1||' BIV_DYNAMIC_URL1' || fnd_global.newline;
219:
220: l_sel_clause := l_sel_clause ||
221: 'FROM ( SELECT
222: rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||') - 1 rnk

Line 231: ) || fnd_global.newline ;

227: , p_alias_name => 'BIV_ATTRIBUTE1'
228: , p_total_flag => 'N'
229: , p_prefix => NULL
230: , p_suffix => NULL
231: ) || fnd_global.newline ;
232:
233: l_sel_clause := l_sel_clause ||
234: ',BIV_MEASURE11
235: ,BIV_MEASURE1

Line 247: ,BIV_MEASURE30 '|| fnd_global.newline;

243: ,BIV_MEASURE24
244: ,BIV_MEASURE27
245: ,BIV_MEASURE28
246: ,BIV_MEASURE29
247: ,BIV_MEASURE30 '|| fnd_global.newline;
248:
249: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
250: , p_col_name => 'BIV_MEASURE5'
251: , p_alias_name => 'BIV_MEASURE5'

Line 255: ) || fnd_global.newline ;

251: , p_alias_name => 'BIV_MEASURE5'
252: , p_total_flag => 'N'
253: , p_prefix => NULL
254: , p_suffix => NULL
255: ) || fnd_global.newline ;
256:
257: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
258: , p_col_name => 'BIV_MEASURE25'
259: , p_alias_name => 'BIV_MEASURE25'

Line 263: ) || fnd_global.newline ;

259: , p_alias_name => 'BIV_MEASURE25'
260: , p_total_flag => 'N'
261: , p_prefix => NULL
262: , p_suffix => NULL
263: ) || fnd_global.newline ;
264:
265: l_sel_clause := l_sel_clause ||
266: 'FROM ( SELECT ' || fnd_global.newline ||
267: p_view_by_col || fnd_global.newline ||

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

262: , p_suffix => NULL
263: ) || fnd_global.newline ;
264:
265: l_sel_clause := l_sel_clause ||
266: 'FROM ( SELECT ' || fnd_global.newline ||
267: p_view_by_col || fnd_global.newline ||
268: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
269: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'

Line 267: p_view_by_col || fnd_global.newline ||

263: ) || fnd_global.newline ;
264:
265: l_sel_clause := l_sel_clause ||
266: 'FROM ( SELECT ' || fnd_global.newline ||
267: p_view_by_col || fnd_global.newline ||
268: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
269: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
271: ,prior_col => 'p_ro_count'

Line 268: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

264:
265: l_sel_clause := l_sel_clause ||
266: 'FROM ( SELECT ' || fnd_global.newline ||
267: p_view_by_col || fnd_global.newline ||
268: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
269: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
271: ,prior_col => 'p_ro_count'
272: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 269: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

265: l_sel_clause := l_sel_clause ||
266: 'FROM ( SELECT ' || fnd_global.newline ||
267: p_view_by_col || fnd_global.newline ||
268: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
269: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
271: ,prior_col => 'p_ro_count'
272: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || 'BIV_MEASURE2' || fnd_global.newline ||

Line 273: || 'BIV_MEASURE2' || fnd_global.newline ||

269: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
271: ,prior_col => 'p_ro_count'
272: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || 'BIV_MEASURE2' || fnd_global.newline ||
274: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
275: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
276: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
277: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'

Line 274: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||

270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
271: ,prior_col => 'p_ro_count'
272: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || 'BIV_MEASURE2' || fnd_global.newline ||
274: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
275: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
276: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
277: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
278: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 275: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||

271: ,prior_col => 'p_ro_count'
272: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || 'BIV_MEASURE2' || fnd_global.newline ||
274: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
275: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
276: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
277: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
278: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
279: || 'BIV_MEASURE4' || fnd_global.newline ||

Line 279: || 'BIV_MEASURE4' || fnd_global.newline ||

275: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
276: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
277: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
278: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
279: || 'BIV_MEASURE4' || fnd_global.newline ||
280: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
282: ,prior_col => 'p_ro_count_total'
283: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 280: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||

276: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
277: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
278: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
279: || 'BIV_MEASURE4' || fnd_global.newline ||
280: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
282: ,prior_col => 'p_ro_count_total'
283: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
284: || 'BIV_MEASURE22' || fnd_global.newline ||

Line 284: || 'BIV_MEASURE22' || fnd_global.newline ||

280: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
282: ,prior_col => 'p_ro_count_total'
283: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
284: || 'BIV_MEASURE22' || fnd_global.newline ||
285: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||
286: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
287: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
288: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 285: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||

281: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
282: ,prior_col => 'p_ro_count_total'
283: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
284: || 'BIV_MEASURE22' || fnd_global.newline ||
285: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||
286: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
287: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
288: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
289: || 'BIV_MEASURE24' || fnd_global.newline ||

Line 289: || 'BIV_MEASURE24' || fnd_global.newline ||

285: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||
286: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
287: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
288: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
289: || 'BIV_MEASURE24' || fnd_global.newline ||
290: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE27 ' || fnd_global.newline ||
291: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE28 ' || fnd_global.newline ||
292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||
293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;

Line 290: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE27 ' || fnd_global.newline ||

286: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
287: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
288: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
289: || 'BIV_MEASURE24' || fnd_global.newline ||
290: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE27 ' || fnd_global.newline ||
291: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE28 ' || fnd_global.newline ||
292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||
293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;
294:

Line 291: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE28 ' || fnd_global.newline ||

287: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
288: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
289: || 'BIV_MEASURE24' || fnd_global.newline ||
290: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE27 ' || fnd_global.newline ||
291: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE28 ' || fnd_global.newline ||
292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||
293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;
294:
295: l_sel_clause := l_sel_clause ||

Line 292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||

288: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
289: || 'BIV_MEASURE24' || fnd_global.newline ||
290: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE27 ' || fnd_global.newline ||
291: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE28 ' || fnd_global.newline ||
292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||
293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;
294:
295: l_sel_clause := l_sel_clause ||
296: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

Line 293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;

289: || 'BIV_MEASURE24' || fnd_global.newline ||
290: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE27 ' || fnd_global.newline ||
291: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE28 ' || fnd_global.newline ||
292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||
293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;
294:
295: l_sel_clause := l_sel_clause ||
296: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
297: , p_col_name => 'c_ttr_distribution'

Line 302: ) || fnd_global.newline ;

298: , p_alias_name => 'BIV_MEASURE5'
299: , p_total_flag => 'N'
300: , p_prefix => 'NVL('
301: , p_suffix => ',0)'
302: ) || fnd_global.newline ;
303:
304: l_sel_clause := l_sel_clause ||
305: poa_dbi_util_pkg.get_bucket_drill_url( p_bucket_rec
306: , 'BIV_ATTRIBUTE1'

Line 318: ) || fnd_global.newline ;

314: , p_alias_name => 'BIV_MEASURE25'
315: , p_total_flag => 'Y'
316: , p_prefix => 'NVL('
317: , p_suffix => ',0)'
318: ) || fnd_global.newline ;
319:
320:
321:
322: RETURN l_sel_clause;

Line 476: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||

472:
473: BEGIN
474:
475: l_sel_clause :=
476: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
477: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
478: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
479: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
480: ,prior_col => 'iset.p_ro_count'

Line 477: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

473: BEGIN
474:
475: l_sel_clause :=
476: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
477: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
478: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
479: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
480: ,prior_col => 'iset.p_ro_count'
481: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 478: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

474:
475: l_sel_clause :=
476: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
477: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
478: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
479: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
480: ,prior_col => 'iset.p_ro_count'
481: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
482: || 'BIV_MEASURE2' || fnd_global.newline ||

Line 482: || 'BIV_MEASURE2' || fnd_global.newline ||

478: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
479: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
480: ,prior_col => 'iset.p_ro_count'
481: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
482: || 'BIV_MEASURE2' || fnd_global.newline ||
483: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
484: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
486: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'

Line 483: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||

479: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
480: ,prior_col => 'iset.p_ro_count'
481: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
482: || 'BIV_MEASURE2' || fnd_global.newline ||
483: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
484: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
486: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'
487: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 484: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||

480: ,prior_col => 'iset.p_ro_count'
481: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
482: || 'BIV_MEASURE2' || fnd_global.newline ||
483: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
484: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
486: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'
487: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
488: || 'BIV_MEASURE4' || fnd_global.newline;

Line 488: || 'BIV_MEASURE4' || fnd_global.newline;

484: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
486: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'
487: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
488: || 'BIV_MEASURE4' || fnd_global.newline;
489:
490: l_sel_clause := l_sel_clause ||
491: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
492: , p_col_name => 'iset.c_ttr_distribution'

Line 497: ) || fnd_global.newline ;

493: , p_alias_name => 'BIV_MEASURE5'
494: , p_total_flag => 'N'
495: , p_prefix => 'NVL('
496: , p_suffix => ',0)'
497: ) || fnd_global.newline ;
498:
499: RETURN l_sel_clause;
500:
501: END GET_MTTR_TRD_SEL_CLAUSE;

Line 622: FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||

618: ,BIV_DATE3
619: ,BIV_MEASURE2
620: ,BIV_MEASURE3
621: ,BIV_MEASURE4
622: FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||
623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||

Line 623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||

619: ,BIV_MEASURE2
620: ,BIV_MEASURE3
621: ,BIV_MEASURE4
622: FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||
623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||

Line 624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||

620: ,BIV_MEASURE3
621: ,BIV_MEASURE4
622: FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||
623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||

Line 625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||

621: ,BIV_MEASURE4
622: FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||
623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||

Line 626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||

622: FROM ( SELECT fact1.repair_line_id repair_line_id' || fnd_global.newline ||
623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||

Line 627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||

623: ',' || ' fact.repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||

Line 628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||

624: ',' || ' fact.incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||

Line 629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||

625: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||

Line 630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||

626: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||

Line 631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||

627: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||

Line 632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||

628: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||

Line 633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||

629: ',' || ' fact.incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||

Line 634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||

630: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||

Line 635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||

631: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline ||
632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||

Line 636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||

632: ',' || ' fact.quantity BIV_MEASURE1 ' || fnd_global.newline ||
633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||

Line 637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||

633: ',' || ' fact.serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||

Line 638: ' FROM '|| fnd_global.newline || l_mv ||

634: ',' || ' fact.promise_date BIV_DATE1 ' || fnd_global.newline ||
635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||

Line 639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||

635: ',' || ' trunc(fact1.repair_start_date) BIV_DATE2 ' || fnd_global.newline ||
636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||

Line 640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||

636: ',' || ' trunc(fact1.repair_end_date) BIV_DATE3 ' || fnd_global.newline ||
637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||

Line 641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||

637: ',' || ' fact1.time_to_repair BIV_MEASURE2 ' || fnd_global.newline ||
638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||

Line 642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||

638: ' FROM '|| fnd_global.newline || l_mv ||
639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||

Line 643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||

639: ' ISC_DR_REPAIR_ORDERS_F fact' || fnd_global.newline ||
640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||
647: ' AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause

Line 644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||

640: ',' || ' ISC_DR_MTTR_F fact1' || fnd_global.newline ||
641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||
647: ' AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause
648: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)

Line 645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||

641: ',' || ' MTL_UNITS_OF_MEASURE_VL mum' || fnd_global.newline ||
642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||
647: ' AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause
648: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
649: ORDER BY rnk' ;

Line 646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||

642: ',' || ' ENI_ITEM_V eiov' || fnd_global.newline ||
643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||
647: ' AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause
648: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
649: ORDER BY rnk' ;
650:

Line 647: ' AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause

643: ' WHERE fact.dbi_date_closed BETWEEN &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline ||
644: ' AND fact.item_org_id = eiov.id' || fnd_global.newline ||
645: ' AND fact.repair_line_id = fact1.repair_line_id' || fnd_global.newline ||
646: ' AND fact1.time_to_repair >= 0' || fnd_global.newline ||
647: ' AND mum.uom_code = fact.uom_code' || fnd_global.newline || l_where_clause
648: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
649: ORDER BY rnk' ;
650:
651: RETURN l_sel_clause;

Line 801: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

797:
798: l_drill_down_rep_1 := get_drill_down (p_view_by_dim => p_view_by_dim, p_function_name =>'ISC_DEPOT_MTTR_DIST_TBL_REP');
799:
800: l_sel_clause :=
801: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
802: l_description || ' BIV_ATTRIBUTE10
803: ,BIV_MEASURE11
804: ,BIV_MEASURE1
805: ,BIV_MEASURE2

Line 820: ) || fnd_global.newline ;

816: , p_alias_name => 'BIV_MEASURE5'
817: , p_total_flag => 'N'
818: , p_prefix => NULL
819: , p_suffix => NULL
820: ) || fnd_global.newline ;
821:
822: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
823: , p_col_name => 'BIV_MEASURE25'
824: , p_alias_name => 'BIV_MEASURE25'

Line 828: ) || fnd_global.newline ;

824: , p_alias_name => 'BIV_MEASURE25'
825: , p_total_flag => 'N'
826: , p_prefix => NULL
827: , p_suffix => NULL
828: ) || fnd_global.newline ;
829: l_sel_clause := l_sel_clause || ' ,'||l_drill_down_rep_1||' BIV_DYNAMIC_URL1' || fnd_global.newline;
830:
831: l_sel_clause := l_sel_clause ||
832: 'FROM ( SELECT rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||' ) - 1 rnk

Line 829: l_sel_clause := l_sel_clause || ' ,'||l_drill_down_rep_1||' BIV_DYNAMIC_URL1' || fnd_global.newline;

825: , p_total_flag => 'N'
826: , p_prefix => NULL
827: , p_suffix => NULL
828: ) || fnd_global.newline ;
829: l_sel_clause := l_sel_clause || ' ,'||l_drill_down_rep_1||' BIV_DYNAMIC_URL1' || fnd_global.newline;
830:
831: l_sel_clause := l_sel_clause ||
832: 'FROM ( SELECT rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||' ) - 1 rnk
833: ,'||p_view_by_col||'

Line 851: ) || fnd_global.newline ;

847: , p_alias_name => 'BIV_MEASURE5'
848: , p_total_flag => 'N'
849: , p_prefix => NULL
850: , p_suffix => NULL
851: ) || fnd_global.newline ;
852:
853: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
854: , p_col_name => 'BIV_MEASURE25'
855: , p_alias_name => 'BIV_MEASURE25'

Line 859: ) || fnd_global.newline ;

855: , p_alias_name => 'BIV_MEASURE25'
856: , p_total_flag => 'N'
857: , p_prefix => NULL
858: , p_suffix => NULL
859: ) || fnd_global.newline ;
860:
861: l_sel_clause := l_sel_clause || 'FROM ( SELECT ' || fnd_global.newline ||
862: p_view_by_col || fnd_global.newline ||
863: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

Line 861: l_sel_clause := l_sel_clause || 'FROM ( SELECT ' || fnd_global.newline ||

857: , p_prefix => NULL
858: , p_suffix => NULL
859: ) || fnd_global.newline ;
860:
861: l_sel_clause := l_sel_clause || 'FROM ( SELECT ' || fnd_global.newline ||
862: p_view_by_col || fnd_global.newline ||
863: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
864: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'

Line 862: p_view_by_col || fnd_global.newline ||

858: , p_suffix => NULL
859: ) || fnd_global.newline ;
860:
861: l_sel_clause := l_sel_clause || 'FROM ( SELECT ' || fnd_global.newline ||
862: p_view_by_col || fnd_global.newline ||
863: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
864: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
866: ,prior_col => 'p_ro_count'

Line 863: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

859: ) || fnd_global.newline ;
860:
861: l_sel_clause := l_sel_clause || 'FROM ( SELECT ' || fnd_global.newline ||
862: p_view_by_col || fnd_global.newline ||
863: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
864: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
866: ,prior_col => 'p_ro_count'
867: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 864: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

860:
861: l_sel_clause := l_sel_clause || 'FROM ( SELECT ' || fnd_global.newline ||
862: p_view_by_col || fnd_global.newline ||
863: ',' || 'NVL(p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
864: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
866: ,prior_col => 'p_ro_count'
867: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
868: || 'BIV_MEASURE2' || fnd_global.newline ||

Line 868: || 'BIV_MEASURE2' || fnd_global.newline ||

864: ',' || 'NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
866: ,prior_col => 'p_ro_count'
867: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
868: || 'BIV_MEASURE2' || fnd_global.newline ||
869: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
870: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
871: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
872: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'

Line 869: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||

865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
866: ,prior_col => 'p_ro_count'
867: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
868: || 'BIV_MEASURE2' || fnd_global.newline ||
869: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
870: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
871: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
872: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
873: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 870: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||

866: ,prior_col => 'p_ro_count'
867: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
868: || 'BIV_MEASURE2' || fnd_global.newline ||
869: ',' || '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
870: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
871: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
872: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
873: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
874: || 'BIV_MEASURE4' || fnd_global.newline ||

Line 874: || 'BIV_MEASURE4' || fnd_global.newline ||

870: ',' || '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
871: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
872: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
873: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
874: || 'BIV_MEASURE4' || fnd_global.newline ||
875: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
876: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
877: ,prior_col => 'p_ro_count_total'
878: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 875: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||

871: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'
872: ,prior_col => '(p_time_to_repair/(decode(p_ro_count,0,to_number(NULL),p_ro_count)))'
873: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
874: || 'BIV_MEASURE4' || fnd_global.newline ||
875: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
876: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
877: ,prior_col => 'p_ro_count_total'
878: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
879: || 'BIV_MEASURE22' || fnd_global.newline ||

Line 879: || 'BIV_MEASURE22' || fnd_global.newline ||

875: ',' || 'NVL(c_ro_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
876: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
877: ,prior_col => 'p_ro_count_total'
878: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
879: || 'BIV_MEASURE22' || fnd_global.newline ||
880: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||
881: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
882: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
883: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 880: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||

876: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
877: ,prior_col => 'p_ro_count_total'
878: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
879: || 'BIV_MEASURE22' || fnd_global.newline ||
880: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||
881: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
882: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
883: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
884: || 'BIV_MEASURE24' || fnd_global.newline;

Line 884: || 'BIV_MEASURE24' || fnd_global.newline;

880: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE23 ' || fnd_global.newline ||
881: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'
882: ,prior_col => '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total)))'
883: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
884: || 'BIV_MEASURE24' || fnd_global.newline;
885:
886: l_sel_clause := l_sel_clause ||
887: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
888: , p_col_name => '(100/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) * c_ttr_distribution'

Line 893: ) || fnd_global.newline ;

889: , p_alias_name => 'BIV_MEASURE5'
890: , p_total_flag => 'N'
891: , p_prefix => NULL
892: , p_suffix => NULL
893: ) || fnd_global.newline ;
894:
895: l_sel_clause := l_sel_clause ||
896: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
897: , p_col_name => '(100/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) * c_ttr_distribution'

Line 902: ) || fnd_global.newline ;

898: , p_alias_name => 'BIV_MEASURE25'
899: , p_total_flag => 'Y'
900: , p_prefix => NULL
901: , p_suffix => NULL
902: ) || fnd_global.newline ;
903:
904: RETURN l_sel_clause;
905:
906: END GET_MTTR_DIST_TBL_SEL_CLAUSE;

Line 1042: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||

1038: l_description VARCHAR2(30);
1039:
1040: BEGIN
1041: l_sel_clause :=
1042: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
1043: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
1044: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1045: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
1046: ,prior_col => 'iset.p_ro_count'

Line 1043: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

1039:
1040: BEGIN
1041: l_sel_clause :=
1042: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
1043: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
1044: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1045: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
1046: ,prior_col => 'iset.p_ro_count'
1047: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 1044: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

1040: BEGIN
1041: l_sel_clause :=
1042: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
1043: ',' || 'NVL(iset.p_ro_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
1044: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1045: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
1046: ,prior_col => 'iset.p_ro_count'
1047: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1048: || 'BIV_MEASURE2' || fnd_global.newline ||

Line 1048: || 'BIV_MEASURE2' || fnd_global.newline ||

1044: ',' || 'NVL(iset.c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1045: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
1046: ,prior_col => 'iset.p_ro_count'
1047: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1048: || 'BIV_MEASURE2' || fnd_global.newline ||
1049: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
1050: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
1051: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
1052: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'

Line 1049: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||

1045: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'
1046: ,prior_col => 'iset.p_ro_count'
1047: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1048: || 'BIV_MEASURE2' || fnd_global.newline ||
1049: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
1050: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
1051: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
1052: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'
1053: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 1050: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||

1046: ,prior_col => 'iset.p_ro_count'
1047: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1048: || 'BIV_MEASURE2' || fnd_global.newline ||
1049: ',' || '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count))) BIV_MEASURE12 ' || fnd_global.newline ||
1050: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
1051: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
1052: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'
1053: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
1054: || 'BIV_MEASURE4' || fnd_global.newline;

Line 1054: || 'BIV_MEASURE4' || fnd_global.newline;

1050: ',' || '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) BIV_MEASURE3 ' || fnd_global.newline ||
1051: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'
1052: ,prior_col => '(iset.p_time_to_repair/(decode(iset.p_ro_count,0,to_number(NULL),iset.p_ro_count)))'
1053: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
1054: || 'BIV_MEASURE4' || fnd_global.newline;
1055:
1056: l_sel_clause := l_sel_clause ||
1057: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
1058: , p_col_name =>'(100/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) * iset.c_ttr_distribution'

Line 1063: ) || fnd_global.newline ;

1059: , p_alias_name =>'BIV_MEASURE5'
1060: , p_total_flag =>'N'
1061: , p_prefix => NULL
1062: , p_suffix => NULL
1063: ) || fnd_global.newline ;
1064:
1065: RETURN l_sel_clause;
1066:
1067: END GET_MTTR_DIST_TRD_SEL_CLAUSE;

Line 1195: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||

1191: l_percent_total := '(c_ro_count_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) * 100';
1192:
1193:
1194: l_sel_clause :=
1195: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
1196: ' v.description BIV_ATTRIBUTE6 ' || fnd_global.newline ||
1197: ',BIV_MEASURE11
1198: ,BIV_MEASURE1
1199: ,BIV_MEASURE2

Line 1196: ' v.description BIV_ATTRIBUTE6 ' || fnd_global.newline ||

1192:
1193:
1194: l_sel_clause :=
1195: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
1196: ' v.description BIV_ATTRIBUTE6 ' || fnd_global.newline ||
1197: ',BIV_MEASURE11
1198: ,BIV_MEASURE1
1199: ,BIV_MEASURE2
1200: ,BIV_MEASURE12

Line 1203: ,BIV_MEASURE7' || fnd_global.newline ||

1199: ,BIV_MEASURE2
1200: ,BIV_MEASURE12
1201: ,BIV_MEASURE5
1202: ,BIV_MEASURE6
1203: ,BIV_MEASURE7' || fnd_global.newline ||
1204: 'FROM ( SELECT
1205: rank() over (&ORDER_BY_CLAUSE'||' nulls last ,'||p_view_by_col||' ) - 1 rnk
1206: ,'||p_view_by_col||'
1207: ,BIV_MEASURE11

Line 1213: ,BIV_MEASURE7' || fnd_global.newline ||

1209: ,BIV_MEASURE2
1210: ,BIV_MEASURE12
1211: ,BIV_MEASURE5
1212: ,BIV_MEASURE6
1213: ,BIV_MEASURE7' || fnd_global.newline ||
1214: 'FROM ( SELECT ' || fnd_global.newline ||
1215: p_view_by_col || fnd_global.newline ||
1216: ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||
1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

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

1210: ,BIV_MEASURE12
1211: ,BIV_MEASURE5
1212: ,BIV_MEASURE6
1213: ,BIV_MEASURE7' || fnd_global.newline ||
1214: 'FROM ( SELECT ' || fnd_global.newline ||
1215: p_view_by_col || fnd_global.newline ||
1216: ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||
1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'

Line 1215: p_view_by_col || fnd_global.newline ||

1211: ,BIV_MEASURE5
1212: ,BIV_MEASURE6
1213: ,BIV_MEASURE7' || fnd_global.newline ||
1214: 'FROM ( SELECT ' || fnd_global.newline ||
1215: p_view_by_col || fnd_global.newline ||
1216: ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||
1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
1219: ,prior_col => 'p_ro_count'

Line 1216: ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||

1212: ,BIV_MEASURE6
1213: ,BIV_MEASURE7' || fnd_global.newline ||
1214: 'FROM ( SELECT ' || fnd_global.newline ||
1215: p_view_by_col || fnd_global.newline ||
1216: ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||
1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
1219: ,prior_col => 'p_ro_count'
1220: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

1213: ,BIV_MEASURE7' || fnd_global.newline ||
1214: 'FROM ( SELECT ' || fnd_global.newline ||
1215: p_view_by_col || fnd_global.newline ||
1216: ',' || ' NVL(p_ro_count,0) BIV_MEASURE11' || fnd_global.newline ||
1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
1219: ,prior_col => 'p_ro_count'
1220: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1221: || ' BIV_MEASURE2' || fnd_global.newline ||

Line 1221: || ' BIV_MEASURE2' || fnd_global.newline ||

1217: ',' || ' NVL(c_ro_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
1219: ,prior_col => 'p_ro_count'
1220: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1221: || ' BIV_MEASURE2' || fnd_global.newline ||
1222: ',' || l_percent || ' BIV_MEASURE12' || fnd_global.newline ||
1223: ',' || ' NVL(c_ro_count_total,0) BIV_MEASURE5 ' || fnd_global.newline ||
1224: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
1225: ,prior_col => 'p_ro_count_total'

Line 1222: ',' || l_percent || ' BIV_MEASURE12' || fnd_global.newline ||

1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'
1219: ,prior_col => 'p_ro_count'
1220: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1221: || ' BIV_MEASURE2' || fnd_global.newline ||
1222: ',' || l_percent || ' BIV_MEASURE12' || fnd_global.newline ||
1223: ',' || ' NVL(c_ro_count_total,0) BIV_MEASURE5 ' || fnd_global.newline ||
1224: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
1225: ,prior_col => 'p_ro_count_total'
1226: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 1223: ',' || ' NVL(c_ro_count_total,0) BIV_MEASURE5 ' || fnd_global.newline ||

1219: ,prior_col => 'p_ro_count'
1220: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1221: || ' BIV_MEASURE2' || fnd_global.newline ||
1222: ',' || l_percent || ' BIV_MEASURE12' || fnd_global.newline ||
1223: ',' || ' NVL(c_ro_count_total,0) BIV_MEASURE5 ' || fnd_global.newline ||
1224: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
1225: ,prior_col => 'p_ro_count_total'
1226: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1227: || ' BIV_MEASURE6' || fnd_global.newline ||

Line 1227: || ' BIV_MEASURE6' || fnd_global.newline ||

1223: ',' || ' NVL(c_ro_count_total,0) BIV_MEASURE5 ' || fnd_global.newline ||
1224: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
1225: ,prior_col => 'p_ro_count_total'
1226: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1227: || ' BIV_MEASURE6' || fnd_global.newline ||
1228: ',' || l_percent_total || ' BIV_MEASURE7' || fnd_global.newline ;
1229:
1230: RETURN l_sel_clause;
1231:

Line 1228: ',' || l_percent_total || ' BIV_MEASURE7' || fnd_global.newline ;

1224: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'
1225: ,prior_col => 'p_ro_count_total'
1226: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
1227: || ' BIV_MEASURE6' || fnd_global.newline ||
1228: ',' || l_percent_total || ' BIV_MEASURE7' || fnd_global.newline ;
1229:
1230: RETURN l_sel_clause;
1231:
1232: END GET_SRVC_TBL_SEL_CLAUSE;