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_MAINT_WO_CST_RPT_PKG dependencies on ISC_MAINT_RPT_UTIL_PKG

Line 22: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id

18: l_view_by varchar2(200);
19:
20: begin
21:
22: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
23: ( p_param
24: , isc_maint_rpt_util_pkg.G_ORGANIZATION
25: );
26:

Line 24: , isc_maint_rpt_util_pkg.G_ORGANIZATION

20: begin
21:
22: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
23: ( p_param
24: , isc_maint_rpt_util_pkg.G_ORGANIZATION
25: );
26:
27: if p_report_type = 'WORK_ORDER_COST' then
28:

Line 29: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

25: );
26:
27: if p_report_type = 'WORK_ORDER_COST' then
28:
29: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
30: ( p_param
31: , 'VIEW_BY'
32: );
33:

Line 34: isc_maint_rpt_util_pkg.bind_group_id

30: ( p_param
31: , 'VIEW_BY'
32: );
33:
34: isc_maint_rpt_util_pkg.bind_group_id
35: ( p_dim_bmap
36: , p_custom_output
37: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
38: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

Line 37: , isc_maint_rpt_util_pkg.G_ASSET_GROUP

33:
34: isc_maint_rpt_util_pkg.bind_group_id
35: ( p_dim_bmap
36: , p_custom_output
37: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
38: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
39: , isc_maint_rpt_util_pkg.G_ACTIVITY
40: );
41:

Line 38: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

34: isc_maint_rpt_util_pkg.bind_group_id
35: ( p_dim_bmap
36: , p_custom_output
37: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
38: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
39: , isc_maint_rpt_util_pkg.G_ACTIVITY
40: );
41:
42: return '(

Line 39: , isc_maint_rpt_util_pkg.G_ACTIVITY

35: ( p_dim_bmap
36: , p_custom_output
37: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
38: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
39: , isc_maint_rpt_util_pkg.G_ACTIVITY
40: );
41:
42: return '(
43: select

Line 49: when isc_maint_rpt_util_pkg.G_DEPARTMENT then

45: , period_type_id
46: , grp_id
47: , ' ||
48: case l_view_by
49: when isc_maint_rpt_util_pkg.G_DEPARTMENT then
50: 'decode(department_id,-1,-1,organization_id) organization_id'
51: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
52: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
53: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */

Line 51: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then

47: , ' ||
48: case l_view_by
49: when isc_maint_rpt_util_pkg.G_DEPARTMENT then
50: 'decode(department_id,-1,-1,organization_id) organization_id'
51: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
52: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
53: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */
54: 'decode(instance_id,-1,-1,organization_id) organization_id'
55: when isc_maint_rpt_util_pkg.G_ACTIVITY then

Line 53: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */

49: when isc_maint_rpt_util_pkg.G_DEPARTMENT then
50: 'decode(department_id,-1,-1,organization_id) organization_id'
51: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
52: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
53: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */
54: 'decode(instance_id,-1,-1,organization_id) organization_id'
55: when isc_maint_rpt_util_pkg.G_ACTIVITY then
56: 'decode(activity_id,-1,-1,organization_id) organization_id'
57: when isc_maint_rpt_util_pkg.G_COST_CATEGORY then

Line 55: when isc_maint_rpt_util_pkg.G_ACTIVITY then

51: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
52: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
53: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */
54: 'decode(instance_id,-1,-1,organization_id) organization_id'
55: when isc_maint_rpt_util_pkg.G_ACTIVITY then
56: 'decode(activity_id,-1,-1,organization_id) organization_id'
57: when isc_maint_rpt_util_pkg.G_COST_CATEGORY then
58: 'decode(maint_cost_category,-1,-1,organization_id) organization_id'
59: else

Line 57: when isc_maint_rpt_util_pkg.G_COST_CATEGORY then

53: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */
54: 'decode(instance_id,-1,-1,organization_id) organization_id'
55: when isc_maint_rpt_util_pkg.G_ACTIVITY then
56: 'decode(activity_id,-1,-1,organization_id) organization_id'
57: when isc_maint_rpt_util_pkg.G_COST_CATEGORY then
58: 'decode(maint_cost_category,-1,-1,organization_id) organization_id'
59: else
60: 'organization_id'
61: end ||'

Line 64: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

60: 'organization_id'
61: end ||'
62: , ' ||
63: case l_view_by
64: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
65: 'decode(instance_id,-1,-1,asset_group_id) asset_group_id' /* replaced asset_number with instance_id */
66: else
67: 'asset_group_id'
68: end || '

Line 212: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )

208: where fact.grp_id = &ISC_GRP_ID' ||
209: case
210: when l_org_id is null then
211: '
212: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
213: end || '
214: )';
215:
216: else

Line 271: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'f', l_org_id )

267: estimated_mat_cost_b + estimated_lab_cost_b + estimated_eqp_cost_b <> 0)' ||
268: case
269: when l_org_id is null then
270: '
271: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'f', l_org_id )
272: end || '
273: )';
274:
275: end if;

Line 286: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

282: , x_custom_output out nocopy bis_query_attributes_tbl
283: )
284: is
285:
286: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
287: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
288: l_custom_output bis_query_attributes_tbl;
289: l_curr_suffix varchar2(3);
290: l_where_clause varchar2(10000);

Line 305: isc_maint_rpt_util_pkg.register_dimension_levels

301: l_asset_grp_column varchar2(200);
302: l_inner_query varchar2(5000);
303: begin
304:
305: isc_maint_rpt_util_pkg.register_dimension_levels
306: ( l_dimension_tbl
307: , l_dim_filter_map
308: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
309: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 308: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

304:
305: isc_maint_rpt_util_pkg.register_dimension_levels
306: ( l_dimension_tbl
307: , l_dim_filter_map
308: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
309: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
310: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
311: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
312: );

Line 309: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

305: isc_maint_rpt_util_pkg.register_dimension_levels
306: ( l_dimension_tbl
307: , l_dim_filter_map
308: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
309: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
310: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
311: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
312: );
313:

Line 310: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

306: ( l_dimension_tbl
307: , l_dim_filter_map
308: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
309: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
310: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
311: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
312: );
313:
314: isc_maint_rpt_util_pkg.process_parameters

Line 311: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'

307: , l_dim_filter_map
308: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
309: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
310: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
311: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
312: );
313:
314: isc_maint_rpt_util_pkg.process_parameters
315: ( p_param => p_param

Line 314: isc_maint_rpt_util_pkg.process_parameters

310: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
311: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
312: );
313:
314: isc_maint_rpt_util_pkg.process_parameters
315: ( p_param => p_param
316: , p_dimension_tbl => l_dimension_tbl
317: , p_dim_filter_map => l_dim_filter_map
318: , p_trend => 'N'

Line 329: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id

325: , x_comparison_type => l_comparison_type
326: , x_xtd => l_xtd
327: );
328:
329: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
330: ( p_param
331: , isc_maint_rpt_util_pkg.G_ESTIMATED
332: );
333:

