eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DEPOT_MTTR_PKG dependencies on POA_DBI_UTIL_PKG

Line 40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

36: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG.g_view_by_col_typ%type;
37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
38: l_comparison_type VARCHAR2(1);
39: l_cur_suffix VARCHAR2(2);
40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
42: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
43: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
44: l_mv_set VARCHAR2(50);

Line 41: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

37: l_xtd ISC_DEPOT_RPT_UTIL_PKG.g_xtd_typ%type;
38: l_comparison_type VARCHAR2(1);
39: l_cur_suffix VARCHAR2(2);
40: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
41: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
42: l_where_clause ISC_DEPOT_RPT_UTIL_PKG.g_where_clause_typ%type;
43: l_mv ISC_DEPOT_RPT_UTIL_PKG.g_mv_typ%type;
44: l_mv_set VARCHAR2(50);
45: l_aggregation_flag NUMBER;

Line 58: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

54: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
55: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
56:
57: -- clear out the tables.
58: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
59: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
60:
61: -- get all the query parameters
62: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

Line 59: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

55: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
56:
57: -- clear out the tables.
58: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
59: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
60:
61: -- get all the query parameters
62: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
63: x_view_by => l_view_by,

Line 83: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

79: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
80: END IF;
81:
82: -- Add measure columns that need to be aggregated
83: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
84: p_col_name => 'ro_count',
85: p_alias_name => 'ro_count',
86: p_grand_total => 'Y',
87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

83: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
84: p_col_name => 'ro_count',
85: p_alias_name => 'ro_count',
86: p_grand_total => 'Y',
87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
88: p_to_date_type => 'XTD');
89:
90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
91: p_col_name => 'time_to_repair',

Line 90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

86: p_grand_total => 'Y',
87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
88: p_to_date_type => 'XTD');
89:
90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
91: p_col_name => 'time_to_repair',
92: p_alias_name => 'time_to_repair',
93: p_grand_total => 'Y',
94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
91: p_col_name => 'time_to_repair',
92: p_alias_name => 'time_to_repair',
93: p_grand_total => 'Y',
94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
95: p_to_date_type => 'XTD');
96:
97: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
98: , p_col_tbl => l_col_tbl

Line 97: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'

93: p_grand_total => 'Y',
94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
95: p_to_date_type => 'XTD');
96:
97: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
98: , p_col_tbl => l_col_tbl
99: , p_col_name => 'time_to_repair'
100: , p_alias_name => 'ttr_distribution'
101: , p_grand_total => 'Y'

Line 102: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

98: , p_col_tbl => l_col_tbl
99: , p_col_name => 'time_to_repair'
100: , p_alias_name => 'ttr_distribution'
101: , p_grand_total => 'Y'
102: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
103: , p_to_date_type => 'XTD'
104: , x_bucket_rec => l_bucket_rec);
105:
106: l_query := GET_MTTR_TBL_SEL_CLAUSE (l_view_by,l_view_by_col,l_bucket_rec)

Line 129: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

125: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
126: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
127:
128: -- set the basic bind variables for the status SQL
129: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
130:
131: -- Passing AGGREGATION_LEVEL_FLAG to PMV
132: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
133: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 177: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

173: l_sel_clause :=
174: 'SELECT '|| ISC_DEPOT_RPT_UTIL_PKG.get_viewby_select_clause (p_view_by_dim) || fnd_global.newline ||
175: l_description || ' BIV_ATTRIBUTE10 ';
176:
177: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
178: , p_col_name => 'BIV_ATTRIBUTE1'
179: , p_alias_name => 'BIV_ATTRIBUTE1'
180: , p_total_flag => 'N'
181: , p_prefix => NULL

Line 201: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

197: ,BIV_MEASURE28
198: ,BIV_MEASURE29
199: ,BIV_MEASURE30 '|| fnd_global.newline;
200:
201: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
202: , p_col_name => 'BIV_MEASURE5'
203: , p_alias_name => 'BIV_MEASURE5'
204: , p_total_flag => 'N'
205: , p_prefix => NULL

Line 209: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

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

Line 225: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

221: 'FROM ( SELECT
222: rank() over (&ORDER_BY_CLAUSE'||' nulls last, '||p_view_by_col||') - 1 rnk
223: ,'||p_view_by_col;
224:
225: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
226: , p_col_name => 'BIV_ATTRIBUTE1'
227: , p_alias_name => 'BIV_ATTRIBUTE1'
228: , p_total_flag => 'N'
229: , p_prefix => NULL

