APPS.ISC_DEPOT_COMPLETION_PKG dependencies on FND_GLOBAL

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

168: l_drill_across_rep_2 := '''pFunctionName=ISC_DEPOT_COMP_DTL_TBL_REP&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ITEM+ENI_ITEM&pParamIds=Y''';
169: END IF;
170:
171: l_sel_clause :=
172: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
173: l_description || ' BIV_ATTRIBUTE1
174: ,BIV_MEASURE1
175: ,BIV_MEASURE11
176: ,BIV_MEASURE2

Line 202: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||

198: ,BIV_MEASURE34
199: ,BIV_MEASURE35
200: ,BIV_MEASURE36
201: ,' || l_drill_across_rep_1 || ' BIV_DYNAMIC_URL1
202: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||
203: 'FROM ( SELECT
204: rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||' ) - 1 rnk
205: ,'||p_view_by_col||'
206: ,BIV_MEASURE1

Line 233: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||

229: ,BIV_MEASURE33
230: ,BIV_MEASURE34
231: ,BIV_MEASURE35
232: ,BIV_MEASURE36
233: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||
234: ' FROM ( SELECT ' || fnd_global.newline ||
235: p_view_by_col || fnd_global.newline ||
236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

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

230: ,BIV_MEASURE34
231: ,BIV_MEASURE35
232: ,BIV_MEASURE36
233: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||
234: ' FROM ( SELECT ' || fnd_global.newline ||
235: p_view_by_col || fnd_global.newline ||
236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'

Line 235: p_view_by_col || fnd_global.newline ||

231: ,BIV_MEASURE35
232: ,BIV_MEASURE36
233: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||
234: ' FROM ( SELECT ' || fnd_global.newline ||
235: p_view_by_col || fnd_global.newline ||
236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
239: ,prior_col => 'p_completed_count'

Line 236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

232: ,BIV_MEASURE36
233: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||
234: ' FROM ( SELECT ' || fnd_global.newline ||
235: p_view_by_col || fnd_global.newline ||
236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
239: ,prior_col => 'p_completed_count'
240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

233: ,BIV_DYNAMIC_URL_2 ' || fnd_global.newline ||
234: ' FROM ( SELECT ' || fnd_global.newline ||
235: p_view_by_col || fnd_global.newline ||
236: ',' || 'NVL(c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
239: ,prior_col => 'p_completed_count'
240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
241: || ' BIV_MEASURE2' || fnd_global.newline ||

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

237: ',' || 'NVL(p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
239: ,prior_col => 'p_completed_count'
240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
241: || ' BIV_MEASURE2' || fnd_global.newline ||
242: ',' || 'NVL(c_cmplt_with_prom_dt,0) BIV_MEASURE3 ' || fnd_global.newline ||
243: ',' || 'NVL(c_late_complete_count,0) BIV_MEASURE4 ' || fnd_global.newline ||
244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
245: ,denominator => 'c_completed_count'

Line 242: ',' || 'NVL(c_cmplt_with_prom_dt,0) BIV_MEASURE3 ' || fnd_global.newline ||

238: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
239: ,prior_col => 'p_completed_count'
240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
241: || ' BIV_MEASURE2' || fnd_global.newline ||
242: ',' || 'NVL(c_cmplt_with_prom_dt,0) BIV_MEASURE3 ' || fnd_global.newline ||
243: ',' || 'NVL(c_late_complete_count,0) BIV_MEASURE4 ' || fnd_global.newline ||
244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
245: ,denominator => 'c_completed_count'
246: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 243: ',' || 'NVL(c_late_complete_count,0) BIV_MEASURE4 ' || fnd_global.newline ||

239: ,prior_col => 'p_completed_count'
240: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
241: || ' BIV_MEASURE2' || fnd_global.newline ||
242: ',' || 'NVL(c_cmplt_with_prom_dt,0) BIV_MEASURE3 ' || fnd_global.newline ||
243: ',' || 'NVL(c_late_complete_count,0) BIV_MEASURE4 ' || fnd_global.newline ||
244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
245: ,denominator => 'c_completed_count'
246: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
247: || 'BIV_MEASURE5' || fnd_global.newline ||

Line 247: || 'BIV_MEASURE5' || fnd_global.newline ||

243: ',' || 'NVL(c_late_complete_count,0) BIV_MEASURE4 ' || fnd_global.newline ||
244: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
245: ,denominator => 'c_completed_count'
246: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
247: || 'BIV_MEASURE5' || fnd_global.newline ||
248: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
249: ,denominator => 'p_completed_count'
250: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
251: || ' BIV_MEASURE12' || fnd_global.newline ||

Line 251: || ' BIV_MEASURE12' || fnd_global.newline ||