Line 331: , isc_maint_rpt_util_pkg.G_ESTIMATED

327: );
328:
329: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
330: ( p_param
331: , isc_maint_rpt_util_pkg.G_ESTIMATED
332: );
333:
334: l_mv := get_fact_mv_name
335: ( 'WORK_ORDER_COST'

Line 342: l_cost_element := isc_maint_rpt_util_pkg.get_parameter_id

338: , l_custom_output
339: , l_estimated
340: );
341:
342: l_cost_element := isc_maint_rpt_util_pkg.get_parameter_id
343: ( p_param
344: , isc_maint_rpt_util_pkg.G_COST_ELEMENT
345: );
346:

Line 344: , isc_maint_rpt_util_pkg.G_COST_ELEMENT

340: );
341:
342: l_cost_element := isc_maint_rpt_util_pkg.get_parameter_id
343: ( p_param
344: , isc_maint_rpt_util_pkg.G_COST_ELEMENT
345: );
346:
347: if l_cost_element = '1' then
348: l_cost_element := 'eqp';

Line 379: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =

375: );
376:
377: /* if view by is asset number add the asset_group column */
378:
379: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
380: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
381: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
382: else
383: l_asset_grp_column :='NULL';

Line 380: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

376:
377: /* if view by is asset number add the asset_group column */
378:
379: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
380: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
381: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
382: else
383: l_asset_grp_column :='NULL';
384: end if ;

Line 381: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);

377: /* if view by is asset number add the asset_group column */
378:
379: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
380: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
381: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
382: else
383: l_asset_grp_column :='NULL';
384: end if ;
385:

Line 420: isc_maint_rpt_util_pkg.change_column

416: from (select '||
417: ' nvl(oset05.p_estimated_cost,0) BIV_MEASURE1
418: , nvl(oset05.c_estimated_cost,0) BIV_MEASURE2' || '
419: , ' ||
420: isc_maint_rpt_util_pkg.change_column
421: ( 'oset05.c_estimated_cost'
422: , 'oset05.p_estimated_cost'
423: , 'BIV_MEASURE3' ) || '
424: , nvl(oset05.p_actual_cost,0) BIV_MEASURE4

Line 427: isc_maint_rpt_util_pkg.change_column

423: , 'BIV_MEASURE3' ) || '
424: , nvl(oset05.p_actual_cost,0) BIV_MEASURE4
425: , nvl(oset05.c_actual_cost,0) BIV_MEASURE5' || '
426: , ' ||
427: isc_maint_rpt_util_pkg.change_column
428: ( 'oset05.c_actual_cost'
429: , 'oset05.p_actual_cost'
430: , 'BIV_MEASURE6' ) || '
431: , nvl(oset05.p_variance_cost,0) BIV_MEASURE7

Line 434: isc_maint_rpt_util_pkg.change_column

430: , 'BIV_MEASURE6' ) || '
431: , nvl(oset05.p_variance_cost,0) BIV_MEASURE7
432: , nvl(oset05.c_variance_cost,0) BIV_MEASURE8' || '
433: , ' ||
434: isc_maint_rpt_util_pkg.change_column
435: ( 'oset05.c_variance_cost'
436: , 'oset05.p_variance_cost'
437: , 'BIV_MEASURE9' ) || '
438: , ' ||

Line 439: isc_maint_rpt_util_pkg.rate_column

435: ( 'oset05.c_variance_cost'
436: , 'oset05.p_variance_cost'
437: , 'BIV_MEASURE9' ) || '
438: , ' ||
439: isc_maint_rpt_util_pkg.rate_column
440: ( 'oset05.p_variance_cost'
441: , 'oset05.p_estimated_cost'
442: , 'BIV_MEASURE10' -- prior variance percent
443: , 'Y' ) || '

Line 445: isc_maint_rpt_util_pkg.rate_column

441: , 'oset05.p_estimated_cost'
442: , 'BIV_MEASURE10' -- prior variance percent
443: , 'Y' ) || '
444: , ' ||
445: isc_maint_rpt_util_pkg.rate_column
446: ( 'oset05.c_variance_cost'
447: , 'oset05.c_estimated_cost'
448: , 'BIV_MEASURE11' -- current variance percent
449: , 'Y' ) || '

Line 451: isc_maint_rpt_util_pkg.change_column