Line 249: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

245: ,BIV_MEASURE28
246: ,BIV_MEASURE29
247: ,BIV_MEASURE30 '|| fnd_global.newline;
248:
249: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
250: , p_col_name => 'BIV_MEASURE5'
251: , p_alias_name => 'BIV_MEASURE5'
252: , p_total_flag => 'N'
253: , p_prefix => NULL

Line 257: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

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

Line 270: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'

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

Line 276: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'

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

Line 281: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'

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

Line 286: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'

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

Line 296: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

292: ',' || '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) BIV_MEASURE29 ' || fnd_global.newline ||
293: ',' || '(p_time_to_repair_total/(decode(p_ro_count_total,0,to_number(NULL),p_ro_count_total))) BIV_MEASURE30 ' || fnd_global.newline;
294:
295: l_sel_clause := l_sel_clause ||
296: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
297: , p_col_name => 'c_ttr_distribution'
298: , p_alias_name => 'BIV_MEASURE5'
299: , p_total_flag => 'N'
300: , p_prefix => 'NVL('

Line 305: poa_dbi_util_pkg.get_bucket_drill_url( p_bucket_rec

301: , p_suffix => ',0)'
302: ) || fnd_global.newline ;
303:
304: l_sel_clause := l_sel_clause ||
305: poa_dbi_util_pkg.get_bucket_drill_url( p_bucket_rec
306: , 'BIV_ATTRIBUTE1'
307: ,'''pFunctionName=ISC_DEPOT_MTTR_DTL_TBL_REP&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&BIV_ATTRIBUTE1=-1&BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET='
308: , ''''
309: , p_add_bucket_num => 'Y');

Line 312: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