247: || 'BIV_MEASURE5' || fnd_global.newline ||
248: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
249: ,denominator => 'p_completed_count'
250: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
251: || ' BIV_MEASURE12' || fnd_global.newline ||
252: ',' || OPI_DBI_RPT_UTIL_PKG.change_pct_str(p_new_numerator => 'c_late_complete_count',
253: p_new_denominator => 'c_completed_count',
254: p_old_numerator => 'p_late_complete_count',
255: p_old_denominator => 'p_completed_count',

Line 257: || fnd_global.newline ||

253: p_new_denominator => 'c_completed_count',
254: p_old_numerator => 'p_late_complete_count',
255: p_old_denominator => 'p_completed_count',
256: p_measure_name => 'BIV_MEASURE6')
257: || fnd_global.newline ||
258: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
259: ,denominator => 'c_late_complete_count'
260: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
261: || ' BIV_MEASURE7' || fnd_global.newline ||

Line 261: || ' BIV_MEASURE7' || fnd_global.newline ||

257: || fnd_global.newline ||
258: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
259: ,denominator => 'c_late_complete_count'
260: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
261: || ' BIV_MEASURE7' || fnd_global.newline ||
262: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
263: ,denominator => 'p_late_complete_count'
264: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
265: || ' BIV_MEASURE13' || fnd_global.newline ||

Line 265: || ' BIV_MEASURE13' || fnd_global.newline ||

261: || ' BIV_MEASURE7' || fnd_global.newline ||
262: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
263: ,denominator => 'p_late_complete_count'
264: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
265: || ' BIV_MEASURE13' || fnd_global.newline ||
266: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
267: ,denominator => 'c_late_complete_count'
268: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
269: || ' - '

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

269: || ' - '
270: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
271: ,denominator => 'p_late_complete_count'
272: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || ' BIV_MEASURE8' || fnd_global.newline ||
274: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
275: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count_total'
276: ,prior_col => 'p_completed_count_total'
277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 274: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||

270: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
271: ,denominator => 'p_late_complete_count'
272: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
273: || ' BIV_MEASURE8' || fnd_global.newline ||
274: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
275: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count_total'
276: ,prior_col => 'p_completed_count_total'
277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
278: || 'BIV_MEASURE22' || fnd_global.newline ||

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

274: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
275: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count_total'
276: ,prior_col => 'p_completed_count_total'
277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
278: || 'BIV_MEASURE22' || fnd_global.newline ||
279: ',' || 'NVL(c_cmplt_with_prom_dt_total,0) BIV_MEASURE23 ' || fnd_global.newline ||
280: ',' || 'NVL(c_late_complete_count_total,0) BIV_MEASURE24 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
282: ,denominator => 'c_completed_count_total'

Line 279: ',' || 'NVL(c_cmplt_with_prom_dt_total,0) BIV_MEASURE23 ' || fnd_global.newline ||

275: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count_total'
276: ,prior_col => 'p_completed_count_total'
277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
278: || 'BIV_MEASURE22' || fnd_global.newline ||
279: ',' || 'NVL(c_cmplt_with_prom_dt_total,0) BIV_MEASURE23 ' || fnd_global.newline ||
280: ',' || 'NVL(c_late_complete_count_total,0) BIV_MEASURE24 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
282: ,denominator => 'c_completed_count_total'
283: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 280: ',' || 'NVL(c_late_complete_count_total,0) BIV_MEASURE24 ' || fnd_global.newline ||

276: ,prior_col => 'p_completed_count_total'
277: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
278: || 'BIV_MEASURE22' || fnd_global.newline ||
279: ',' || 'NVL(c_cmplt_with_prom_dt_total,0) BIV_MEASURE23 ' || fnd_global.newline ||
280: ',' || 'NVL(c_late_complete_count_total,0) BIV_MEASURE24 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
282: ,denominator => 'c_completed_count_total'
283: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
284: || 'BIV_MEASURE25' || fnd_global.newline ||

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

280: ',' || 'NVL(c_late_complete_count_total,0) BIV_MEASURE24 ' || fnd_global.newline ||
281: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
282: ,denominator => 'c_completed_count_total'
283: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
284: || 'BIV_MEASURE25' || fnd_global.newline ||
285: ',' || OPI_DBI_RPT_UTIL_PKG.change_pct_str(p_new_numerator => 'c_late_complete_count_total',
286: p_new_denominator => 'c_completed_count_total',
287: p_old_numerator => 'p_late_complete_count_total',
288: p_old_denominator => 'p_completed_count_total',

Line 290: || fnd_global.newline ||

286: p_new_denominator => 'c_completed_count_total',
287: p_old_numerator => 'p_late_complete_count_total',
288: p_old_denominator => 'p_completed_count_total',
289: p_measure_name => 'BIV_MEASURE26')
290: || fnd_global.newline ||
291: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
292: ,denominator => 'c_late_complete_count_total'
293: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
294: || ' BIV_MEASURE27' || fnd_global.newline ||

Line 294: || ' BIV_MEASURE27' || fnd_global.newline ||

290: || fnd_global.newline ||
291: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
292: ,denominator => 'c_late_complete_count_total'
293: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
294: || ' BIV_MEASURE27' || fnd_global.newline ||
295: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late_total'
296: ,denominator => 'c_late_complete_count_total'
297: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
298: || ' - '

Line 302: || ' BIV_MEASURE28' || fnd_global.newline ||