447: , 'oset05.c_estimated_cost'
448: , 'BIV_MEASURE11' -- current variance percent
449: , 'Y' ) || '
450: , ' ||
451: isc_maint_rpt_util_pkg.change_column
452: ( isc_maint_rpt_util_pkg.rate_column
453: ( 'oset05.c_variance_cost'
454: , 'oset05.c_estimated_cost'
455: , null

Line 452: ( isc_maint_rpt_util_pkg.rate_column

448: , 'BIV_MEASURE11' -- current variance percent
449: , 'Y' ) || '
450: , ' ||
451: isc_maint_rpt_util_pkg.change_column
452: ( isc_maint_rpt_util_pkg.rate_column
453: ( 'oset05.c_variance_cost'
454: , 'oset05.c_estimated_cost'
455: , null
456: , 'Y' )

Line 457: , isc_maint_rpt_util_pkg.rate_column

453: ( 'oset05.c_variance_cost'
454: , 'oset05.c_estimated_cost'
455: , null
456: , 'Y' )
457: , isc_maint_rpt_util_pkg.rate_column
458: ( 'oset05.p_variance_cost'
459: , 'oset05.p_estimated_cost'
460: , null
461: , 'Y' )

Line 466: isc_maint_rpt_util_pkg.change_column

462: , 'BIV_MEASURE12' -- change variance percent (as float)
463: , 'N' ) || '
464: , nvl(oset05.c_estimated_cost_total,0) BIV_MEASURE13' || '
465: , ' ||
466: isc_maint_rpt_util_pkg.change_column
467: ( 'oset05.c_estimated_cost_total'
468: , 'oset05.p_estimated_cost_total'
469: , 'BIV_MEASURE14' ) || '
470: , nvl(oset05.c_actual_cost_total,0) BIV_MEASURE15' || '

Line 472: isc_maint_rpt_util_pkg.change_column

468: , 'oset05.p_estimated_cost_total'
469: , 'BIV_MEASURE14' ) || '
470: , nvl(oset05.c_actual_cost_total,0) BIV_MEASURE15' || '
471: , ' ||
472: isc_maint_rpt_util_pkg.change_column
473: ( 'oset05.c_actual_cost_total'
474: , 'oset05.p_actual_cost_total'
475: , 'BIV_MEASURE16' ) || '
476: , nvl(oset05.c_variance_cost_total,0) BIV_MEASURE17' || '

Line 478: isc_maint_rpt_util_pkg.change_column

474: , 'oset05.p_actual_cost_total'
475: , 'BIV_MEASURE16' ) || '
476: , nvl(oset05.c_variance_cost_total,0) BIV_MEASURE17' || '
477: , ' ||
478: isc_maint_rpt_util_pkg.change_column
479: ( 'oset05.c_variance_cost_total'
480: , 'oset05.p_variance_cost_total'
481: , 'BIV_MEASURE18' ) || '
482: , ' ||

Line 483: isc_maint_rpt_util_pkg.rate_column

479: ( 'oset05.c_variance_cost_total'
480: , 'oset05.p_variance_cost_total'
481: , 'BIV_MEASURE18' ) || '
482: , ' ||
483: isc_maint_rpt_util_pkg.rate_column
484: ( 'oset05.c_variance_cost_total'
485: , 'oset05.c_estimated_cost_total'
486: , 'BIV_MEASURE19'
487: , 'Y' ) || '

Line 489: isc_maint_rpt_util_pkg.change_column

485: , 'oset05.c_estimated_cost_total'
486: , 'BIV_MEASURE19'
487: , 'Y' ) || '
488: , ' ||
489: isc_maint_rpt_util_pkg.change_column
490: ( isc_maint_rpt_util_pkg.rate_column
491: ( 'oset05.c_variance_cost_total'
492: , 'oset05.c_estimated_cost_total'
493: , null

Line 490: ( isc_maint_rpt_util_pkg.rate_column

486: , 'BIV_MEASURE19'
487: , 'Y' ) || '
488: , ' ||
489: isc_maint_rpt_util_pkg.change_column
490: ( isc_maint_rpt_util_pkg.rate_column
491: ( 'oset05.c_variance_cost_total'
492: , 'oset05.c_estimated_cost_total'
493: , null
494: , 'Y'

Line 496: , isc_maint_rpt_util_pkg.rate_column

492: , 'oset05.c_estimated_cost_total'
493: , null
494: , 'Y'
495: )
496: , isc_maint_rpt_util_pkg.rate_column
497: ( 'oset05.p_variance_cost_total'
498: , 'oset05.p_estimated_cost_total'
499: , null
500: , 'Y'

Line 505: -- isc_maint_rpt_util_pkg.change_column

501: )
502: , 'BIV_MEASURE20'
503: , 'N' ) --|| '
504: --, ' ||
505: -- isc_maint_rpt_util_pkg.change_column
506: -- ( isc_maint_rpt_util_pkg.rate_column
507: -- ( 'oset05.c_variance_cost_total'
508: -- , 'oset05.c_estimated_cost_total'
509: -- , ''

Line 506: -- ( isc_maint_rpt_util_pkg.rate_column

502: , 'BIV_MEASURE20'
503: , 'N' ) --|| '
504: --, ' ||
505: -- isc_maint_rpt_util_pkg.change_column
506: -- ( isc_maint_rpt_util_pkg.rate_column
507: -- ( 'oset05.c_variance_cost_total'
508: -- , 'oset05.c_estimated_cost_total'
509: -- , ''
510: -- , 'Y' )

Line 511: -- , isc_maint_rpt_util_pkg.rate_column

507: -- ( 'oset05.c_variance_cost_total'
508: -- , 'oset05.c_estimated_cost_total'
509: -- , ''
510: -- , 'Y' )
511: -- , isc_maint_rpt_util_pkg.rate_column
512: -- ( 'oset05.p_variance_cost_total'
513: -- , 'oset05.p_estimated_cost_total'
514: -- , ''
515: -- , 'Y' )

Line 524: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';

520: , ''pFunctionName=ISC_MAINT_WO_CST_SUM_TBL_REP'' ||
521: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||
522: ''&VIEW_BY=BIV_MAINT_ASSET+BIV_MAINT_ASSET_NUMBER_LVL'' ||
523: ''&pParamIds=Y'' BIV_ATTRIBUTE1,'||
524: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
525:
526: l_stmt := l_stmt || l_inner_query ||
527: poa_dbi_template_pkg.status_sql
528: ( p_fact_name => l_mv

Line 541: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);

537: , p_generate_viewby => 'Y'
538: );
539:
540: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
541: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
542:
543: x_custom_output := l_custom_output;
544: x_custom_sql := l_stmt;
545:

Line 556: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

552: , x_custom_output out nocopy bis_query_attributes_tbl
553: )
554: is
555:
556: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
557: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
558: l_custom_output bis_query_attributes_tbl;
559: l_curr_suffix varchar2(3);
560: l_where_clause varchar2(10000);

Line 574: isc_maint_rpt_util_pkg.register_dimension_levels

570: l_stmt varchar2(32767);
571:
572: begin
573:
574: isc_maint_rpt_util_pkg.register_dimension_levels
575: ( l_dimension_tbl
576: , l_dim_filter_map
577: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
578: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 577: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

573:
574: isc_maint_rpt_util_pkg.register_dimension_levels
575: ( l_dimension_tbl
576: , l_dim_filter_map
577: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
578: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
579: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
580: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
581: );

Line 578: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

574: isc_maint_rpt_util_pkg.register_dimension_levels
575: ( l_dimension_tbl
576: , l_dim_filter_map
577: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
578: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
579: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
580: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
581: );
582:

Line 579: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

575: ( l_dimension_tbl
576: , l_dim_filter_map
577: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
578: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
579: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
580: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
581: );
582:
583: isc_maint_rpt_util_pkg.process_parameters

Line 580: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'

576: , l_dim_filter_map
577: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
578: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
579: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
580: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
581: );
582:
583: isc_maint_rpt_util_pkg.process_parameters
584: ( p_param => p_param

Line 583: isc_maint_rpt_util_pkg.process_parameters

579: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
580: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
581: );
582:
583: isc_maint_rpt_util_pkg.process_parameters
584: ( p_param => p_param
585: , p_dimension_tbl => l_dimension_tbl
586: , p_dim_filter_map => l_dim_filter_map
587: , p_trend => 'Y'

Line 598: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id

594: , x_comparison_type => l_comparison_type
595: , x_xtd => l_xtd
596: );
597:
598: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
599: ( p_param
600: , isc_maint_rpt_util_pkg.G_ESTIMATED
601: );
602: l_mv := get_fact_mv_name

Line 600: , isc_maint_rpt_util_pkg.G_ESTIMATED

596: );
597:
598: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
599: ( p_param
600: , isc_maint_rpt_util_pkg.G_ESTIMATED
601: );
602: l_mv := get_fact_mv_name
603: ( 'WORK_ORDER_COST'
604: , p_param

Line 610: l_cost_element := isc_maint_rpt_util_pkg.get_parameter_id

606: , l_custom_output
607: , l_estimated
608: );
609:
610: l_cost_element := isc_maint_rpt_util_pkg.get_parameter_id
611: ( p_param
612: , isc_maint_rpt_util_pkg.G_COST_ELEMENT
613: );
614: if l_cost_element = '1' then

Line 612: , isc_maint_rpt_util_pkg.G_COST_ELEMENT

608: );
609:
610: l_cost_element := isc_maint_rpt_util_pkg.get_parameter_id
611: ( p_param
612: , isc_maint_rpt_util_pkg.G_COST_ELEMENT
613: );
614: if l_cost_element = '1' then
615: l_cost_element := 'eqp';
616: elsif l_cost_element = '2' then

Line 652: isc_maint_rpt_util_pkg.change_column

648: cal.name VIEWBY
649: , nvl(iset.p_estimated_cost,0) BIV_MEASURE1
650: , nvl(iset.c_estimated_cost,0) BIV_MEASURE2' || '
651: , ' ||
652: isc_maint_rpt_util_pkg.change_column
653: ( 'iset.c_estimated_cost'
654: , 'iset.p_estimated_cost'
655: , 'BIV_MEASURE3' ) || '
656: , nvl(iset.p_actual_cost,0) BIV_MEASURE4

Line 659: isc_maint_rpt_util_pkg.change_column

655: , 'BIV_MEASURE3' ) || '
656: , nvl(iset.p_actual_cost,0) BIV_MEASURE4
657: , nvl(iset.c_actual_cost,0) BIV_MEASURE5' || '
658: , ' ||
659: isc_maint_rpt_util_pkg.change_column
660: ( 'iset.c_actual_cost'
661: , 'iset.p_actual_cost'
662: , 'BIV_MEASURE6' ) || '
663: , nvl(iset.p_variance_cost,0) BIV_MEASURE7