308: , ''''
309: , p_add_bucket_num => 'Y');
310:
311: l_sel_clause := l_sel_clause ||
312: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
313: , p_col_name => 'c_ttr_distribution'
314: , p_alias_name => 'BIV_MEASURE25'
315: , p_total_flag => 'Y'
316: , p_prefix => 'NVL('

Line 353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

349: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
351: l_comparison_type VARCHAR2(1);
352: l_cur_suffix VARCHAR2(2);
353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
354: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
355: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
356: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
357: l_mv_set VARCHAR2(50);

Line 354: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

350: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
351: l_comparison_type VARCHAR2(1);
352: l_cur_suffix VARCHAR2(2);
353: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
354: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
355: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
356: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
357: l_mv_set VARCHAR2(50);
358: l_aggregation_flag NUMBER;

Line 371: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

367: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
368: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
369:
370: -- clear out the tables.
371: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
372: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
373:
374: -- get all the query parameters
375: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

Line 372: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

368: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
369:
370: -- clear out the tables.
371: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
372: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
373:
374: -- get all the query parameters
375: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
376: x_view_by => l_view_by,

Line 396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

392: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
393: END IF;
394:
395: -- Add measure columns that need to be aggregated
396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
397: p_col_name => 'ro_count' ,
398: p_alias_name => 'ro_count',
399: p_grand_total => 'N',
400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
397: p_col_name => 'ro_count' ,
398: p_alias_name => 'ro_count',
399: p_grand_total => 'N',
400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
401: p_to_date_type => 'XTD');
402:
403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
404: p_col_name => 'time_to_repair' ,

Line 403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

399: p_grand_total => 'N',
400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
401: p_to_date_type => 'XTD');
402:
403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
404: p_col_name => 'time_to_repair' ,
405: p_alias_name => 'time_to_repair',
406: p_grand_total => 'N',
407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
404: p_col_name => 'time_to_repair' ,
405: p_alias_name => 'time_to_repair',
406: p_grand_total => 'N',
407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
408: p_to_date_type => 'XTD');
409:
410: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
411: , p_col_tbl => l_col_tbl

Line 410: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'

406: p_grand_total => 'N',
407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
408: p_to_date_type => 'XTD');
409:
410: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
411: , p_col_tbl => l_col_tbl
412: , p_col_name => 'time_to_repair'
413: , p_alias_name => 'ttr_distribution'
414: , p_grand_total => 'N'

Line 415: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

411: , p_col_tbl => l_col_tbl
412: , p_col_name => 'time_to_repair'
413: , p_alias_name => 'ttr_distribution'
414: , p_grand_total => 'N'
415: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
416: , p_to_date_type => 'XTD'
417: , x_bucket_rec => l_bucket_rec
418: );
419:

Line 441: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

437: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
438: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
439:
440: -- set the basic bind variables for the trend SQL
441: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
442: p_comparison_type => l_comparison_type,
443: x_custom_output => x_custom_output);
444:
445: -- Passing AGGREGATION_LEVEL_FLAG to PMV

Line 479: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'

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

Line 485: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'

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

Line 491: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

487: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
488: || 'BIV_MEASURE4' || fnd_global.newline;
489:
490: l_sel_clause := l_sel_clause ||
491: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
492: , p_col_name => 'iset.c_ttr_distribution'
493: , p_alias_name => 'BIV_MEASURE5'
494: , p_total_flag => 'N'
495: , p_prefix => 'NVL('

Line 516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

512: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
514: l_comparison_type VARCHAR2(1);
515: l_cur_suffix VARCHAR2(2);
516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
517: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
518: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
519: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
520: l_mv_set VARCHAR2(50);

Line 517: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

513: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
514: l_comparison_type VARCHAR2(1);
515: l_cur_suffix VARCHAR2(2);
516: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
517: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
518: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
519: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
520: l_mv_set VARCHAR2(50);
521: l_aggregation_flag NUMBER;

Line 533: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

529: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
530: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
531:
532: -- clear out the tables.
533: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
534: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
535:
536: -- get all the query parameters
537: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

Line 534: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

530: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
531:
532: -- clear out the tables.
533: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
534: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
535:
536: -- get all the query parameters
537: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
538: x_view_by => l_view_by,

Line 667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

663: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
665: l_comparison_type VARCHAR2(1);
666: l_cur_suffix VARCHAR2(2);
667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
668: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
669: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
670: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
671: l_mv_set VARCHAR2(50);

Line 668: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

664: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
665: l_comparison_type VARCHAR2(1);
666: l_cur_suffix VARCHAR2(2);
667: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
668: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
669: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
670: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
671: l_mv_set VARCHAR2(50);
672: l_aggregation_flag NUMBER;

Line 685: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

681: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
682: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
683:
684: -- clear out the tables.
685: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
686: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
687:
688: -- get all the query parameters
689: ISC_DEPOT_RPT_UTIL_PKG .process_parameters ( p_param => p_param,

Line 686: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

682: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
683:
684: -- clear out the tables.
685: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
686: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
687:
688: -- get all the query parameters
689: ISC_DEPOT_RPT_UTIL_PKG .process_parameters ( p_param => p_param,
690: x_view_by => l_view_by,

Line 710: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

706: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
707: END IF;
708:
709: -- Add measure columns that need to be aggregated
710: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
711: p_col_name => 'ro_count' ,
712: p_alias_name => 'ro_count',
713: p_grand_total => 'Y',
714: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 714: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

710: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
711: p_col_name => 'ro_count' ,
712: p_alias_name => 'ro_count',
713: p_grand_total => 'Y',
714: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
715: p_to_date_type => 'XTD');
716:
717: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
718: p_col_name => 'time_to_repair' ,

Line 717: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

713: p_grand_total => 'Y',
714: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
715: p_to_date_type => 'XTD');
716:
717: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
718: p_col_name => 'time_to_repair' ,
719: p_alias_name => 'time_to_repair',
720: p_grand_total => 'Y',
721: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 721: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

717: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
718: p_col_name => 'time_to_repair' ,
719: p_alias_name => 'time_to_repair',
720: p_grand_total => 'Y',
721: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
722: p_to_date_type => 'XTD');
723:
724: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
725: , p_col_tbl => l_col_tbl

Line 724: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'

720: p_grand_total => 'Y',
721: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
722: p_to_date_type => 'XTD');
723:
724: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
725: , p_col_tbl => l_col_tbl
726: , p_col_name => 'time_to_repair'
727: , p_alias_name => 'ttr_distribution'
728: , p_grand_total => 'Y'

Line 729: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

725: , p_col_tbl => l_col_tbl
726: , p_col_name => 'time_to_repair'
727: , p_alias_name => 'ttr_distribution'
728: , p_grand_total => 'Y'
729: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
730: , p_to_date_type => 'XTD'
731: , x_bucket_rec => l_bucket_rec
732: );
733:

Line 757: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

753: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
754: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
755:
756: -- set the basic bind variables for the status SQL
757: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
758:
759: -- Passing AGGREGATION_LEVEL_FLAG to PMV
760: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
761: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 814: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

810: ,BIV_MEASURE22
811: ,BIV_MEASURE23
812: ,BIV_MEASURE24';
813:
814: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
815: , p_col_name => 'BIV_MEASURE5'
816: , p_alias_name => 'BIV_MEASURE5'
817: , p_total_flag => 'N'
818: , p_prefix => NULL

Line 822: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

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

Line 845: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

841: ,BIV_MEASURE22
842: ,BIV_MEASURE23
843: ,BIV_MEASURE24';
844:
845: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
846: , p_col_name => 'BIV_MEASURE5'
847: , p_alias_name => 'BIV_MEASURE5'
848: , p_total_flag => 'N'
849: , p_prefix => NULL

Line 853: l_sel_clause := l_sel_clause || poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

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

Line 865: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'

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

Line 871: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair/(decode(c_ro_count,0,to_number(NULL),c_ro_count)))'

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

Line 876: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'

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

Line 881: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(c_time_to_repair_total/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total)))'

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

Line 887: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

883: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
884: || 'BIV_MEASURE24' || fnd_global.newline;
885:
886: l_sel_clause := l_sel_clause ||
887: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
888: , p_col_name => '(100/(decode(c_ro_count,0,to_number(NULL),c_ro_count))) * c_ttr_distribution'
889: , p_alias_name => 'BIV_MEASURE5'
890: , p_total_flag => 'N'
891: , p_prefix => NULL

Line 896: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

892: , p_suffix => NULL
893: ) || fnd_global.newline ;
894:
895: l_sel_clause := l_sel_clause ||
896: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
897: , p_col_name => '(100/(decode(c_ro_count_total,0,to_number(NULL),c_ro_count_total))) * c_ttr_distribution'
898: , p_alias_name => 'BIV_MEASURE25'
899: , p_total_flag => 'Y'
900: , p_prefix => NULL

Line 921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

917: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
919: l_comparison_type VARCHAR2(1);
920: l_cur_suffix VARCHAR2(2);
921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
922: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
923: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
924: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
925: l_mv_set VARCHAR2(50);

Line 922: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

918: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
919: l_comparison_type VARCHAR2(1);
920: l_cur_suffix VARCHAR2(2);
921: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
922: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
923: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
924: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
925: l_mv_set VARCHAR2(50);
926: l_aggregation_flag NUMBER;

Line 939: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

935: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
936: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
937:
938: -- clear out the tables.
939: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
940: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
941:
942: -- get all the query parameters
943: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

Line 940: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

936: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
937:
938: -- clear out the tables.
939: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
940: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
941:
942: -- get all the query parameters
943: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
944: x_view_by => l_view_by,

Line 964: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

960: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_MTTR_DIST_TRD : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
961: END IF;
962:
963: -- Add measure columns that need to be aggregated
964: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
965: p_col_name => 'ro_count' ,
966: p_alias_name => 'ro_count',
967: p_grand_total => 'N',
968: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 968: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

964: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
965: p_col_name => 'ro_count' ,
966: p_alias_name => 'ro_count',
967: p_grand_total => 'N',
968: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
969: p_to_date_type => 'XTD');
970:
971: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
972: p_col_name => 'time_to_repair' ,

Line 971: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

967: p_grand_total => 'N',
968: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
969: p_to_date_type => 'XTD');
970:
971: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
972: p_col_name => 'time_to_repair' ,
973: p_alias_name => 'time_to_repair',
974: p_grand_total => 'N',
975: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 975: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

971: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
972: p_col_name => 'time_to_repair' ,
973: p_alias_name => 'time_to_repair',
974: p_grand_total => 'N',
975: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
976: p_to_date_type => 'XTD');
977:
978: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
979: , p_col_tbl => l_col_tbl

Line 978: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'

974: p_grand_total => 'N',
975: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
976: p_to_date_type => 'XTD');
977:
978: poa_dbi_util_pkg.add_bucket_columns(p_short_name => 'ISC_DEPOT_MTTR'
979: , p_col_tbl => l_col_tbl
980: , p_col_name => 'time_to_repair'
981: , p_alias_name => 'ttr_distribution'
982: , p_grand_total => 'N'

Line 983: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS

979: , p_col_tbl => l_col_tbl
980: , p_col_name => 'time_to_repair'
981: , p_alias_name => 'ttr_distribution'
982: , p_grand_total => 'N'
983: , p_prior_code => poa_dbi_util_pkg.NO_PRIORS
984: , p_to_date_type => 'XTD'
985: , x_bucket_rec => l_bucket_rec
986: );
987:

Line 1008: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,

1004: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1005: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1006:
1007: -- set the basic bind variables for the trend SQL
1008: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
1009: p_comparison_type => l_comparison_type,
1010: x_custom_output => x_custom_output);
1011: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1012: l_custom_rec.attribute_name :=':AGGREGATION_FLAG';

Line 1045: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'iset.c_ro_count'

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

Line 1051: ',' || poa_dbi_util_pkg.change_clause( cur_col => '(iset.c_time_to_repair/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count)))'

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

Line 1057: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec

1053: ,change_type => 'P') -- 'P' for Percent ; 'NP' for non percent
1054: || 'BIV_MEASURE4' || fnd_global.newline;
1055:
1056: l_sel_clause := l_sel_clause ||
1057: poa_dbi_util_pkg.get_bucket_outer_query( p_bucket_rec => p_bucket_rec
1058: , p_col_name =>'(100/(decode(iset.c_ro_count,0,to_number(NULL),iset.c_ro_count))) * iset.c_ttr_distribution'
1059: , p_alias_name =>'BIV_MEASURE5'
1060: , p_total_flag =>'N'
1061: , p_prefix => NULL

Line 1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

1077: l_view_by_col ISC_DEPOT_RPT_UTIL_PKG .g_view_by_col_typ%type;
1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
1079: l_comparison_type VARCHAR2(1);
1080: l_cur_suffix VARCHAR2(2);
1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1082: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1083: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
1084: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
1085: l_mv_set VARCHAR2(50);

Line 1082: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

1078: l_xtd ISC_DEPOT_RPT_UTIL_PKG .g_xtd_typ%type;
1079: l_comparison_type VARCHAR2(1);
1080: l_cur_suffix VARCHAR2(2);
1081: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1082: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1083: l_where_clause ISC_DEPOT_RPT_UTIL_PKG .g_where_clause_typ%type;
1084: l_mv ISC_DEPOT_RPT_UTIL_PKG .g_mv_typ%type;
1085: l_mv_set VARCHAR2(50);
1086: l_aggregation_flag NUMBER;

Line 1098: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

1094: l_debug_mode := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1095: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1096:
1097: -- clear out the tables.
1098: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1099: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1100:
1101: -- get all the query parameters
1102: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,

Line 1099: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

1095: l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1096:
1097: -- clear out the tables.
1098: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1099: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1100:
1101: -- get all the query parameters
1102: ISC_DEPOT_RPT_UTIL_PKG .process_parameters (p_param => p_param,
1103: x_view_by => l_view_by,

Line 1123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1119: ISC_DEPOT_RPT_UTIL_PKG .write('BIS_ISC_DEPOT_SRVC_TBL : ' ,l_err_stage,ISC_DEPOT_RPT_UTIL_PKG .C_DEBUG_LEVEL);
1120: END IF;
1121:
1122: -- Add measure columns that need to be aggregated
1123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1124: p_col_name => 'ro_count',
1125: p_alias_name => 'ro_count',
1126: p_grand_total => 'Y',
1127: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1127: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1124: p_col_name => 'ro_count',
1125: p_alias_name => 'ro_count',
1126: p_grand_total => 'Y',
1127: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1128: p_to_date_type => 'XTD');
1129:
1130: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' THEN
1131: l_err_stage:='After initializing';

Line 1159: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

1155: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1156: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1157:
1158: -- set the basic bind variables for the status SQL
1159: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1160:
1161: -- Passing AGGREGATION_LEVEL_FLAG to PMV
1162: l_custom_rec.attribute_name := ':AGGREGATION_FLAG';
1163: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

Line 1218: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count'

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

Line 1224: ',' || poa_dbi_util_pkg.change_clause( cur_col => 'c_ro_count_total'

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