298: || ' - '
299: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late_total'
300: ,denominator => 'p_late_complete_count_total'
301: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
302: || ' BIV_MEASURE28' || fnd_global.newline ||
303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||
304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||
305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||
306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||

Line 303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||

299: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late_total'
300: ,denominator => 'p_late_complete_count_total'
301: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
302: || ' BIV_MEASURE28' || fnd_global.newline ||
303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||
304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||
305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||
306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||
307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'

Line 304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||

300: ,denominator => 'p_late_complete_count_total'
301: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
302: || ' BIV_MEASURE28' || fnd_global.newline ||
303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||
304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||
305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||
306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||
307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
308: ,denominator => 'c_completed_count'

Line 305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||

301: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
302: || ' BIV_MEASURE28' || fnd_global.newline ||
303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||
304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||
305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||
306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||
307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
308: ,denominator => 'c_completed_count'
309: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||

302: || ' BIV_MEASURE28' || fnd_global.newline ||
303: ',' || 'NVL(c_completed_count,0) BIV_MEASURE29 ' || fnd_global.newline ||
304: ',' || 'NVL(p_completed_count,0) BIV_MEASURE30 ' || fnd_global.newline ||
305: ',' || 'NVL(c_completed_count_total,0) BIV_MEASURE31 ' || fnd_global.newline ||
306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||
307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
308: ,denominator => 'c_completed_count'
309: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
310: || 'BIV_MEASURE33' || fnd_global.newline ||

Line 310: || 'BIV_MEASURE33' || fnd_global.newline ||

306: ',' || 'NVL(p_completed_count_total,0) BIV_MEASURE32 ' || fnd_global.newline ||
307: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
308: ,denominator => 'c_completed_count'
309: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
310: || 'BIV_MEASURE33' || fnd_global.newline ||
311: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
312: ,denominator => 'p_completed_count'
313: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
314: || 'BIV_MEASURE34' || fnd_global.newline ||

Line 314: || 'BIV_MEASURE34' || fnd_global.newline ||

310: || 'BIV_MEASURE33' || fnd_global.newline ||
311: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
312: ,denominator => 'p_completed_count'
313: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
314: || 'BIV_MEASURE34' || fnd_global.newline ||
315: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
316: ,denominator => 'c_completed_count_total'
317: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
318: || 'BIV_MEASURE35' || fnd_global.newline ||

Line 318: || 'BIV_MEASURE35' || fnd_global.newline ||

314: || 'BIV_MEASURE34' || fnd_global.newline ||
315: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count_total'
316: ,denominator => 'c_completed_count_total'
317: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
318: || 'BIV_MEASURE35' || fnd_global.newline ||
319: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count_total'
320: ,denominator => 'p_completed_count_total'
321: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
322: || 'BIV_MEASURE36' || fnd_global.newline ||

Line 322: || 'BIV_MEASURE36' || fnd_global.newline ||

318: || 'BIV_MEASURE35' || fnd_global.newline ||
319: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count_total'
320: ,denominator => 'p_completed_count_total'
321: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
322: || 'BIV_MEASURE36' || fnd_global.newline ||
323: ',' || l_drill_across_rep_2 || ' BIV_DYNAMIC_URL_2 ' || fnd_global.newline;
324: RETURN l_sel_clause;
325:
326: END GET_COMPLETION_TBL_SEL_CLAUSE;

Line 323: ',' || l_drill_across_rep_2 || ' BIV_DYNAMIC_URL_2 ' || fnd_global.newline;

319: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count_total'
320: ,denominator => 'p_completed_count_total'
321: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
322: || 'BIV_MEASURE36' || fnd_global.newline ||
323: ',' || l_drill_across_rep_2 || ' BIV_DYNAMIC_URL_2 ' || fnd_global.newline;
324: RETURN l_sel_clause;
325:
326: END GET_COMPLETION_TBL_SEL_CLAUSE;
327:

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

455: BEGIN
456: l_description := 'null';
457:
458: l_sel_clause :=
459: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
460: ',' || 'NVL(iset.c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
461: ',' || 'NVL(iset.p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
463: ,prior_col => 'p_completed_count'

Line 460: ',' || 'NVL(iset.c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||

456: l_description := 'null';
457:
458: l_sel_clause :=
459: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
460: ',' || 'NVL(iset.c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
461: ',' || 'NVL(iset.p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
463: ,prior_col => 'p_completed_count'
464: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent

Line 461: ',' || 'NVL(iset.p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||

457:
458: l_sel_clause :=
459: 'SELECT cal.name VIEWBY ' || fnd_global.newline ||
460: ',' || 'NVL(iset.c_completed_count,0) BIV_MEASURE1 ' || fnd_global.newline ||
461: ',' || 'NVL(iset.p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
463: ,prior_col => 'p_completed_count'
464: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
465: || ' BIV_MEASURE2' || fnd_global.newline ||

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

461: ',' || 'NVL(iset.p_completed_count,0) BIV_MEASURE11 ' || fnd_global.newline ||
462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
463: ,prior_col => 'p_completed_count'
464: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
465: || ' BIV_MEASURE2' || fnd_global.newline ||
466: ',' || 'NVL(iset.c_late_complete_count,0) BIV_MEASURE3 ' || fnd_global.newline ||
467: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
468: ,denominator => 'c_completed_count'
469: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent

Line 466: ',' || 'NVL(iset.c_late_complete_count,0) BIV_MEASURE3 ' || fnd_global.newline ||

462: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_completed_count'
463: ,prior_col => 'p_completed_count'
464: ,change_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
465: || ' BIV_MEASURE2' || fnd_global.newline ||
466: ',' || 'NVL(iset.c_late_complete_count,0) BIV_MEASURE3 ' || fnd_global.newline ||
467: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
468: ,denominator => 'c_completed_count'
469: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
470: || 'BIV_MEASURE4' || fnd_global.newline ||

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

466: ',' || 'NVL(iset.c_late_complete_count,0) BIV_MEASURE3 ' || fnd_global.newline ||
467: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_late_complete_count'
468: ,denominator => 'c_completed_count'
469: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
470: || 'BIV_MEASURE4' || fnd_global.newline ||
471: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
472: ,denominator => 'p_completed_count'
473: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
474: || ' BIV_MEASURE12' || fnd_global.newline ||

Line 474: || ' BIV_MEASURE12' || fnd_global.newline ||

470: || 'BIV_MEASURE4' || fnd_global.newline ||
471: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_late_complete_count'
472: ,denominator => 'p_completed_count'
473: ,rate_type => 'P') -- 'P' for Percent ; 'NP' for non percent
474: || ' BIV_MEASURE12' || fnd_global.newline ||
475: ',' || OPI_DBI_RPT_UTIL_PKG.change_pct_str(p_new_numerator => 'c_late_complete_count',
476: p_new_denominator => 'c_completed_count',
477: p_old_numerator => 'p_late_complete_count',
478: p_old_denominator => 'p_completed_count',

Line 480: || fnd_global.newline ||

476: p_new_denominator => 'c_completed_count',
477: p_old_numerator => 'p_late_complete_count',
478: p_old_denominator => 'p_completed_count',
479: p_measure_name => 'BIV_MEASURE5')
480: || fnd_global.newline ||
481: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
482: ,denominator => 'c_late_complete_count'
483: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
484: || ' BIV_MEASURE6' || fnd_global.newline ||

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

480: || fnd_global.newline ||
481: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
482: ,denominator => 'c_late_complete_count'
483: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
484: || ' BIV_MEASURE6' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
486: ,denominator => 'p_late_complete_count'
487: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
488: || ' BIV_MEASURE13' || fnd_global.newline ||

Line 488: || ' BIV_MEASURE13' || fnd_global.newline ||