Line 666: isc_maint_rpt_util_pkg.change_column

662: , 'BIV_MEASURE6' ) || '
663: , nvl(iset.p_variance_cost,0) BIV_MEASURE7
664: , nvl(iset.c_variance_cost,0) BIV_MEASURE8' || '
665: , ' ||
666: isc_maint_rpt_util_pkg.change_column
667: ( 'iset.c_variance_cost'
668: , 'iset.p_variance_cost'
669: , 'BIV_MEASURE9' ) || '
670: , ' ||

Line 671: isc_maint_rpt_util_pkg.rate_column

667: ( 'iset.c_variance_cost'
668: , 'iset.p_variance_cost'
669: , 'BIV_MEASURE9' ) || '
670: , ' ||
671: isc_maint_rpt_util_pkg.rate_column
672: ( 'iset.p_variance_cost'
673: , 'iset.p_estimated_cost'
674: , 'BIV_MEASURE10'
675: , 'Y' ) || '

Line 677: isc_maint_rpt_util_pkg.rate_column

673: , 'iset.p_estimated_cost'
674: , 'BIV_MEASURE10'
675: , 'Y' ) || '
676: , ' ||
677: isc_maint_rpt_util_pkg.rate_column
678: ( 'iset.c_variance_cost'
679: , 'iset.c_estimated_cost'
680: , 'BIV_MEASURE11'
681: , 'Y' ) || '

Line 683: isc_maint_rpt_util_pkg.change_column

679: , 'iset.c_estimated_cost'
680: , 'BIV_MEASURE11'
681: , 'Y' ) || '
682: , ' ||
683: isc_maint_rpt_util_pkg.change_column
684: ( isc_maint_rpt_util_pkg.rate_column
685: ( 'iset.c_variance_cost'
686: , 'iset.c_estimated_cost'
687: , null

Line 684: ( isc_maint_rpt_util_pkg.rate_column

680: , 'BIV_MEASURE11'
681: , 'Y' ) || '
682: , ' ||
683: isc_maint_rpt_util_pkg.change_column
684: ( isc_maint_rpt_util_pkg.rate_column
685: ( 'iset.c_variance_cost'
686: , 'iset.c_estimated_cost'
687: , null
688: , 'Y' )

Line 689: , isc_maint_rpt_util_pkg.rate_column

685: ( 'iset.c_variance_cost'
686: , 'iset.c_estimated_cost'
687: , null
688: , 'Y' )
689: , isc_maint_rpt_util_pkg.rate_column
690: ( 'iset.p_variance_cost'
691: , 'iset.p_estimated_cost'
692: , null
693: , 'Y' )

Line 707: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);

703: , p_use_grpid => 'N'
704: );
705:
706: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
707: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
708:
709: x_custom_sql := l_stmt;
710:
711: x_custom_output := l_custom_output;

Line 735: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

731: , x_custom_output out nocopy bis_query_attributes_tbl
732: )
733: as
734:
735: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
736: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
737: l_custom_output bis_query_attributes_tbl;
738: l_curr_suffix varchar2(3);
739: l_where_clause varchar2(10000);

Line 754: isc_maint_rpt_util_pkg.register_dimension_levels

750: l_inner_query varchar2(5000);
751: l_asset_grp_column varchar2(200);
752: begin
753:
754: isc_maint_rpt_util_pkg.register_dimension_levels
755: ( l_dimension_tbl
756: , l_dim_filter_map
757: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
758: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 757: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

753:
754: isc_maint_rpt_util_pkg.register_dimension_levels
755: ( l_dimension_tbl
756: , l_dim_filter_map
757: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
758: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
759: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
760: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
761: );

Line 758: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

754: isc_maint_rpt_util_pkg.register_dimension_levels
755: ( l_dimension_tbl
756: , l_dim_filter_map
757: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
758: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
759: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
760: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
761: );
762:

Line 759: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

755: ( l_dimension_tbl
756: , l_dim_filter_map
757: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
758: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
759: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
760: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
761: );
762:
763: isc_maint_rpt_util_pkg.process_parameters

Line 760: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'

756: , l_dim_filter_map
757: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
758: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
759: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
760: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
761: );
762:
763: isc_maint_rpt_util_pkg.process_parameters
764: ( p_param => p_param

Line 763: isc_maint_rpt_util_pkg.process_parameters

759: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
760: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
761: );
762:
763: isc_maint_rpt_util_pkg.process_parameters
764: ( p_param => p_param
765: , p_dimension_tbl => l_dimension_tbl
766: , p_dim_filter_map => l_dim_filter_map
767: , p_trend => 'N'

Line 778: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id

774: , x_comparison_type => l_comparison_type
775: , x_xtd => l_xtd
776: );
777:
778: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
779: ( p_param
780: , isc_maint_rpt_util_pkg.G_ESTIMATED
781: );
782:

Line 780: , isc_maint_rpt_util_pkg.G_ESTIMATED

776: );
777:
778: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
779: ( p_param
780: , isc_maint_rpt_util_pkg.G_ESTIMATED
781: );
782:
783: l_mv := get_fact_mv_name
784: ( 'WORK_ORDER_COST'

Line 878: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =

874: , p_prior_code => poa_dbi_util_pkg.no_priors
875: );
876:
877: /* if view by is asset number add the asset_group column */
878: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
879: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
880: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
881: else
882: l_asset_grp_column :='NULL';

Line 879: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

875: );
876:
877: /* if view by is asset number add the asset_group column */
878: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
879: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
880: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
881: else
882: l_asset_grp_column :='NULL';
883: end if ;

Line 880: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);

876:
877: /* if view by is asset number add the asset_group column */
878: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
879: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
880: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
881: else
882: l_asset_grp_column :='NULL';
883: end if ;
884:

Line 924: isc_maint_rpt_util_pkg.rate_column

920: ' oset05.c_estimated_mat_cost BIV_MEASURE1
921: , oset05.c_actual_mat_cost BIV_MEASURE2
922: , oset05.c_variance_mat_cost BIV_MEASURE3' || '
923: , ' ||
924: isc_maint_rpt_util_pkg.rate_column
925: ( 'oset05.c_variance_mat_cost'
926: , 'oset05.c_estimated_mat_cost'
927: , 'BIV_MEASURE4'
928: , 'Y' ) || '

Line 933: isc_maint_rpt_util_pkg.rate_column

929: , oset05.c_estimated_lab_cost BIV_MEASURE5
930: , oset05.c_actual_lab_cost BIV_MEASURE6
931: , oset05.c_variance_lab_cost BIV_MEASURE7' || '
932: , ' ||
933: isc_maint_rpt_util_pkg.rate_column
934: ( 'oset05.c_variance_lab_cost'
935: , 'oset05.c_estimated_lab_cost'
936: , 'BIV_MEASURE8'
937: , 'Y' ) || '

Line 942: isc_maint_rpt_util_pkg.rate_column

938: , oset05.c_estimated_eqp_cost BIV_MEASURE9
939: , oset05.c_actual_eqp_cost BIV_MEASURE10
940: , oset05.c_variance_eqp_cost BIV_MEASURE11' || '
941: , ' ||
942: isc_maint_rpt_util_pkg.rate_column
943: ( 'oset05.c_variance_eqp_cost'
944: , 'oset05.c_estimated_eqp_cost'
945: , 'BIV_MEASURE12'
946: , 'Y' ) || '

Line 953: isc_maint_rpt_util_pkg.rate_column

949: , oset05.c_estimated_mat_cost_total BIV_MEASURE21
950: , oset05.c_actual_mat_cost_total BIV_MEASURE22
951: , oset05.c_variance_mat_cost_total BIV_MEASURE23' || '
952: , ' ||
953: isc_maint_rpt_util_pkg.rate_column
954: ( 'oset05.c_variance_mat_cost_total'
955: , 'oset05.c_estimated_mat_cost_total'
956: , 'BIV_MEASURE24'
957: , 'Y' ) || '

Line 962: isc_maint_rpt_util_pkg.rate_column

958: , oset05.c_estimated_lab_cost_total BIV_MEASURE25
959: , oset05.c_actual_lab_cost_total BIV_MEASURE26
960: , oset05.c_variance_lab_cost_total BIV_MEASURE27' || '
961: , ' ||
962: isc_maint_rpt_util_pkg.rate_column
963: ( 'oset05.c_variance_lab_cost_total'
964: , 'oset05.c_estimated_lab_cost_total'
965: , 'BIV_MEASURE28'
966: , 'Y' ) || '

Line 971: isc_maint_rpt_util_pkg.rate_column

967: , oset05.c_estimated_eqp_cost_total BIV_MEASURE29
968: , oset05.c_actual_eqp_cost_total BIV_MEASURE30
969: , oset05.c_variance_eqp_cost_total BIV_MEASURE31' || '
970: , ' ||
971: isc_maint_rpt_util_pkg.rate_column
972: ( 'oset05.c_variance_eqp_cost_total'
973: , 'oset05.c_estimated_eqp_cost_total'
974: , 'BIV_MEASURE32'
975: , 'Y' ) || '