484: || ' BIV_MEASURE6' || fnd_global.newline ||
485: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
486: ,denominator => 'p_late_complete_count'
487: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
488: || ' BIV_MEASURE13' || fnd_global.newline ||
489: ',' || poa_dbi_util_pkg.rate_clause( numerator => 'c_days_late'
490: ,denominator => 'c_late_complete_count'
491: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
492: || ' - '

Line 496: || ' BIV_MEASURE7' || fnd_global.newline;

492: || ' - '
493: || poa_dbi_util_pkg.rate_clause( numerator => 'p_days_late'
494: ,denominator => 'p_late_complete_count'
495: ,rate_type => 'NP') -- 'P' for Percent ; 'NP' for non percent
496: || ' BIV_MEASURE7' || fnd_global.newline;
497: RETURN l_sel_clause;
498:
499: END GET_COMPLETION_TRD_SEL_CLAUSE;
500:

Line 588: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||

584: ,BIV_DATE2
585: ,BIV_MEASURE2
586: ,BIV_MEASURE3
587: FROM (
588: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||

Line 589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||

585: ,BIV_MEASURE2
586: ,BIV_MEASURE3
587: FROM (
588: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||

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

586: ,BIV_MEASURE3
587: FROM (
588: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||

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

587: FROM (
588: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||

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

588: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||

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

589: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||

Line 594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||

590: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||

Line 595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||

591: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||

Line 596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||

592: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline

Line 597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||

593: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline

Line 598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||

594: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline

Line 599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||

595: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline

Line 600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline

596: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline

Line 601: || ' from ' || fnd_global.newline

597: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline

Line 602: || l_mv || fnd_global.newline

598: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline

Line 603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline

599: ',' || ' fact.repair_line_id BIV_MEASURE2 ' || fnd_global.newline ||
600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline

Line 604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline

600: ',' || ' fact.master_organization_id BIV_MEASURE3 ' || fnd_global.newline
601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline

Line 605: || ' FND_LOOKUPS FL, ' || fnd_global.newline

601: || ' from ' || fnd_global.newline
602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline

Line 606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline

602: || l_mv || fnd_global.newline
603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline

Line 607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline

603: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline

Line 608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline

604: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
612: || l_where_clause || fnd_global.newline

Line 609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline

605: || ' FND_LOOKUPS FL, ' || fnd_global.newline
606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
612: || l_where_clause || fnd_global.newline
613: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)

Line 610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline

606: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
612: || l_where_clause || fnd_global.newline
613: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
614: ORDER BY rnk' || fnd_global.newline ;

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

607: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
612: || l_where_clause || fnd_global.newline
613: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
614: ORDER BY rnk' || fnd_global.newline ;
615:

Line 612: || l_where_clause || fnd_global.newline

608: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
609: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
612: || l_where_clause || fnd_global.newline
613: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
614: ORDER BY rnk' || fnd_global.newline ;
615:
616: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN

Line 614: ORDER BY rnk' || fnd_global.newline ;

610: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
611: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
612: || l_where_clause || fnd_global.newline
613: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
614: ORDER BY rnk' || fnd_global.newline ;
615:
616: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
617: l_err_stage:='The query is : ' || l_query;
618: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);

Line 720: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||

716: ,BIV_MEASURE2
717: ,BIV_MEASURE3
718: ,BIV_MEASURE4
719: FROM (
720: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||

Line 721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||

717: ,BIV_MEASURE3
718: ,BIV_MEASURE4
719: FROM (
720: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||

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

718: ,BIV_MEASURE4
719: FROM (
720: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||

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

719: FROM (
720: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||

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

720: SELECT repair_number BIV_ATTRIBUTE1 ' || fnd_global.newline ||
721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||

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

721: ',' || ' incident_number BIV_ATTRIBUTE2 ' || fnd_global.newline ||
722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||

Line 726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||

722: ',' || ' crt.name BIV_ATTRIBUTE3 ' || fnd_global.newline ||
723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||

Line 727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||

723: ',' || ' eiov.value BIV_ATTRIBUTE4 ' || fnd_global.newline ||
724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||

Line 728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||

724: ',' || ' eiov.description BIV_ATTRIBUTE5 ' || fnd_global.newline ||
725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||

Line 729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||

725: ',' || ' mum.unit_of_measure BIV_ATTRIBUTE6 ' || fnd_global.newline ||
726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline

Line 730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||

726: ',' || ' quantity BIV_MEASURE1 ' || fnd_global.newline ||
727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline

Line 731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||

727: ',' || ' serial_number BIV_ATTRIBUTE7 ' || fnd_global.newline ||
728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline

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

728: ',' || ' incident_id BIV_ATTRIBUTE8 ' || fnd_global.newline ||
729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline

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

729: ',' || ' promise_date BIV_DATE1 ' || fnd_global.newline ||
730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline

Line 734: || ' from ' || fnd_global.newline

730: ',' || ' date_closed BIV_DATE2 ' || fnd_global.newline ||
731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline

Line 735: || l_mv || fnd_global.newline

731: ',' || ' trunc(date_closed) - trunc(promise_date) BIV_MEASURE2 ' || fnd_global.newline ||
732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline

Line 736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline

732: ',' || ' fact.repair_line_id BIV_MEASURE3 ' || fnd_global.newline ||
733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline

Line 737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline

733: ',' || ' fact.master_organization_id BIV_MEASURE4 ' || fnd_global.newline
734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline

Line 738: || ' FND_LOOKUPS FL, ' || fnd_global.newline

734: || ' from ' || fnd_global.newline
735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline

Line 739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline

735: || l_mv || fnd_global.newline
736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline

Line 740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline

736: || ' ISC_DR_REPAIR_ORDERS_F fact, ' || fnd_global.newline
737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline

Line 741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline

737: || ' ENI_ITEM_V EIOV, ' || fnd_global.newline
738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline

Line 742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline

738: || ' FND_LOOKUPS FL, ' || fnd_global.newline
739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
746: || l_where_clause || fnd_global.newline

Line 743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline

739: || ' MTL_UNITS_OF_MEASURE_VL MUM ' || fnd_global.newline
740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
746: || l_where_clause || fnd_global.newline
747: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)

Line 744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline

740: || ' WHERE dbi_date_closed between &BIS_CURRENT_EFFECTIVE_START_DATE and &BIS_CURRENT_ASOF_DATE ' || fnd_global.newline
741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
746: || l_where_clause || fnd_global.newline
747: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
748: ORDER BY rnk' || fnd_global.newline ;

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

741: || ' AND dbi_date_closed > fact.promise_date ' || fnd_global.newline
742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
746: || l_where_clause || fnd_global.newline
747: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
748: ORDER BY rnk' || fnd_global.newline ;
749: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN

Line 746: || l_where_clause || fnd_global.newline

742: || ' AND FL.LOOKUP_TYPE = ''CSD_REPAIR_STATUS'' ' || fnd_global.newline
743: || ' AND FL.LOOKUP_CODE = fact.status ' || fnd_global.newline
744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
746: || l_where_clause || fnd_global.newline
747: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
748: ORDER BY rnk' || fnd_global.newline ;
749: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
750: l_err_stage:='The query is : ' || l_query;

Line 748: ORDER BY rnk' || fnd_global.newline ;

744: || ' AND FACT.item_org_id = eiov.id ' || fnd_global.newline
745: || ' AND mum.uom_code = fact.uom_code ' || fnd_global.newline
746: || l_where_clause || fnd_global.newline
747: || ' ) ) where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)
748: ORDER BY rnk' || fnd_global.newline ;
749: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
750: l_err_stage:='The query is : ' || l_query;
751: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_LAT_COMP_DTL : ',l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
752: END IF;

Line 817: l_query := ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||

813: l_err_stage:='After calling DRM_DBI_RPT_UTIL_PKG.process_parameters';
814: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
815: END IF;
816:
817: l_query := ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||
818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||
819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||
820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'
821: ,prior_col => 'p_LATE_COMPLETE_COUNT'

Line 818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||

814: ISC_DEPOT_RPT_UTIL_PKG.write('BIS_ISC_DEPOT_COMPLETION_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG.C_DEBUG_LEVEL);
815: END IF;
816:
817: l_query := ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||
818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||
819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||
820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'
821: ,prior_col => 'p_LATE_COMPLETE_COUNT'
822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||

Line 819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||

815: END IF;
816:
817: l_query := ' SELECT range_name BIV_ATTRIBUTE1 ' || fnd_global.newline ||
818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||
819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||
820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'
821: ,prior_col => 'p_LATE_COMPLETE_COUNT'
822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||
823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'

Line 822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||

818: ' ,nvl(c_LATE_COMPLETE_COUNT,0) BIV_MEASURE1 ' || fnd_global.newline ||
819: ' ,nvl(p_LATE_COMPLETE_COUNT,0) BIV_MEASURE11 ' || fnd_global.newline ||
820: ' ,' || poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT'
821: ,prior_col => 'p_LATE_COMPLETE_COUNT'
822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||
823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'
824: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||
826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||

Line 825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||

821: ,prior_col => 'p_LATE_COMPLETE_COUNT'
822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||
823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'
824: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||
826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'
828: ,prior_col => 'p_LATE_COMPLETE_COUNT_total'
829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||

Line 826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||

822: ,change_type => 'NP') || 'BIV_MEASURE2' || fnd_global.newline ||
823: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT'
824: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||
826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'
828: ,prior_col => 'p_LATE_COMPLETE_COUNT_total'
829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||
830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'

Line 829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||

825: ,rate_type => 'P') || 'BIV_MEASURE3' || fnd_global.newline ||
826: ' ,nvl(c_LATE_COMPLETE_COUNT_total,0) BIV_MEASURE21 ' || fnd_global.newline ||
827: ' ,'|| poa_dbi_util_pkg.change_clause(cur_col => 'c_LATE_COMPLETE_COUNT_total'
828: ,prior_col => 'p_LATE_COMPLETE_COUNT_total'
829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||
830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'
831: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||
833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||

Line 832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||

828: ,prior_col => 'p_LATE_COMPLETE_COUNT_total'
829: ,change_type => 'NP') || 'BIV_MEASURE22' || fnd_global.newline ||
830: ' ,'|| poa_dbi_util_pkg.rate_clause(numerator => 'c_LATE_COMPLETE_COUNT_TOTAL'
831: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||
833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||
834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||
835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

Line 835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||

831: ,denominator => 'c_LATE_COMPLETE_COUNT_TOTAL'
832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||
833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||
834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||
835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

Line 836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

832: ,rate_type => 'P') || 'BIV_MEASURE23' || fnd_global.newline ||
833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||
834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||
835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

Line 837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

833: -- ',' || 'ISC_DEPOT_COMPLETION_PKG.GET_BUCKET_DRILL_ACROSS_URL(''ISC_DEPOT_LAT_COMP_DTL_TBL_REP'', bucket_number)' || ' BIV_DYNAMIC_URL1 ' ||
834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||
835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

Line 838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||

834: ',' || '''pFunctionName=ISC_DEPOT_LAT_COMP_DTL_TBL_REP&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET=''|| bucket_number ||''''' || ' BIV_DYNAMIC_URL1 ' ||
835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

Line 839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

835: ' FROM (select sum (decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

Line 840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

836: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

Line 841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

837: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||

Line 842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

838: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||

Line 843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

839: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

Line 844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

840: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

Line 845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||

841: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||

Line 846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||

842: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

Line 847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

843: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

Line 848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

844: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

Line 849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||

845: ' ,10, days_late_age_b10 ))) c_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

Line 850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

846: ' ,sum (decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

Line 851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

847: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

Line 852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

848: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||

Line 853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

849: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||

Line 854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

850: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||

Line 855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

851: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

Line 856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||

852: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
853: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

Line 858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||

854: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

Line 859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

855: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

Line 860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

856: ' ,10, days_late_age_b10 ))) p_LATE_COMPLETE_COUNT ' || fnd_global.newline ||
857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

Line 861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||

857: -- ' ,0 c_LATE_COMPLETE_COUNT_total , 0 p_LATE_COMPLETE_COUNT_total ' ||
858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

Line 862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

858: ' ,sum (sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE, ' || fnd_global.newline ||
859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

Line 863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

859: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

Line 864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

860: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||

Line 865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

861: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||

Line 866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

862: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

Line 867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

863: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

Line 868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||

864: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||

Line 869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||

865: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

Line 870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||

866: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

Line 871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||

867: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

Line 872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||

868: ' ,10, days_late_age_b10 )))) over () c_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

Line 873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||

869: ' ,sum (sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE, ' || fnd_global.newline ||
870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

Line 874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||

870: ' decode (buckets.bucket_number, 1, days_late_age_b1 ' || fnd_global.newline ||
871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

Line 875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||

871: ' ,2, days_late_age_b2 ' || fnd_global.newline ||
872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||

Line 876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||

872: ' ,3, days_late_age_b3 ' || fnd_global.newline ||
873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
880: ' ,range_name ' || fnd_global.newline ||

Line 877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||

873: ' ,4, days_late_age_b4 ' || fnd_global.newline ||
874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
880: ' ,range_name ' || fnd_global.newline ||
881: ' ,buckets.bucket_number ' || fnd_global.newline ||

Line 878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||

874: ' ,5, days_late_age_b5 ' || fnd_global.newline ||
875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
880: ' ,range_name ' || fnd_global.newline ||
881: ' ,buckets.bucket_number ' || fnd_global.newline ||
882: ' from (';

Line 879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||

875: ' ,6, days_late_age_b6 ' || fnd_global.newline ||
876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
880: ' ,range_name ' || fnd_global.newline ||
881: ' ,buckets.bucket_number ' || fnd_global.newline ||
882: ' from (';
883: FOR i in 1..10 LOOP

Line 880: ' ,range_name ' || fnd_global.newline ||

876: ' ,7, days_late_age_b7 ' || fnd_global.newline ||
877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
880: ' ,range_name ' || fnd_global.newline ||
881: ' ,buckets.bucket_number ' || fnd_global.newline ||
882: ' from (';
883: FOR i in 1..10 LOOP
884: l_query := l_query ||

Line 881: ' ,buckets.bucket_number ' || fnd_global.newline ||

877: ' ,8, days_late_age_b8 ' || fnd_global.newline ||
878: ' ,9, days_late_age_b9 ' || fnd_global.newline ||
879: ' ,10, days_late_age_b10 )))) over () p_LATE_COMPLETE_COUNT_total ' || fnd_global.newline ||
880: ' ,range_name ' || fnd_global.newline ||
881: ' ,buckets.bucket_number ' || fnd_global.newline ||
882: ' from (';
883: FOR i in 1..10 LOOP
884: l_query := l_query ||
885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||

Line 885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||

881: ' ,buckets.bucket_number ' || fnd_global.newline ||
882: ' from (';
883: FOR i in 1..10 LOOP
884: l_query := l_query ||
885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||
886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||
887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||

Line 886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||

882: ' from (';
883: FOR i in 1..10 LOOP
884: l_query := l_query ||
885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||
886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||
887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||

Line 887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||

883: FOR i in 1..10 LOOP
884: l_query := l_query ||
885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||
886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||
887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||

Line 888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||

884: l_query := l_query ||
885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||
886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||
887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||

Line 889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||

885: 'SELECT '|| i || ' bucket_number, ' || fnd_global.newline ||
886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||
887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||

Line 890: ' bis_bucket bb, ' || fnd_global.newline ||

886: ' bbct.range'|| i ||'_name range_name, ' || fnd_global.newline ||
887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||

Line 891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||

887: ' bbc.range' || i || '_low range_low, ' || fnd_global.newline ||
888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||

Line 892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||

888: ' bbc.range' || i || '_high range_high ' || fnd_global.newline ||
889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||
896: ' and bbC.id = bbct.id '|| fnd_global.newline;

Line 893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||

889: 'FROM bis_bucket_customizations bbc, ' || fnd_global.newline ||
890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||
896: ' and bbC.id = bbct.id '|| fnd_global.newline;
897: IF i <> 10 THEN

Line 894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||

890: ' bis_bucket bb, ' || fnd_global.newline ||
891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||
896: ' and bbC.id = bbct.id '|| fnd_global.newline;
897: IF i <> 10 THEN
898: l_query := l_query || 'UNION ALL ' || fnd_global.newline;

Line 895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||

891: ' bis_bucket_customizations_tl bbct ' || fnd_global.newline ||
892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||
896: ' and bbC.id = bbct.id '|| fnd_global.newline;
897: IF i <> 10 THEN
898: l_query := l_query || 'UNION ALL ' || fnd_global.newline;
899: ELSE

Line 896: ' and bbC.id = bbct.id '|| fnd_global.newline;

892: 'WHERE short_name = ''ISC_DEPOT_BKLG_CMP_AGING'' ' || fnd_global.newline ||
893: ' and bb.bucket_id = bbc.bucket_id ' || fnd_global.newline ||
894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||
896: ' and bbC.id = bbct.id '|| fnd_global.newline;
897: IF i <> 10 THEN
898: l_query := l_query || 'UNION ALL ' || fnd_global.newline;
899: ELSE
900: l_query := l_query || ') buckets, ' || fnd_global.newline;

Line 898: l_query := l_query || 'UNION ALL ' || fnd_global.newline;

894: ' and nvl(bbc.range' || i || '_low,bbc.range' || i || '_high) is not null' || fnd_global.newline ||
895: ' and bbct.language =USERENV(''LANG'') ' || fnd_global.newline ||
896: ' and bbC.id = bbct.id '|| fnd_global.newline;
897: IF i <> 10 THEN
898: l_query := l_query || 'UNION ALL ' || fnd_global.newline;
899: ELSE
900: l_query := l_query || ') buckets, ' || fnd_global.newline;
901: END IF;
902: END LOOP;

Line 900: l_query := l_query || ') buckets, ' || fnd_global.newline;

896: ' and bbC.id = bbct.id '|| fnd_global.newline;
897: IF i <> 10 THEN
898: l_query := l_query || 'UNION ALL ' || fnd_global.newline;
899: ELSE
900: l_query := l_query || ') buckets, ' || fnd_global.newline;
901: END IF;
902: END LOOP;
903:
904: IF l_mv_type = 'ROOT' THEN

Line 906: ' ISC_DR_BKLG_02_MV fact' || fnd_global.newline;

902: END LOOP;
903:
904: IF l_mv_type = 'ROOT' THEN
905: l_mv := l_mv ||
906: ' ISC_DR_BKLG_02_MV fact' || fnd_global.newline;
907: ELSE
908: l_mv := l_mv ||
909: ' ISC_DR_BKLG_01_MV fact' || fnd_global.newline;
910: END IF;

Line 909: ' ISC_DR_BKLG_01_MV fact' || fnd_global.newline;

905: l_mv := l_mv ||
906: ' ISC_DR_BKLG_02_MV fact' || fnd_global.newline;
907: ELSE
908: l_mv := l_mv ||
909: ' ISC_DR_BKLG_01_MV fact' || fnd_global.newline;
910: END IF;
911: l_query := l_query || l_mv ||
912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||
913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||

Line 912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||

908: l_mv := l_mv ||
909: ' ISC_DR_BKLG_01_MV fact' || fnd_global.newline;
910: END IF;
911: l_query := l_query || l_mv ||
912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||
913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||
914: ' and cal.report_date in (&BIS_PREVIOUS_ASOF_DATE,&BIS_CURRENT_ASOF_DATE)' || fnd_global.newline ||
915: ' and bitand(cal.record_type_id, &BIS_NESTED_PATTERN) = cal.record_type_id ' || fnd_global.newline ||
916: l_where_clause || fnd_global.newline ||

Line 913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||

909: ' ISC_DR_BKLG_01_MV fact' || fnd_global.newline;
910: END IF;
911: l_query := l_query || l_mv ||
912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||
913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||
914: ' and cal.report_date in (&BIS_PREVIOUS_ASOF_DATE,&BIS_CURRENT_ASOF_DATE)' || fnd_global.newline ||
915: ' and bitand(cal.record_type_id, &BIS_NESTED_PATTERN) = cal.record_type_id ' || fnd_global.newline ||
916: l_where_clause || fnd_global.newline ||
917: ' group by range_name, buckets.bucket_number order by buckets.bucket_number)';

Line 914: ' and cal.report_date in (&BIS_PREVIOUS_ASOF_DATE,&BIS_CURRENT_ASOF_DATE)' || fnd_global.newline ||

910: END IF;
911: l_query := l_query || l_mv ||
912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||
913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||
914: ' and cal.report_date in (&BIS_PREVIOUS_ASOF_DATE,&BIS_CURRENT_ASOF_DATE)' || fnd_global.newline ||
915: ' and bitand(cal.record_type_id, &BIS_NESTED_PATTERN) = cal.record_type_id ' || fnd_global.newline ||
916: l_where_clause || fnd_global.newline ||
917: ' group by range_name, buckets.bucket_number order by buckets.bucket_number)';
918:

Line 915: ' and bitand(cal.record_type_id, &BIS_NESTED_PATTERN) = cal.record_type_id ' || fnd_global.newline ||

911: l_query := l_query || l_mv ||
912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||
913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||
914: ' and cal.report_date in (&BIS_PREVIOUS_ASOF_DATE,&BIS_CURRENT_ASOF_DATE)' || fnd_global.newline ||
915: ' and bitand(cal.record_type_id, &BIS_NESTED_PATTERN) = cal.record_type_id ' || fnd_global.newline ||
916: l_where_clause || fnd_global.newline ||
917: ' group by range_name, buckets.bucket_number order by buckets.bucket_number)';
918:
919: -- prepare output for bind variables

Line 916: l_where_clause || fnd_global.newline ||

912: ',fii_time_rpt_struct_v cal' || fnd_global.newline ||
913: ' where fact.time_id = cal.time_id' || fnd_global.newline ||
914: ' and cal.report_date in (&BIS_PREVIOUS_ASOF_DATE,&BIS_CURRENT_ASOF_DATE)' || fnd_global.newline ||
915: ' and bitand(cal.record_type_id, &BIS_NESTED_PATTERN) = cal.record_type_id ' || fnd_global.newline ||
916: l_where_clause || fnd_global.newline ||
917: ' group by range_name, buckets.bucket_number order by buckets.bucket_number)';
918:
919: -- prepare output for bind variables
920: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();