Line 979: when isc_maint_rpt_util_pkg.get_parameter_id

975: , 'Y' ) || '
976: , oset05.c_estimated_tot_cost_total BIV_MEASURE33
977: , oset05.c_actual_tot_cost_total BIV_MEASURE34' ||
978: case
979: when isc_maint_rpt_util_pkg.get_parameter_id
980: ( p_param
981: , 'VIEW_BY'
982: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
983: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

Line 982: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP

978: case
979: when isc_maint_rpt_util_pkg.get_parameter_id
980: ( p_param
981: , 'VIEW_BY'
982: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
983: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
984: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then
985: '
986: , ''pFunctionName=ISC_MAINT_WO_CST_DTL_RPT_REP'' ||

Line 983: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

979: when isc_maint_rpt_util_pkg.get_parameter_id
980: ( p_param
981: , 'VIEW_BY'
982: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
983: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
984: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then
985: '
986: , ''pFunctionName=ISC_MAINT_WO_CST_DTL_RPT_REP'' ||
987: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||

Line 984: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then

980: ( p_param
981: , 'VIEW_BY'
982: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
983: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
984: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then
985: '
986: , ''pFunctionName=ISC_MAINT_WO_CST_DTL_RPT_REP'' ||
987: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||
988: ''&pParamIds=Y'' BIV_ATTRIBUTE5 '

Line 992: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';

988: ''&pParamIds=Y'' BIV_ATTRIBUTE5 '
989: else '
990: , null BIV_ATTRIBUTE5'
991: end || ', ' ||
992: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
993: l_stmt := l_stmt || l_inner_query || poa_dbi_template_pkg.status_sql
994: ( p_fact_name => l_mv
995: , p_where_clause => l_where_clause
996: , p_join_tables => l_join_tbl

Line 1009: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);

1005: );
1006:
1007:
1008: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
1009: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
1010: x_custom_sql := l_stmt;
1011: x_custom_output := l_custom_output;
1012:
1013: end get_sum_tbl_sql;

Line 1022: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

1018: , x_custom_output out nocopy bis_query_attributes_tbl
1019: )
1020: as
1021:
1022: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1023: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1024: l_custom_output bis_query_attributes_tbl;
1025: l_curr_suffix varchar2(3);
1026: l_where_clause varchar2(10000);

Line 1038: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

1034: l_estimated varchar2(200);
1035: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1036: l_stmt varchar2(32767);
1037: l_rank_order varchar2(200);
1038: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
1039: l_order_by varchar2(200);
1040: l_asc_desc varchar2(100);
1041:
1042: begin

Line 1044: isc_maint_rpt_util_pkg.register_dimension_levels

1040: l_asc_desc varchar2(100);
1041:
1042: begin
1043:
1044: isc_maint_rpt_util_pkg.register_dimension_levels
1045: ( l_dimension_tbl
1046: , l_dim_filter_map
1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

1043:
1044: isc_maint_rpt_util_pkg.register_dimension_levels
1045: ( l_dimension_tbl
1046: , l_dim_filter_map
1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1049: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

Line 1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

1044: isc_maint_rpt_util_pkg.register_dimension_levels
1045: ( l_dimension_tbl
1046: , l_dim_filter_map
1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1049: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1052: );

Line 1049: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

1045: ( l_dimension_tbl
1046: , l_dim_filter_map
1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1049: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1052: );
1053:

Line 1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'

1046: , l_dim_filter_map
1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1049: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1052: );
1053:
1054: isc_maint_rpt_util_pkg.process_parameters

Line 1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

1047: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1048: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1049: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1052: );
1053:
1054: isc_maint_rpt_util_pkg.process_parameters
1055: ( p_param => p_param

Line 1054: isc_maint_rpt_util_pkg.process_parameters

1050: , isc_maint_rpt_util_pkg.G_COST_CATEGORY, 'Y'
1051: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1052: );
1053:
1054: isc_maint_rpt_util_pkg.process_parameters
1055: ( p_param => p_param
1056: , p_dimension_tbl => l_dimension_tbl
1057: , p_dim_filter_map => l_dim_filter_map
1058: , p_trend => 'D'

Line 1069: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id

1065: , x_comparison_type => l_comparison_type
1066: , x_xtd => l_xtd
1067: );
1068:
1069: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
1070: ( p_param
1071: , isc_maint_rpt_util_pkg.G_ESTIMATED
1072: );
1073:

Line 1071: , isc_maint_rpt_util_pkg.G_ESTIMATED

1067: );
1068:
1069: l_estimated := isc_maint_rpt_util_pkg.get_parameter_id
1070: ( p_param
1071: , isc_maint_rpt_util_pkg.G_ESTIMATED
1072: );
1073:
1074: if l_estimated = 'NONZERO' then
1075: l_where_clause := l_where_clause || ' and fact.estimated_flag = ''Y''';

Line 1088: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value

1084: , l_custom_output
1085: , null
1086: );
1087:
1088: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value
1089: ( p_param
1090: , 'ORDERBY'
1091: );
1092:

Line 1116: isc_maint_rpt_util_pkg.rate_column

1112: 'estimated_tot_cost_' || l_curr_suffix
1113: when l_order_by like '%BIV_MEASURE6 %' then
1114: 'variance_tot_cost_' || l_curr_suffix
1115: else -- '%BIV_MEASURE7 %'
1116: isc_maint_rpt_util_pkg.rate_column
1117: ( 'variance_tot_cost_' || l_curr_suffix
1118: , 'estimated_tot_cost_' || l_curr_suffix
1119: , null
1120: , 'Y' )

Line 1125: isc_maint_rpt_util_pkg.add_detail_column

1121: end ||
1122: l_asc_desc ||
1123: 'nulls last, organization_id, work_order_id';
1124:
1125: isc_maint_rpt_util_pkg.add_detail_column
1126: ( p_detail_col_tbl => l_detail_col_tbl
1127: , p_dimension_tbl => l_dimension_tbl
1128: , p_fact_col_name => 'work_order_id'
1129: , p_fact_col_total => 'N'

Line 1133: isc_maint_rpt_util_pkg.add_detail_column

1129: , p_fact_col_total => 'N'
1130: , p_column_key => 'work_order_id'
1131: );
1132:
1133: isc_maint_rpt_util_pkg.add_detail_column
1134: ( p_detail_col_tbl => l_detail_col_tbl
1135: , p_dimension_tbl => l_dimension_tbl
1136: , p_fact_col_name => 'work_order_name'
1137: , p_fact_col_total => 'N'

Line 1141: isc_maint_rpt_util_pkg.add_detail_column

1137: , p_fact_col_total => 'N'
1138: , p_column_key => 'work_order_name'
1139: );
1140:
1141: isc_maint_rpt_util_pkg.add_detail_column
1142: ( p_detail_col_tbl => l_detail_col_tbl
1143: , p_dimension_tbl => l_dimension_tbl
1144: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1145: , p_column_key => 'work_order_type'

Line 1144: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE

1140:
1141: isc_maint_rpt_util_pkg.add_detail_column
1142: ( p_detail_col_tbl => l_detail_col_tbl
1143: , p_dimension_tbl => l_dimension_tbl
1144: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1145: , p_column_key => 'work_order_type'
1146: );
1147:
1148: isc_maint_rpt_util_pkg.add_detail_column

Line 1148: isc_maint_rpt_util_pkg.add_detail_column

1144: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1145: , p_column_key => 'work_order_type'
1146: );
1147:
1148: isc_maint_rpt_util_pkg.add_detail_column
1149: ( p_detail_col_tbl => l_detail_col_tbl
1150: , p_dimension_tbl => l_dimension_tbl
1151: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
1152: , p_column_key => 'asset_number'

Line 1151: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER

1147:
1148: isc_maint_rpt_util_pkg.add_detail_column
1149: ( p_detail_col_tbl => l_detail_col_tbl
1150: , p_dimension_tbl => l_dimension_tbl
1151: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
1152: , p_column_key => 'asset_number'
1153: );
1154:
1155: isc_maint_rpt_util_pkg.add_detail_column

Line 1155: isc_maint_rpt_util_pkg.add_detail_column

1151: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
1152: , p_column_key => 'asset_number'
1153: );
1154:
1155: isc_maint_rpt_util_pkg.add_detail_column
1156: ( p_detail_col_tbl => l_detail_col_tbl
1157: , p_dimension_tbl => l_dimension_tbl
1158: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
1159: , p_column_key => 'asset_group'

Line 1158: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP

1154:
1155: isc_maint_rpt_util_pkg.add_detail_column
1156: ( p_detail_col_tbl => l_detail_col_tbl
1157: , p_dimension_tbl => l_dimension_tbl
1158: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
1159: , p_column_key => 'asset_group'
1160: );
1161:
1162: isc_maint_rpt_util_pkg.add_detail_column

Line 1162: isc_maint_rpt_util_pkg.add_detail_column

1158: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
1159: , p_column_key => 'asset_group'
1160: );
1161:
1162: isc_maint_rpt_util_pkg.add_detail_column
1163: ( p_detail_col_tbl => l_detail_col_tbl
1164: , p_dimension_tbl => l_dimension_tbl
1165: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1166: , p_column_key => 'activity'

Line 1165: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY

1161:
1162: isc_maint_rpt_util_pkg.add_detail_column
1163: ( p_detail_col_tbl => l_detail_col_tbl
1164: , p_dimension_tbl => l_dimension_tbl
1165: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1166: , p_column_key => 'activity'
1167: );
1168:
1169: isc_maint_rpt_util_pkg.add_detail_column

Line 1169: isc_maint_rpt_util_pkg.add_detail_column

1165: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1166: , p_column_key => 'activity'
1167: );
1168:
1169: isc_maint_rpt_util_pkg.add_detail_column
1170: ( p_detail_col_tbl => l_detail_col_tbl
1171: , p_dimension_tbl => l_dimension_tbl
1172: , p_fact_col_name => 'status_name'
1173: , p_fact_col_total => 'N'

Line 1177: isc_maint_rpt_util_pkg.add_detail_column

1173: , p_fact_col_total => 'N'
1174: , p_column_key => 'wo_status'
1175: );
1176:
1177: isc_maint_rpt_util_pkg.add_detail_column
1178: ( p_detail_col_tbl => l_detail_col_tbl
1179: , p_dimension_tbl => l_dimension_tbl
1180: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
1181: , p_column_key => 'department'

Line 1180: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT

1176:
1177: isc_maint_rpt_util_pkg.add_detail_column
1178: ( p_detail_col_tbl => l_detail_col_tbl
1179: , p_dimension_tbl => l_dimension_tbl
1180: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
1181: , p_column_key => 'department'
1182: );
1183:
1184: isc_maint_rpt_util_pkg.add_detail_column

Line 1184: isc_maint_rpt_util_pkg.add_detail_column

1180: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
1181: , p_column_key => 'department'
1182: );
1183:
1184: isc_maint_rpt_util_pkg.add_detail_column
1185: ( p_detail_col_tbl => l_detail_col_tbl
1186: , p_dimension_tbl => l_dimension_tbl
1187: , p_fact_col_name => 'actual_mat_cost_' || l_curr_suffix
1188: , p_fact_col_total => 'Y'

Line 1192: isc_maint_rpt_util_pkg.add_detail_column

1188: , p_fact_col_total => 'Y'
1189: , p_column_key => 'actual_mat_cost'
1190: );
1191:
1192: isc_maint_rpt_util_pkg.add_detail_column
1193: ( p_detail_col_tbl => l_detail_col_tbl
1194: , p_dimension_tbl => l_dimension_tbl
1195: , p_fact_col_name => 'actual_lab_cost_' || l_curr_suffix
1196: , p_fact_col_total => 'Y'

Line 1200: isc_maint_rpt_util_pkg.add_detail_column

1196: , p_fact_col_total => 'Y'
1197: , p_column_key => 'actual_lab_cost'
1198: );
1199:
1200: isc_maint_rpt_util_pkg.add_detail_column
1201: ( p_detail_col_tbl => l_detail_col_tbl
1202: , p_dimension_tbl => l_dimension_tbl
1203: , p_fact_col_name => 'actual_eqp_cost_' || l_curr_suffix
1204: , p_fact_col_total => 'Y'

Line 1208: isc_maint_rpt_util_pkg.add_detail_column

1204: , p_fact_col_total => 'Y'
1205: , p_column_key => 'actual_eqp_cost'
1206: );
1207:
1208: isc_maint_rpt_util_pkg.add_detail_column
1209: ( p_detail_col_tbl => l_detail_col_tbl
1210: , p_dimension_tbl => l_dimension_tbl
1211: , p_fact_col_name => 'actual_tot_cost_' || l_curr_suffix
1212: , p_fact_col_total => 'Y'

Line 1216: isc_maint_rpt_util_pkg.add_detail_column

1212: , p_fact_col_total => 'Y'
1213: , p_column_key => 'actual_tot_cost'
1214: );
1215:
1216: isc_maint_rpt_util_pkg.add_detail_column
1217: ( p_detail_col_tbl => l_detail_col_tbl
1218: , p_dimension_tbl => l_dimension_tbl
1219: , p_fact_col_name => 'estimated_tot_cost_' || l_curr_suffix
1220: , p_fact_col_total => 'Y'

Line 1224: isc_maint_rpt_util_pkg.add_detail_column

1220: , p_fact_col_total => 'Y'
1221: , p_column_key => 'estimated_tot_cost'
1222: );
1223:
1224: isc_maint_rpt_util_pkg.add_detail_column
1225: ( p_detail_col_tbl => l_detail_col_tbl
1226: , p_dimension_tbl => l_dimension_tbl
1227: , p_fact_col_name => 'variance_tot_cost_' || l_curr_suffix
1228: , p_fact_col_total => 'Y'

Line 1234: , ' || isc_maint_rpt_util_pkg.get_detail_column

1230: );
1231:
1232: l_stmt := 'select
1233: oset.work_order_name BIV_ATTRIBUTE1
1234: , ' || isc_maint_rpt_util_pkg.get_detail_column
1235: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1236: , ' || isc_maint_rpt_util_pkg.get_detail_column
1237: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1238: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1236: , ' || isc_maint_rpt_util_pkg.get_detail_column

1232: l_stmt := 'select
1233: oset.work_order_name BIV_ATTRIBUTE1
1234: , ' || isc_maint_rpt_util_pkg.get_detail_column
1235: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1236: , ' || isc_maint_rpt_util_pkg.get_detail_column
1237: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1238: , ' || isc_maint_rpt_util_pkg.get_detail_column
1239: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1240: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1238: , ' || isc_maint_rpt_util_pkg.get_detail_column

1234: , ' || isc_maint_rpt_util_pkg.get_detail_column
1235: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1236: , ' || isc_maint_rpt_util_pkg.get_detail_column
1237: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1238: , ' || isc_maint_rpt_util_pkg.get_detail_column
1239: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1240: , ' || isc_maint_rpt_util_pkg.get_detail_column
1241: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1242: , oset.wo_status BIV_ATTRIBUTE6

Line 1240: , ' || isc_maint_rpt_util_pkg.get_detail_column

1236: , ' || isc_maint_rpt_util_pkg.get_detail_column
1237: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1238: , ' || isc_maint_rpt_util_pkg.get_detail_column
1239: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1240: , ' || isc_maint_rpt_util_pkg.get_detail_column
1241: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1242: , oset.wo_status BIV_ATTRIBUTE6
1243: , ' || isc_maint_rpt_util_pkg.get_detail_column
1244: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '

Line 1243: , ' || isc_maint_rpt_util_pkg.get_detail_column

1239: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1240: , ' || isc_maint_rpt_util_pkg.get_detail_column
1241: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1242: , oset.wo_status BIV_ATTRIBUTE6
1243: , ' || isc_maint_rpt_util_pkg.get_detail_column
1244: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
1245: , oset.actual_mat_cost BIV_MEASURE1
1246: , oset.actual_lab_cost BIV_MEASURE2
1247: , oset.actual_eqp_cost BIV_MEASURE3

Line 1252: isc_maint_rpt_util_pkg.rate_column

1248: , oset.actual_tot_cost BIV_MEASURE4
1249: , oset.estimated_tot_cost BIV_MEASURE5
1250: , oset.variance_tot_cost BIV_MEASURE6
1251: , ' ||
1252: isc_maint_rpt_util_pkg.rate_column
1253: ( 'oset.variance_tot_cost'
1254: , 'oset.estimated_tot_cost'
1255: , 'BIV_MEASURE7'
1256: , 'Y' ) || '

Line 1258: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '

1254: , 'oset.estimated_tot_cost'
1255: , 'BIV_MEASURE7'
1256: , 'Y' ) || '
1257: , ' ||
1258: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '
1259: , oset.actual_mat_cost_total BIV_MEASURE8
1260: , oset.actual_lab_cost_total BIV_MEASURE9
1261: , oset.actual_eqp_cost_total BIV_MEASURE10
1262: , oset.actual_tot_cost_total BIV_MEASURE11

Line 1266: isc_maint_rpt_util_pkg.rate_column

1262: , oset.actual_tot_cost_total BIV_MEASURE11
1263: , oset.estimated_tot_cost_total BIV_MEASURE12
1264: , oset.variance_tot_cost_total BIV_MEASURE13
1265: , ' ||
1266: isc_maint_rpt_util_pkg.rate_column
1267: ( 'oset.variance_tot_cost_total'
1268: , 'oset.estimated_tot_cost_total'
1269: , 'BIV_MEASURE14'
1270: , 'Y' ) || '

Line 1272: ' || isc_maint_rpt_util_pkg.detail_sql

1268: , 'oset.estimated_tot_cost_total'
1269: , 'BIV_MEASURE14'
1270: , 'Y' ) || '
1271: from
1272: ' || isc_maint_rpt_util_pkg.detail_sql
1273: ( p_detail_col_tbl => l_detail_col_tbl
1274: , p_dimension_tbl => l_dimension_tbl
1275: , p_mv_name => l_mv
1276: , p_where_clause => l_where_clause

Line 1281: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);

1277: , p_rank_order => l_rank_order
1278: );
1279:
1280: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
1281: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
1282:
1283: x_custom_sql := l_stmt;
1284:
1285: x_custom_output := l_custom_output;