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

Line 19: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id

15: l_view_by varchar2(200);
16:
17: begin
18:
19: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
20: ( p_param
21: , isc_maint_rpt_util_pkg.G_ORGANIZATION
22: );
23:

Line 21: , isc_maint_rpt_util_pkg.G_ORGANIZATION

17: begin
18:
19: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
20: ( p_param
21: , isc_maint_rpt_util_pkg.G_ORGANIZATION
22: );
23:
24: if p_report_type = 'WORK_ORDER_CMPL' then
25:

Line 26: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

22: );
23:
24: if p_report_type = 'WORK_ORDER_CMPL' then
25:
26: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
27: ( p_param
28: , 'VIEW_BY'
29: );
30:

Line 31: isc_maint_rpt_util_pkg.bind_group_id

27: ( p_param
28: , 'VIEW_BY'
29: );
30:
31: isc_maint_rpt_util_pkg.bind_group_id
32: ( p_dim_bmap
33: , p_custom_output
34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */
35: , isc_maint_rpt_util_pkg.G_ACTIVITY

Line 34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */

30:
31: isc_maint_rpt_util_pkg.bind_group_id
32: ( p_dim_bmap
33: , p_custom_output
34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */
35: , isc_maint_rpt_util_pkg.G_ACTIVITY
36: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
37: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
38: /* , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE Removed rollup from MV */

Line 35: , isc_maint_rpt_util_pkg.G_ACTIVITY

31: isc_maint_rpt_util_pkg.bind_group_id
32: ( p_dim_bmap
33: , p_custom_output
34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */
35: , isc_maint_rpt_util_pkg.G_ACTIVITY
36: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
37: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
38: /* , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE Removed rollup from MV */
39: );

Line 36: , isc_maint_rpt_util_pkg.G_ASSET_GROUP

32: ( p_dim_bmap
33: , p_custom_output
34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */
35: , isc_maint_rpt_util_pkg.G_ACTIVITY
36: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
37: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
38: /* , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE Removed rollup from MV */
39: );
40:

Line 37: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

33: , p_custom_output
34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */
35: , isc_maint_rpt_util_pkg.G_ACTIVITY
36: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
37: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
38: /* , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE Removed rollup from MV */
39: );
40:
41: return ' (select

Line 38: /* , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE Removed rollup from MV */

34: /* , isc_maint_rpt_util_pkg.G_DEPARTMENT Removed rollup from MV */
35: , isc_maint_rpt_util_pkg.G_ACTIVITY
36: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
37: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
38: /* , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE Removed rollup from MV */
39: );
40:
41: return ' (select
42: time_id

Line 47: when isc_maint_rpt_util_pkg.G_DEPARTMENT then 'decode(department_id,-1,-1,organization_id) organization_id'

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

Line 48: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then 'decode(asset_group_id,-1,-1,organization_id) organization_id'

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

Line 49: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,organization_id) organization_id' /* replaced asset_number with instance_id */

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

Line 50: when isc_maint_rpt_util_pkg.G_ACTIVITY then 'decode(activity_id,-1,-1,organization_id) organization_id'

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

Line 56: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,asset_group_id) asset_group_id ' /* replaced asset_number with instance_id */

52: end ||'
53: , organization_id organization_id_c
54: , ' ||
55: case l_view_by
56: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,asset_group_id) asset_group_id ' /* replaced asset_number with instance_id */
57: else 'asset_group_id'
58: end ||'
59: , instance_id /* replaced asset_number with instance_id */
60: , activity_id

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

71: where fact.grp_id = &ISC_GRP_ID ' ||
72: case
73: when l_org_id is null then
74: '
75: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
76: end || '
77: )';
78:
79: elsif p_report_type = 'WORK_ORDER_LATE_CMPL_AGING' then

Line 81: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

77: )';
78:
79: elsif p_report_type = 'WORK_ORDER_LATE_CMPL_AGING' then
80:
81: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
82: ( p_param
83: , 'VIEW_BY'
84: );
85:

Line 86: isc_maint_rpt_util_pkg.bind_group_id

82: ( p_param
83: , 'VIEW_BY'
84: );
85:
86: isc_maint_rpt_util_pkg.bind_group_id
87: ( p_dim_bmap
88: , p_custom_output
89: , isc_maint_rpt_util_pkg.G_DEPARTMENT
90: , isc_maint_rpt_util_pkg.G_ACTIVITY

Line 89: , isc_maint_rpt_util_pkg.G_DEPARTMENT

85:
86: isc_maint_rpt_util_pkg.bind_group_id
87: ( p_dim_bmap
88: , p_custom_output
89: , isc_maint_rpt_util_pkg.G_DEPARTMENT
90: , isc_maint_rpt_util_pkg.G_ACTIVITY
91: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
92: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
93: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE

Line 90: , isc_maint_rpt_util_pkg.G_ACTIVITY

86: isc_maint_rpt_util_pkg.bind_group_id
87: ( p_dim_bmap
88: , p_custom_output
89: , isc_maint_rpt_util_pkg.G_DEPARTMENT
90: , isc_maint_rpt_util_pkg.G_ACTIVITY
91: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
92: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
93: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
94: );

Line 91: , isc_maint_rpt_util_pkg.G_ASSET_GROUP

87: ( p_dim_bmap
88: , p_custom_output
89: , isc_maint_rpt_util_pkg.G_DEPARTMENT
90: , isc_maint_rpt_util_pkg.G_ACTIVITY
91: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
92: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
93: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
94: );
95:

Line 92: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

88: , p_custom_output
89: , isc_maint_rpt_util_pkg.G_DEPARTMENT
90: , isc_maint_rpt_util_pkg.G_ACTIVITY
91: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
92: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
93: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
94: );
95:
96: return ' (select

Line 93: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE

89: , isc_maint_rpt_util_pkg.G_DEPARTMENT
90: , isc_maint_rpt_util_pkg.G_ACTIVITY
91: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
92: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
93: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
94: );
95:
96: return ' (select
97: time_id

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

114: where fact.grp_id = &ISC_GRP_ID ' ||
115: case
116: when l_org_id is null then
117: '
118: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
119: end || '
120: )';
121:
122:

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

149: and f.COMPLETION_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE ' ||
150: case
151: when l_org_id is null then
152: '
153: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'f', l_org_id )
154: end || '
155: ) ';
156:
157: elsif p_report_type = 'WORK_ORDER_LATE_DTL' then

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

201: and f.COMPLETION_DATE >= &BIS_CURRENT_EFFECTIVE_START_DATE ' ||
202: case
203: when l_org_id is null then
204: '
205: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'f', l_org_id )
206: end || '
207: ) ';
208:
209: end if;

Line 221: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

217: , x_custom_output out nocopy bis_query_attributes_tbl
218: )
219: is
220:
221: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
222: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
223: l_dim_bmap number;
224: l_comparison_type varchar2(200);
225: l_xtd varchar2(200);

Line 248: isc_maint_rpt_util_pkg.register_dimension_levels

244: -- clear out the tables.
245: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
246: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
247:
248: isc_maint_rpt_util_pkg.register_dimension_levels
249: ( l_dimension_tbl
250: , l_dim_filter_map
251: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
252: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 251: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

247:
248: isc_maint_rpt_util_pkg.register_dimension_levels
249: ( l_dimension_tbl
250: , l_dim_filter_map
251: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
252: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
253: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
255: );

Line 252: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

248: isc_maint_rpt_util_pkg.register_dimension_levels
249: ( l_dimension_tbl
250: , l_dim_filter_map
251: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
252: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
253: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
255: );
256:

Line 253: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

249: ( l_dimension_tbl
250: , l_dim_filter_map
251: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
252: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
253: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
255: );
256:
257: isc_maint_rpt_util_pkg.process_parameters

Line 254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

250: , l_dim_filter_map
251: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
252: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
253: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
255: );
256:
257: isc_maint_rpt_util_pkg.process_parameters
258: ( p_param => p_param

Line 257: isc_maint_rpt_util_pkg.process_parameters

253: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
255: );
256:
257: isc_maint_rpt_util_pkg.process_parameters
258: ( p_param => p_param
259: , p_dimension_tbl => l_dimension_tbl
260: , p_dim_filter_map => l_dim_filter_map
261: , p_trend => 'N'

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

291: 'days_late');
292:
293: /* if view by is asset number add asset_group column */
294:
295: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
296: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
297: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
298: else
299: l_asset_grp_column :='NULL';

Line 296: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

292:
293: /* if view by is asset number add asset_group column */
294:
295: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
296: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
297: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
298: else
299: l_asset_grp_column :='NULL';
300: end if ;

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

293: /* if view by is asset number add asset_group column */
294:
295: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
296: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
297: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
298: else
299: l_asset_grp_column :='NULL';
300: end if ;
301:

Line 340: when isc_maint_rpt_util_pkg.get_parameter_id

336:
337: l_inner_query := 'from ( select row_number() over(&ORDER_BY_CLAUSE)-1 rnk,iset.*
338: from (select '||
339: case
340: when isc_maint_rpt_util_pkg.get_parameter_id
341: ( p_param
342: , 'VIEW_BY'
343: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
344: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

Line 343: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP

339: case
340: when isc_maint_rpt_util_pkg.get_parameter_id
341: ( p_param
342: , 'VIEW_BY'
343: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
344: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
345: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then
346: '
347: ''pFunctionName=ISC_MAINT_WO_CMPL_DTL_RPT_REP'' ||

Line 344: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

340: when isc_maint_rpt_util_pkg.get_parameter_id
341: ( p_param
342: , 'VIEW_BY'
343: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
344: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
345: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then
346: '
347: ''pFunctionName=ISC_MAINT_WO_CMPL_DTL_RPT_REP'' ||
348: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||

Line 345: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then

341: ( p_param
342: , 'VIEW_BY'
343: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
344: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
345: , isc_maint_rpt_util_pkg.G_ACTIVITY ) then
346: '
347: ''pFunctionName=ISC_MAINT_WO_CMPL_DTL_RPT_REP'' ||
348: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||
349: ''&pParamIds=Y'' BIV_ATTRIBUTE1 '

Line 358: isc_maint_rpt_util_pkg.change_column

354: ''&pParamIds=Y'' BIV_ATTRIBUTE2
355: , nvl(oset05.p_num_completion,0) BIV_MEASURE1
356: , nvl(oset05.c_num_completion,0) BIV_MEASURE2' || '
357: , ' ||
358: isc_maint_rpt_util_pkg.change_column
359: ( 'oset05.c_num_completion'
360: , 'oset05.p_num_completion'
361: , 'BIV_MEASURE3' ) || ' /* Completion Change */
362: , nvl(oset05.p_num_completion - oset05.p_num_late_completion,0) BIV_MEASURE22

Line 365: isc_maint_rpt_util_pkg.change_column

361: , 'BIV_MEASURE3' ) || ' /* Completion Change */
362: , nvl(oset05.p_num_completion - oset05.p_num_late_completion,0) BIV_MEASURE22
363: , nvl(oset05.c_num_completion - oset05.c_num_late_completion,0) BIV_MEASURE4 ' || '
364: , ' ||
365: isc_maint_rpt_util_pkg.change_column
366: ( 'oset05.c_num_completion - oset05.c_num_late_completion'
367: , 'oset05.p_num_completion - oset05.p_num_late_completion'
368: , 'BIV_MEASURE23' ) || ' /* On Time Completion Change */
369: , ' ||

Line 370: isc_maint_rpt_util_pkg.rate_column

366: ( 'oset05.c_num_completion - oset05.c_num_late_completion'
367: , 'oset05.p_num_completion - oset05.p_num_late_completion'
368: , 'BIV_MEASURE23' ) || ' /* On Time Completion Change */
369: , ' ||
370: isc_maint_rpt_util_pkg.rate_column
371: ( 'oset05.p_num_completion - oset05.p_num_late_completion'
372: , 'oset05.p_num_completion'
373: , 'BIV_MEASURE5'
374: , 'Y' ) || '

Line 376: isc_maint_rpt_util_pkg.rate_column

372: , 'oset05.p_num_completion'
373: , 'BIV_MEASURE5'
374: , 'Y' ) || '
375: /* Prior On time completion percent */, ' ||
376: isc_maint_rpt_util_pkg.rate_column
377: ( 'oset05.c_num_completion - oset05.c_num_late_completion'
378: , 'oset05.c_num_completion'
379: , 'BIV_MEASURE6'
380: , 'Y' ) || '

Line 382: isc_maint_rpt_util_pkg.change_column

378: , 'oset05.c_num_completion'
379: , 'BIV_MEASURE6'
380: , 'Y' ) || '
381: /* On time completion percent */, ' ||
382: isc_maint_rpt_util_pkg.change_column
383: ( isc_maint_rpt_util_pkg.rate_column
384: ( 'oset05.c_num_completion - oset05.c_num_late_completion'
385: , 'oset05.c_num_completion'
386: , ''

Line 383: ( isc_maint_rpt_util_pkg.rate_column

379: , 'BIV_MEASURE6'
380: , 'Y' ) || '
381: /* On time completion percent */, ' ||
382: isc_maint_rpt_util_pkg.change_column
383: ( isc_maint_rpt_util_pkg.rate_column
384: ( 'oset05.c_num_completion - oset05.c_num_late_completion'
385: , 'oset05.c_num_completion'
386: , ''
387: , 'Y' )

Line 388: , isc_maint_rpt_util_pkg.rate_column

384: ( 'oset05.c_num_completion - oset05.c_num_late_completion'
385: , 'oset05.c_num_completion'
386: , ''
387: , 'Y' )
388: , isc_maint_rpt_util_pkg.rate_column
389: ( 'oset05.p_num_completion - oset05.p_num_late_completion'
390: , 'oset05.p_num_completion'
391: , ''
392: , 'Y' )

Line 397: isc_maint_rpt_util_pkg.rate_column

393: , 'BIV_MEASURE7'
394: , 'N' ) || ' /* On Time Completion Change */
395: , nvl(oset05.c_num_late_completion,0) BIV_MEASURE8 ' || '
396: , ' ||
397: isc_maint_rpt_util_pkg.rate_column
398: ( 'oset05.p_num_late_completion'
399: , 'oset05.p_num_completion'
400: , 'BIV_MEASURE9'
401: , 'Y' ) || '

Line 403: isc_maint_rpt_util_pkg.rate_column

399: , 'oset05.p_num_completion'
400: , 'BIV_MEASURE9'
401: , 'Y' ) || '
402: /* Late Completion Percent */, ' ||
403: isc_maint_rpt_util_pkg.rate_column
404: ( 'oset05.c_num_late_completion'
405: , 'oset05.c_num_completion'
406: , 'BIV_MEASURE10'
407: , 'Y' ) || '

Line 409: isc_maint_rpt_util_pkg.change_column

405: , 'oset05.c_num_completion'
406: , 'BIV_MEASURE10'
407: , 'Y' ) || '
408: /* Prior Late Completion Percent */, ' ||
409: isc_maint_rpt_util_pkg.change_column
410: ( isc_maint_rpt_util_pkg.rate_column
411: ( 'oset05.c_num_late_completion'
412: , 'oset05.c_num_completion'
413: , ''

Line 410: ( isc_maint_rpt_util_pkg.rate_column

406: , 'BIV_MEASURE10'
407: , 'Y' ) || '
408: /* Prior Late Completion Percent */, ' ||
409: isc_maint_rpt_util_pkg.change_column
410: ( isc_maint_rpt_util_pkg.rate_column
411: ( 'oset05.c_num_late_completion'
412: , 'oset05.c_num_completion'
413: , ''
414: , 'Y' )

Line 415: , isc_maint_rpt_util_pkg.rate_column

411: ( 'oset05.c_num_late_completion'
412: , 'oset05.c_num_completion'
413: , ''
414: , 'Y' )
415: , isc_maint_rpt_util_pkg.rate_column
416: ( 'oset05.p_num_late_completion'
417: , 'oset05.p_num_completion'
418: , ''
419: , 'Y' )

Line 423: isc_maint_rpt_util_pkg.rate_column

419: , 'Y' )
420: , 'BIV_MEASURE11'
421: , 'N' ) || '
422: /* Late Completion Change */, ' ||
423: isc_maint_rpt_util_pkg.rate_column
424: ( 'oset05.c_days_late'
425: , 'oset05.c_num_late_completion'
426: , 'BIV_MEASURE12'
427: , 'N' ) || ' /* Average Days Late */

Line 431: isc_maint_rpt_util_pkg.rate_column

427: , 'N' ) || ' /* Average Days Late */
428: , nvl(oset05.p_num_completion_total,0) BIV_MEASURE26 ' || '
429: , nvl(oset05.c_num_completion_total,0) BIV_MEASURE13 ' || '
430: , ' ||
431: isc_maint_rpt_util_pkg.rate_column
432: ( 'oset05.c_num_completion_total - oset05.p_num_completion_total'
433: , 'oset05.p_num_completion_total'
434: , 'BIV_MEASURE14'
435: , 'Y' ) || ' /* Grand Total Completion Change */

Line 438: isc_maint_rpt_util_pkg.rate_column

434: , 'BIV_MEASURE14'
435: , 'Y' ) || ' /* Grand Total Completion Change */
436: , nvl(oset05.c_num_completion_total - oset05.c_num_late_completion_total,0) BIV_MEASURE15 ' || '
437: , ' ||
438: isc_maint_rpt_util_pkg.rate_column
439: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
440: , 'oset05.p_num_completion_total - oset05.p_num_late_completion_total'
441: , 'BIV_MEASURE24'
442: , 'Y' ) || ' /* Grand Total On time completion Change */, ' ||

Line 443: isc_maint_rpt_util_pkg.rate_column

439: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
440: , 'oset05.p_num_completion_total - oset05.p_num_late_completion_total'
441: , 'BIV_MEASURE24'
442: , 'Y' ) || ' /* Grand Total On time completion Change */, ' ||
443: isc_maint_rpt_util_pkg.rate_column
444: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
445: , 'oset05.c_num_completion_total'
446: , 'BIV_MEASURE16'
447: , 'Y' ) || ' /* On time completion percent Grand Total */, ' ||

Line 448: isc_maint_rpt_util_pkg.change_column

444: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
445: , 'oset05.c_num_completion_total'
446: , 'BIV_MEASURE16'
447: , 'Y' ) || ' /* On time completion percent Grand Total */, ' ||
448: isc_maint_rpt_util_pkg.change_column
449: ( isc_maint_rpt_util_pkg.rate_column
450: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
451: , 'oset05.c_num_completion_total'
452: , ''

Line 449: ( isc_maint_rpt_util_pkg.rate_column

445: , 'oset05.c_num_completion_total'
446: , 'BIV_MEASURE16'
447: , 'Y' ) || ' /* On time completion percent Grand Total */, ' ||
448: isc_maint_rpt_util_pkg.change_column
449: ( isc_maint_rpt_util_pkg.rate_column
450: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
451: , 'oset05.c_num_completion_total'
452: , ''
453: , 'Y' )

Line 454: , isc_maint_rpt_util_pkg.rate_column

450: ( 'oset05.c_num_completion_total - oset05.c_num_late_completion_total'
451: , 'oset05.c_num_completion_total'
452: , ''
453: , 'Y' )
454: , isc_maint_rpt_util_pkg.rate_column
455: ( 'oset05.p_num_completion_total - oset05.p_num_late_completion_total'
456: , 'oset05.p_num_completion_total'
457: , ''
458: , 'Y' )

Line 462: isc_maint_rpt_util_pkg.rate_column

458: , 'Y' )
459: , 'BIV_MEASURE17'
460: , 'N' ) || ' /* Grand Total On Time Completion Percent Change */
461: , nvl(oset05.c_num_late_completion_total,0) BIV_MEASURE18, ' ||
462: isc_maint_rpt_util_pkg.rate_column
463: ( 'oset05.p_num_late_completion_total'
464: , 'oset05.p_num_completion_total'
465: , 'BIV_MEASURE28'
466: , 'Y' ) || ' /* Prior Late Completion Percent Grand Total */, ' ||

Line 467: isc_maint_rpt_util_pkg.rate_column

463: ( 'oset05.p_num_late_completion_total'
464: , 'oset05.p_num_completion_total'
465: , 'BIV_MEASURE28'
466: , 'Y' ) || ' /* Prior Late Completion Percent Grand Total */, ' ||
467: isc_maint_rpt_util_pkg.rate_column
468: ( 'oset05.c_num_late_completion_total'
469: , 'oset05.c_num_completion_total'
470: , 'BIV_MEASURE19'
471: , 'Y' ) || ' /* Late Completion Percent Grand Total */, ' ||

Line 472: isc_maint_rpt_util_pkg.change_column

468: ( 'oset05.c_num_late_completion_total'
469: , 'oset05.c_num_completion_total'
470: , 'BIV_MEASURE19'
471: , 'Y' ) || ' /* Late Completion Percent Grand Total */, ' ||
472: isc_maint_rpt_util_pkg.change_column
473: ( isc_maint_rpt_util_pkg.rate_column
474: ( 'oset05.c_num_late_completion_total'
475: , 'oset05.c_num_completion_total'
476: , ''

Line 473: ( isc_maint_rpt_util_pkg.rate_column

469: , 'oset05.c_num_completion_total'
470: , 'BIV_MEASURE19'
471: , 'Y' ) || ' /* Late Completion Percent Grand Total */, ' ||
472: isc_maint_rpt_util_pkg.change_column
473: ( isc_maint_rpt_util_pkg.rate_column
474: ( 'oset05.c_num_late_completion_total'
475: , 'oset05.c_num_completion_total'
476: , ''
477: , 'Y' )

Line 478: , isc_maint_rpt_util_pkg.rate_column

474: ( 'oset05.c_num_late_completion_total'
475: , 'oset05.c_num_completion_total'
476: , ''
477: , 'Y' )
478: , isc_maint_rpt_util_pkg.rate_column
479: ( 'oset05.p_num_late_completion_total'
480: , 'oset05.p_num_completion_total'
481: , ''
482: , 'Y' )

Line 485: isc_maint_rpt_util_pkg.rate_column

481: , ''
482: , 'Y' )
483: , 'BIV_MEASURE20'
484: , 'N' ) || ' /* Grand Total Late Completion Change */, ' ||
485: isc_maint_rpt_util_pkg.rate_column
486: ( 'oset05.c_days_late_total'
487: , 'c_num_late_completion_total'
488: , 'BIV_MEASURE21'
489: , 'N' ) || ' , ' ||

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

486: ( 'oset05.c_days_late_total'
487: , 'c_num_late_completion_total'
488: , 'BIV_MEASURE21'
489: , 'N' ) || ' , ' ||
490: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
491:
492:
493: l_stmt := l_stmt || l_inner_query || poa_dbi_template_pkg.status_sql
494: ( p_fact_name => l_mv

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

503: , p_generate_viewby => 'Y'
504: );
505:
506: /* the next line can be used to dump the contents of the PMV parameters as comments into stmt */
507: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
508:
509: x_custom_output := l_custom_output;
510:
511: x_custom_sql := l_stmt;

Line 524: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

520: , x_custom_output out nocopy bis_query_attributes_tbl
521: )
522: is
523:
524: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
525: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
526: l_dim_bmap number;
527: l_comparison_type varchar2(200);
528: l_xtd varchar2(200);

Line 549: isc_maint_rpt_util_pkg.register_dimension_levels

545: -- clear out the tables.
546: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
547: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
548:
549: isc_maint_rpt_util_pkg.register_dimension_levels
550: ( l_dimension_tbl
551: , l_dim_filter_map
552: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
553: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 552: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

548:
549: isc_maint_rpt_util_pkg.register_dimension_levels
550: ( l_dimension_tbl
551: , l_dim_filter_map
552: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
553: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
554: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
555: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
556: );

Line 553: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

549: isc_maint_rpt_util_pkg.register_dimension_levels
550: ( l_dimension_tbl
551: , l_dim_filter_map
552: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
553: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
554: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
555: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
556: );
557:

Line 554: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

550: ( l_dimension_tbl
551: , l_dim_filter_map
552: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
553: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
554: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
555: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
556: );
557:
558: isc_maint_rpt_util_pkg.process_parameters

Line 555: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

551: , l_dim_filter_map
552: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
553: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
554: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
555: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
556: );
557:
558: isc_maint_rpt_util_pkg.process_parameters
559: ( p_param => p_param

Line 558: isc_maint_rpt_util_pkg.process_parameters

554: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
555: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
556: );
557:
558: isc_maint_rpt_util_pkg.process_parameters
559: ( p_param => p_param
560: , p_dimension_tbl => l_dimension_tbl
561: , p_dim_filter_map => l_dim_filter_map
562: , p_trend => 'Y'

Line 603: isc_maint_rpt_util_pkg.change_column

599: cal.name VIEWBY
600: , nvl(iset.p_num_completion,0) BIV_MEASURE1
601: , nvl(iset.c_num_completion,0) BIV_MEASURE2
602: , ' ||
603: isc_maint_rpt_util_pkg.change_column
604: ( 'iset.c_num_completion'
605: , 'iset.p_num_completion'
606: , 'BIV_MEASURE3' ) || ' /* Completion Change */
607: , nvl(iset.p_num_completion - iset.p_num_late_completion,0) BIV_MEASURE13

Line 610: isc_maint_rpt_util_pkg.change_column

606: , 'BIV_MEASURE3' ) || ' /* Completion Change */
607: , nvl(iset.p_num_completion - iset.p_num_late_completion,0) BIV_MEASURE13
608: , nvl(iset.c_num_completion - iset.c_num_late_completion,0) BIV_MEASURE4
609: , ' ||
610: isc_maint_rpt_util_pkg.change_column
611: ( 'iset.c_num_completion - iset.c_num_late_completion'
612: , 'iset.p_num_completion - iset.p_num_late_completion'
613: , 'BIV_MEASURE14' ) || ' /* On time Completion Change */
614: , ' ||

Line 615: isc_maint_rpt_util_pkg.rate_column

611: ( 'iset.c_num_completion - iset.c_num_late_completion'
612: , 'iset.p_num_completion - iset.p_num_late_completion'
613: , 'BIV_MEASURE14' ) || ' /* On time Completion Change */
614: , ' ||
615: isc_maint_rpt_util_pkg.rate_column
616: ( 'iset.p_num_completion - iset.p_num_late_completion'
617: , 'iset.p_num_completion'
618: , 'BIV_MEASURE5'
619: , 'Y' ) || '

Line 622: isc_maint_rpt_util_pkg.rate_column

618: , 'BIV_MEASURE5'
619: , 'Y' ) || '
620: /* Prior On time completion percent */
621: , ' ||
622: isc_maint_rpt_util_pkg.rate_column
623: ( 'iset.c_num_completion - iset.c_num_late_completion'
624: , 'iset.c_num_completion'
625: , 'BIV_MEASURE6'
626: , 'Y' ) || '

Line 629: isc_maint_rpt_util_pkg.change_column

625: , 'BIV_MEASURE6'
626: , 'Y' ) || '
627: /* On time completion percent */
628: , ' ||
629: isc_maint_rpt_util_pkg.change_column
630: ( isc_maint_rpt_util_pkg.rate_column
631: ( 'iset.c_num_completion - iset.c_num_late_completion'
632: , 'iset.c_num_completion'
633: , ''

Line 630: ( isc_maint_rpt_util_pkg.rate_column

626: , 'Y' ) || '
627: /* On time completion percent */
628: , ' ||
629: isc_maint_rpt_util_pkg.change_column
630: ( isc_maint_rpt_util_pkg.rate_column
631: ( 'iset.c_num_completion - iset.c_num_late_completion'
632: , 'iset.c_num_completion'
633: , ''
634: , 'Y' )

Line 635: , isc_maint_rpt_util_pkg.rate_column

631: ( 'iset.c_num_completion - iset.c_num_late_completion'
632: , 'iset.c_num_completion'
633: , ''
634: , 'Y' )
635: , isc_maint_rpt_util_pkg.rate_column
636: ( 'iset.p_num_completion - iset.p_num_late_completion'
637: , 'iset.p_num_completion'
638: , ''
639: , 'Y' )

Line 644: isc_maint_rpt_util_pkg.rate_column

640: , 'BIV_MEASURE7'
641: , 'N' ) || ' /* On Time Completion Change */
642: , nvl(iset.c_num_late_completion,0) BIV_MEASURE8 ' || '
643: , ' ||
644: isc_maint_rpt_util_pkg.rate_column
645: ( 'iset.p_num_late_completion'
646: , 'iset.p_num_completion'
647: , 'BIV_MEASURE9'
648: , 'Y' ) || '

Line 650: isc_maint_rpt_util_pkg.rate_column

646: , 'iset.p_num_completion'
647: , 'BIV_MEASURE9'
648: , 'Y' ) || '
649: /* Prior Late Completion Percent */, ' ||
650: isc_maint_rpt_util_pkg.rate_column
651: ( 'iset.c_num_late_completion'
652: , 'iset.c_num_completion'
653: , 'BIV_MEASURE10'
654: , 'Y' ) || '

Line 657: isc_maint_rpt_util_pkg.change_column

653: , 'BIV_MEASURE10'
654: , 'Y' ) || '
655: /* Late Completion Percent */
656: , ' ||
657: isc_maint_rpt_util_pkg.change_column
658: ( isc_maint_rpt_util_pkg.rate_column
659: ( 'iset.c_num_late_completion'
660: , 'iset.c_num_completion'
661: , ''

Line 658: ( isc_maint_rpt_util_pkg.rate_column

654: , 'Y' ) || '
655: /* Late Completion Percent */
656: , ' ||
657: isc_maint_rpt_util_pkg.change_column
658: ( isc_maint_rpt_util_pkg.rate_column
659: ( 'iset.c_num_late_completion'
660: , 'iset.c_num_completion'
661: , ''
662: , 'Y' )

Line 663: , isc_maint_rpt_util_pkg.rate_column

659: ( 'iset.c_num_late_completion'
660: , 'iset.c_num_completion'
661: , ''
662: , 'Y' )
663: , isc_maint_rpt_util_pkg.rate_column
664: ( 'iset.p_num_late_completion'
665: , 'iset.p_num_completion'
666: , ''
667: , 'Y' )

Line 672: isc_maint_rpt_util_pkg.rate_column

668: , 'BIV_MEASURE11'
669: , 'N' ) || '
670: /* Late Completion Change */
671: , ' ||
672: isc_maint_rpt_util_pkg.rate_column
673: ( 'iset.c_days_late'
674: , 'iset.c_num_late_completion'
675: , 'BIV_MEASURE12'
676: , 'N' ) || ' /* Average Days Late */

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

684: , p_use_grpid => 'N'
685: );
686:
687: /* the next line can be used to dump the contents of the PMV parameters as comments into stmt */
688: --l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
689:
690: x_custom_sql := l_stmt;
691:
692: x_custom_output := l_custom_output;

Line 718: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

714: , x_custom_output out nocopy bis_query_attributes_tbl
715: )
716: is
717:
718: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
719: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
720: l_dim_bmap number;
721:
722: l_comparison_type varchar2(200);

Line 746: isc_maint_rpt_util_pkg.register_dimension_levels

742: -- clear out the tables.
743: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
744: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
745:
746: isc_maint_rpt_util_pkg.register_dimension_levels
747: ( l_dimension_tbl
748: , l_dim_filter_map
749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

745:
746: isc_maint_rpt_util_pkg.register_dimension_levels
747: ( l_dimension_tbl
748: , l_dim_filter_map
749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
751: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'

Line 750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

746: isc_maint_rpt_util_pkg.register_dimension_levels
747: ( l_dimension_tbl
748: , l_dim_filter_map
749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
751: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'
754: );

Line 751: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

747: ( l_dimension_tbl
748: , l_dim_filter_map
749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
751: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'
754: );
755:

Line 752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

748: , l_dim_filter_map
749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
751: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'
754: );
755:
756: isc_maint_rpt_util_pkg.process_parameters

Line 753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'

749: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
750: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
751: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'
754: );
755:
756: isc_maint_rpt_util_pkg.process_parameters
757: ( p_param => p_param

Line 756: isc_maint_rpt_util_pkg.process_parameters

752: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
753: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'N'
754: );
755:
756: isc_maint_rpt_util_pkg.process_parameters
757: ( p_param => p_param
758: , p_dimension_tbl => l_dimension_tbl
759: , p_dim_filter_map => l_dim_filter_map
760: , p_trend => 'N'

Line 793: isc_maint_rpt_util_pkg.change_column

789: ''&pParamIds=Y'' BIV_ATTRIBUTE1
790: , nvl(oset.p_num_count,0) BIV_MEASURE1
791: , nvl(oset.c_num_count,0) BIV_MEASURE2' || '
792: , ' ||
793: isc_maint_rpt_util_pkg.change_column
794: ( 'oset.c_num_count'
795: , 'oset.p_num_count'
796: , 'BIV_MEASURE3'
797: , 'Y' ) || ' /* Late Completion Work Orders Change */

Line 799: isc_maint_rpt_util_pkg.rate_column

795: , 'oset.p_num_count'
796: , 'BIV_MEASURE3'
797: , 'Y' ) || ' /* Late Completion Work Orders Change */
798: , ' ||
799: isc_maint_rpt_util_pkg.rate_column
800: ( 'oset.c_num_count'
801: , 'avg(oset.c_num_count_total) over()'
802: , 'BIV_MEASURE4'
803: , 'Y' ) || '

Line 807: isc_maint_rpt_util_pkg.change_column

803: , 'Y' ) || '
804: /* Percent of Total */ ' || '
805: , nvl(avg(c_num_count_total) over(),0) BIV_MEASURE5
806: , ' ||
807: isc_maint_rpt_util_pkg.change_column
808: ( 'avg(oset.c_num_count_total) over()'
809: , 'avg(oset.p_num_count_total) over()'
810: , 'BIV_MEASURE6'
811: , 'Y' ) || ' /* Grand Total Late Completion Work Orders Change */

Line 813: isc_maint_rpt_util_pkg.rate_column

809: , 'avg(oset.p_num_count_total) over()'
810: , 'BIV_MEASURE6'
811: , 'Y' ) || ' /* Grand Total Late Completion Work Orders Change */
812: , ' ||
813: isc_maint_rpt_util_pkg.rate_column
814: ( 'avg(c_num_count_total) over()'
815: , 'avg(c_num_count_total) over ()'
816: , 'BIV_MEASURE7'
817: , 'Y' ) || '

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

830: , p_generate_viewby => 'Y'
831: );
832:
833: /* the next line can be used to dump the contents of the PMV parameters as comments into stmt */
834: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
835:
836: l_orderby := 'ORDER BY VIEWBYID ASC';
837:
838: l_stmt := replace(l_stmt,'&ORDER_BY_CLAUSE',l_orderby);

Line 853: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

849: x_custom_sql OUT NOCOPY VARCHAR2,
850: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
851: IS
852:
853: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
854: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
855: l_dim_bmap number;
856: l_comparison_type varchar2(200);
857: l_xtd varchar2(200);

Line 875: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

871: l_asc_desc varchar2(100);
872:
873: l_viewby_select varchar2(200);
874:
875: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
876:
877: BEGIN
878:
879: -- clear out the tables.

Line 883: isc_maint_rpt_util_pkg.register_dimension_levels

879: -- clear out the tables.
880: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
881: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
882:
883: isc_maint_rpt_util_pkg.register_dimension_levels
884: ( l_dimension_tbl
885: , l_dim_filter_map
886: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
887: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 886: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

882:
883: isc_maint_rpt_util_pkg.register_dimension_levels
884: ( l_dimension_tbl
885: , l_dim_filter_map
886: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
887: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
888: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
889: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
890: );

Line 887: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

883: isc_maint_rpt_util_pkg.register_dimension_levels
884: ( l_dimension_tbl
885: , l_dim_filter_map
886: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
887: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
888: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
889: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
890: );
891:

Line 888: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

884: ( l_dimension_tbl
885: , l_dim_filter_map
886: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
887: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
888: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
889: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
890: );
891:
892: isc_maint_rpt_util_pkg.process_parameters

Line 889: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

885: , l_dim_filter_map
886: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
887: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
888: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
889: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
890: );
891:
892: isc_maint_rpt_util_pkg.process_parameters
893: ( p_param => p_param

Line 892: isc_maint_rpt_util_pkg.process_parameters

888: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
889: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
890: );
891:
892: isc_maint_rpt_util_pkg.process_parameters
893: ( p_param => p_param
894: , p_dimension_tbl => l_dimension_tbl
895: , p_dim_filter_map => l_dim_filter_map
896: , p_trend => 'D'

Line 914: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value

910: , l_dim_bmap
911: , l_custom_output
912: );
913:
914: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value
915: ( p_param
916: , 'ORDERBY'
917: );
918:

Line 941: isc_maint_rpt_util_pkg.add_detail_column

937: end ||
938: l_asc_desc ||
939: 'nulls last, organization_id, work_order_id';
940:
941: isc_maint_rpt_util_pkg.add_detail_column
942: ( p_detail_col_tbl => l_detail_col_tbl
943: , p_dimension_tbl => l_dimension_tbl
944: , p_fact_col_name => 'work_order_id'
945: , p_fact_col_total => 'N'

Line 949: isc_maint_rpt_util_pkg.add_detail_column

945: , p_fact_col_total => 'N'
946: , p_column_key => 'work_order_id'
947: );
948:
949: isc_maint_rpt_util_pkg.add_detail_column
950: ( p_detail_col_tbl => l_detail_col_tbl
951: , p_dimension_tbl => l_dimension_tbl
952: , p_fact_col_name => 'work_order_name'
953: , p_fact_col_total => 'N'

Line 957: isc_maint_rpt_util_pkg.add_detail_column

953: , p_fact_col_total => 'N'
954: , p_column_key => 'work_order_name'
955: );
956:
957: isc_maint_rpt_util_pkg.add_detail_column
958: ( p_detail_col_tbl => l_detail_col_tbl
959: , p_dimension_tbl => l_dimension_tbl
960: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
961: , p_column_key => 'work_order_type'

Line 960: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE

956:
957: isc_maint_rpt_util_pkg.add_detail_column
958: ( p_detail_col_tbl => l_detail_col_tbl
959: , p_dimension_tbl => l_dimension_tbl
960: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
961: , p_column_key => 'work_order_type'
962: );
963:
964: isc_maint_rpt_util_pkg.add_detail_column

Line 964: isc_maint_rpt_util_pkg.add_detail_column

960: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
961: , p_column_key => 'work_order_type'
962: );
963:
964: isc_maint_rpt_util_pkg.add_detail_column
965: ( p_detail_col_tbl => l_detail_col_tbl
966: , p_dimension_tbl => l_dimension_tbl
967: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
968: , p_column_key => 'asset_number'

Line 967: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER

963:
964: isc_maint_rpt_util_pkg.add_detail_column
965: ( p_detail_col_tbl => l_detail_col_tbl
966: , p_dimension_tbl => l_dimension_tbl
967: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
968: , p_column_key => 'asset_number'
969: );
970:
971: isc_maint_rpt_util_pkg.add_detail_column

Line 971: isc_maint_rpt_util_pkg.add_detail_column

967: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
968: , p_column_key => 'asset_number'
969: );
970:
971: isc_maint_rpt_util_pkg.add_detail_column
972: ( p_detail_col_tbl => l_detail_col_tbl
973: , p_dimension_tbl => l_dimension_tbl
974: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
975: , p_column_key => 'asset_group'

Line 974: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP

970:
971: isc_maint_rpt_util_pkg.add_detail_column
972: ( p_detail_col_tbl => l_detail_col_tbl
973: , p_dimension_tbl => l_dimension_tbl
974: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
975: , p_column_key => 'asset_group'
976: );
977:
978: isc_maint_rpt_util_pkg.add_detail_column

Line 978: isc_maint_rpt_util_pkg.add_detail_column

974: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
975: , p_column_key => 'asset_group'
976: );
977:
978: isc_maint_rpt_util_pkg.add_detail_column
979: ( p_detail_col_tbl => l_detail_col_tbl
980: , p_dimension_tbl => l_dimension_tbl
981: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
982: , p_column_key => 'activity'

Line 981: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY

977:
978: isc_maint_rpt_util_pkg.add_detail_column
979: ( p_detail_col_tbl => l_detail_col_tbl
980: , p_dimension_tbl => l_dimension_tbl
981: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
982: , p_column_key => 'activity'
983: );
984:
985: isc_maint_rpt_util_pkg.add_detail_column

Line 985: isc_maint_rpt_util_pkg.add_detail_column

981: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
982: , p_column_key => 'activity'
983: );
984:
985: isc_maint_rpt_util_pkg.add_detail_column
986: ( p_detail_col_tbl => l_detail_col_tbl
987: , p_dimension_tbl => l_dimension_tbl
988: , p_fact_col_name => 'wo_status'
989: , p_fact_col_total => 'N'

Line 993: isc_maint_rpt_util_pkg.add_detail_column

989: , p_fact_col_total => 'N'
990: , p_column_key => 'wo_status'
991: );
992:
993: isc_maint_rpt_util_pkg.add_detail_column
994: ( p_detail_col_tbl => l_detail_col_tbl
995: , p_dimension_tbl => l_dimension_tbl
996: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
997: , p_column_key => 'department'

Line 996: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT

992:
993: isc_maint_rpt_util_pkg.add_detail_column
994: ( p_detail_col_tbl => l_detail_col_tbl
995: , p_dimension_tbl => l_dimension_tbl
996: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
997: , p_column_key => 'department'
998: );
999:
1000: isc_maint_rpt_util_pkg.add_detail_column

Line 1000: isc_maint_rpt_util_pkg.add_detail_column

996: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
997: , p_column_key => 'department'
998: );
999:
1000: isc_maint_rpt_util_pkg.add_detail_column
1001: ( p_detail_col_tbl => l_detail_col_tbl
1002: , p_dimension_tbl => l_dimension_tbl
1003: , p_fact_col_name => 'SCHEDULED_START_DATE'
1004: , p_fact_col_total => 'N'

Line 1008: isc_maint_rpt_util_pkg.add_detail_column

1004: , p_fact_col_total => 'N'
1005: , p_column_key => 'SCHEDULED_START_DATE'
1006: );
1007:
1008: isc_maint_rpt_util_pkg.add_detail_column
1009: ( p_detail_col_tbl => l_detail_col_tbl
1010: , p_dimension_tbl => l_dimension_tbl
1011: , p_fact_col_name => 'SCHEDULED_COMPLETION_DATE'
1012: , p_fact_col_total => 'N'

Line 1016: isc_maint_rpt_util_pkg.add_detail_column

1012: , p_fact_col_total => 'N'
1013: , p_column_key => 'SCHEDULED_COMPLETION_DATE'
1014: );
1015:
1016: isc_maint_rpt_util_pkg.add_detail_column
1017: ( p_detail_col_tbl => l_detail_col_tbl
1018: , p_dimension_tbl => l_dimension_tbl
1019: , p_fact_col_name => 'COMPLETION_DATE'
1020: , p_fact_col_total => 'N'

Line 1027: , ' || isc_maint_rpt_util_pkg.get_detail_column

1023:
1024:
1025: l_stmt := 'select
1026: oset.work_order_name BIV_ATTRIBUTE1' || '
1027: , ' || isc_maint_rpt_util_pkg.get_detail_column
1028: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1029: , ' || isc_maint_rpt_util_pkg.get_detail_column
1030: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1031: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1029: , ' || isc_maint_rpt_util_pkg.get_detail_column

1025: l_stmt := 'select
1026: oset.work_order_name BIV_ATTRIBUTE1' || '
1027: , ' || isc_maint_rpt_util_pkg.get_detail_column
1028: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1029: , ' || isc_maint_rpt_util_pkg.get_detail_column
1030: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1031: , ' || isc_maint_rpt_util_pkg.get_detail_column
1032: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1033: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1031: , ' || isc_maint_rpt_util_pkg.get_detail_column

1027: , ' || isc_maint_rpt_util_pkg.get_detail_column
1028: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1029: , ' || isc_maint_rpt_util_pkg.get_detail_column
1030: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1031: , ' || isc_maint_rpt_util_pkg.get_detail_column
1032: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1033: , ' || isc_maint_rpt_util_pkg.get_detail_column
1034: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1035: , oset.wo_status BIV_ATTRIBUTE6' || '

Line 1033: , ' || isc_maint_rpt_util_pkg.get_detail_column

1029: , ' || isc_maint_rpt_util_pkg.get_detail_column
1030: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1031: , ' || isc_maint_rpt_util_pkg.get_detail_column
1032: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1033: , ' || isc_maint_rpt_util_pkg.get_detail_column
1034: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1035: , oset.wo_status BIV_ATTRIBUTE6' || '
1036: , ' || isc_maint_rpt_util_pkg.get_detail_column
1037: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '

Line 1036: , ' || isc_maint_rpt_util_pkg.get_detail_column

1032: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1033: , ' || isc_maint_rpt_util_pkg.get_detail_column
1034: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1035: , oset.wo_status BIV_ATTRIBUTE6' || '
1036: , ' || isc_maint_rpt_util_pkg.get_detail_column
1037: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
1038: , oset.SCHEDULED_START_DATE BIV_ATTRIBUTE9
1039: , oset.SCHEDULED_COMPLETION_DATE BIV_ATTRIBUTE10
1040: , oset.COMPLETION_DATE BIV_ATTRIBUTE11 ' || '

Line 1041: , ' || isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '

1037: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
1038: , oset.SCHEDULED_START_DATE BIV_ATTRIBUTE9
1039: , oset.SCHEDULED_COMPLETION_DATE BIV_ATTRIBUTE10
1040: , oset.COMPLETION_DATE BIV_ATTRIBUTE11 ' || '
1041: , ' || isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '
1042: from
1043: ' || isc_maint_rpt_util_pkg.detail_sql
1044: ( p_detail_col_tbl => l_detail_col_tbl
1045: , p_dimension_tbl => l_dimension_tbl

Line 1043: ' || isc_maint_rpt_util_pkg.detail_sql

1039: , oset.SCHEDULED_COMPLETION_DATE BIV_ATTRIBUTE10
1040: , oset.COMPLETION_DATE BIV_ATTRIBUTE11 ' || '
1041: , ' || isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '
1042: from
1043: ' || isc_maint_rpt_util_pkg.detail_sql
1044: ( p_detail_col_tbl => l_detail_col_tbl
1045: , p_dimension_tbl => l_dimension_tbl
1046: , p_mv_name => l_mv
1047: , p_where_clause => l_where_clause

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

1049: , p_override_date_clause => '1 = 1 '
1050: );
1051:
1052: /* the next line can be used to dump the contents of the PMV parameters as comments into stmt */
1053: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
1054:
1055: x_custom_sql := l_stmt;
1056:
1057: x_custom_output := l_custom_output;

Line 1067: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

1063: x_custom_sql OUT NOCOPY VARCHAR2,
1064: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1065: IS
1066:
1067: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1068: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1069: l_dim_bmap number;
1070:
1071: l_comparison_type varchar2(200);

Line 1090: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

1086: l_asc_desc varchar2(100);
1087:
1088: l_viewby_select varchar2(200);
1089:
1090: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
1091:
1092: BEGIN
1093:
1094: -- clear out the tables.

Line 1098: isc_maint_rpt_util_pkg.register_dimension_levels

1094: -- clear out the tables.
1095: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1096: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1097:
1098: isc_maint_rpt_util_pkg.register_dimension_levels
1099: ( l_dimension_tbl
1100: , l_dim_filter_map
1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

1097:
1098: isc_maint_rpt_util_pkg.register_dimension_levels
1099: ( l_dimension_tbl
1100: , l_dim_filter_map
1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1103: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'

Line 1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

1098: isc_maint_rpt_util_pkg.register_dimension_levels
1099: ( l_dimension_tbl
1100: , l_dim_filter_map
1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1103: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'
1106: );

Line 1103: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'

1099: ( l_dimension_tbl
1100: , l_dim_filter_map
1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1103: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'
1106: );
1107:

Line 1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'

1100: , l_dim_filter_map
1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1103: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'
1106: );
1107:
1108: isc_maint_rpt_util_pkg.process_parameters

Line 1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'

1101: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
1102: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
1103: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'Y'
1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'
1106: );
1107:
1108: isc_maint_rpt_util_pkg.process_parameters
1109: ( p_param => p_param

Line 1108: isc_maint_rpt_util_pkg.process_parameters

1104: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'Y'
1105: , isc_maint_rpt_util_pkg.G_LATE_CMPL_AGING, 'Y'
1106: );
1107:
1108: isc_maint_rpt_util_pkg.process_parameters
1109: ( p_param => p_param
1110: , p_dimension_tbl => l_dimension_tbl
1111: , p_dim_filter_map => l_dim_filter_map
1112: , p_trend => 'D'

Line 1130: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value

1126: , l_dim_bmap
1127: , l_custom_output
1128: );
1129:
1130: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value
1131: ( p_param
1132: , 'ORDERBY'
1133: );
1134:

Line 1159: isc_maint_rpt_util_pkg.add_detail_column

1155: end ||
1156: l_asc_desc ||
1157: 'nulls last, organization_id, work_order_id';
1158:
1159: isc_maint_rpt_util_pkg.add_detail_column
1160: ( p_detail_col_tbl => l_detail_col_tbl
1161: , p_dimension_tbl => l_dimension_tbl
1162: , p_fact_col_name => 'work_order_id'
1163: , p_fact_col_total => 'N'

Line 1167: isc_maint_rpt_util_pkg.add_detail_column

1163: , p_fact_col_total => 'N'
1164: , p_column_key => 'work_order_id'
1165: );
1166:
1167: isc_maint_rpt_util_pkg.add_detail_column
1168: ( p_detail_col_tbl => l_detail_col_tbl
1169: , p_dimension_tbl => l_dimension_tbl
1170: , p_fact_col_name => 'work_order_name'
1171: , p_fact_col_total => 'N'

Line 1175: isc_maint_rpt_util_pkg.add_detail_column

1171: , p_fact_col_total => 'N'
1172: , p_column_key => 'work_order_name'
1173: );
1174:
1175: isc_maint_rpt_util_pkg.add_detail_column
1176: ( p_detail_col_tbl => l_detail_col_tbl
1177: , p_dimension_tbl => l_dimension_tbl
1178: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1179: , p_column_key => 'work_order_type'

Line 1178: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE

1174:
1175: isc_maint_rpt_util_pkg.add_detail_column
1176: ( p_detail_col_tbl => l_detail_col_tbl
1177: , p_dimension_tbl => l_dimension_tbl
1178: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1179: , p_column_key => 'work_order_type'
1180: );
1181:
1182: isc_maint_rpt_util_pkg.add_detail_column

Line 1182: isc_maint_rpt_util_pkg.add_detail_column

1178: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1179: , p_column_key => 'work_order_type'
1180: );
1181:
1182: isc_maint_rpt_util_pkg.add_detail_column
1183: ( p_detail_col_tbl => l_detail_col_tbl
1184: , p_dimension_tbl => l_dimension_tbl
1185: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
1186: , p_column_key => 'asset_number'

Line 1185: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER

1181:
1182: isc_maint_rpt_util_pkg.add_detail_column
1183: ( p_detail_col_tbl => l_detail_col_tbl
1184: , p_dimension_tbl => l_dimension_tbl
1185: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
1186: , p_column_key => 'asset_number'
1187: );
1188:
1189: isc_maint_rpt_util_pkg.add_detail_column

Line 1189: isc_maint_rpt_util_pkg.add_detail_column

1185: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
1186: , p_column_key => 'asset_number'
1187: );
1188:
1189: isc_maint_rpt_util_pkg.add_detail_column
1190: ( p_detail_col_tbl => l_detail_col_tbl
1191: , p_dimension_tbl => l_dimension_tbl
1192: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
1193: , p_column_key => 'asset_group'

Line 1192: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP

1188:
1189: isc_maint_rpt_util_pkg.add_detail_column
1190: ( p_detail_col_tbl => l_detail_col_tbl
1191: , p_dimension_tbl => l_dimension_tbl
1192: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
1193: , p_column_key => 'asset_group'
1194: );
1195:
1196: isc_maint_rpt_util_pkg.add_detail_column

Line 1196: isc_maint_rpt_util_pkg.add_detail_column

1192: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
1193: , p_column_key => 'asset_group'
1194: );
1195:
1196: isc_maint_rpt_util_pkg.add_detail_column
1197: ( p_detail_col_tbl => l_detail_col_tbl
1198: , p_dimension_tbl => l_dimension_tbl
1199: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1200: , p_column_key => 'activity'

Line 1199: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY

1195:
1196: isc_maint_rpt_util_pkg.add_detail_column
1197: ( p_detail_col_tbl => l_detail_col_tbl
1198: , p_dimension_tbl => l_dimension_tbl
1199: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1200: , p_column_key => 'activity'
1201: );
1202:
1203: isc_maint_rpt_util_pkg.add_detail_column

Line 1203: isc_maint_rpt_util_pkg.add_detail_column

1199: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1200: , p_column_key => 'activity'
1201: );
1202:
1203: isc_maint_rpt_util_pkg.add_detail_column
1204: ( p_detail_col_tbl => l_detail_col_tbl
1205: , p_dimension_tbl => l_dimension_tbl
1206: , p_fact_col_name => 'wo_status'
1207: , p_fact_col_total => 'N'

Line 1211: isc_maint_rpt_util_pkg.add_detail_column

1207: , p_fact_col_total => 'N'
1208: , p_column_key => 'wo_status'
1209: );
1210:
1211: isc_maint_rpt_util_pkg.add_detail_column
1212: ( p_detail_col_tbl => l_detail_col_tbl
1213: , p_dimension_tbl => l_dimension_tbl
1214: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
1215: , p_column_key => 'department'

Line 1214: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT

1210:
1211: isc_maint_rpt_util_pkg.add_detail_column
1212: ( p_detail_col_tbl => l_detail_col_tbl
1213: , p_dimension_tbl => l_dimension_tbl
1214: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
1215: , p_column_key => 'department'
1216: );
1217:
1218: isc_maint_rpt_util_pkg.add_detail_column

Line 1218: isc_maint_rpt_util_pkg.add_detail_column

1214: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
1215: , p_column_key => 'department'
1216: );
1217:
1218: isc_maint_rpt_util_pkg.add_detail_column
1219: ( p_detail_col_tbl => l_detail_col_tbl
1220: , p_dimension_tbl => l_dimension_tbl
1221: , p_fact_col_name => 'SCHEDULED_START_DATE'
1222: , p_fact_col_total => 'N'

Line 1226: isc_maint_rpt_util_pkg.add_detail_column

1222: , p_fact_col_total => 'N'
1223: , p_column_key => 'SCHEDULED_START_DATE'
1224: );
1225:
1226: isc_maint_rpt_util_pkg.add_detail_column
1227: ( p_detail_col_tbl => l_detail_col_tbl
1228: , p_dimension_tbl => l_dimension_tbl
1229: , p_fact_col_name => 'SCHEDULED_COMPLETION_DATE'
1230: , p_fact_col_total => 'N'

Line 1234: isc_maint_rpt_util_pkg.add_detail_column

1230: , p_fact_col_total => 'N'
1231: , p_column_key => 'SCHEDULED_COMPLETION_DATE'
1232: );
1233:
1234: isc_maint_rpt_util_pkg.add_detail_column
1235: ( p_detail_col_tbl => l_detail_col_tbl
1236: , p_dimension_tbl => l_dimension_tbl
1237: , p_fact_col_name => 'COMPLETION_DATE'
1238: , p_fact_col_total => 'N'

Line 1242: isc_maint_rpt_util_pkg.add_detail_column

1238: , p_fact_col_total => 'N'
1239: , p_column_key => 'COMPLETION_DATE'
1240: );
1241:
1242: isc_maint_rpt_util_pkg.add_detail_column
1243: ( p_detail_col_tbl => l_detail_col_tbl
1244: , p_dimension_tbl => l_dimension_tbl
1245: , p_fact_col_name => 'DAYS_LATE'
1246: , p_fact_col_total => 'N'

Line 1253: , ' || isc_maint_rpt_util_pkg.get_detail_column

1249:
1250:
1251: l_stmt := 'select
1252: oset.work_order_name BIV_ATTRIBUTE1' || '
1253: , ' || isc_maint_rpt_util_pkg.get_detail_column
1254: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1255: , ' || isc_maint_rpt_util_pkg.get_detail_column
1256: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1257: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1255: , ' || isc_maint_rpt_util_pkg.get_detail_column

1251: l_stmt := 'select
1252: oset.work_order_name BIV_ATTRIBUTE1' || '
1253: , ' || isc_maint_rpt_util_pkg.get_detail_column
1254: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1255: , ' || isc_maint_rpt_util_pkg.get_detail_column
1256: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1257: , ' || isc_maint_rpt_util_pkg.get_detail_column
1258: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1259: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1257: , ' || isc_maint_rpt_util_pkg.get_detail_column

1253: , ' || isc_maint_rpt_util_pkg.get_detail_column
1254: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1255: , ' || isc_maint_rpt_util_pkg.get_detail_column
1256: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1257: , ' || isc_maint_rpt_util_pkg.get_detail_column
1258: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1259: , ' || isc_maint_rpt_util_pkg.get_detail_column
1260: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1261: , oset.wo_status BIV_ATTRIBUTE6' || '

Line 1259: , ' || isc_maint_rpt_util_pkg.get_detail_column

1255: , ' || isc_maint_rpt_util_pkg.get_detail_column
1256: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE3') || '
1257: , ' || isc_maint_rpt_util_pkg.get_detail_column
1258: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1259: , ' || isc_maint_rpt_util_pkg.get_detail_column
1260: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1261: , oset.wo_status BIV_ATTRIBUTE6' || '
1262: , ' || isc_maint_rpt_util_pkg.get_detail_column
1263: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '

Line 1262: , ' || isc_maint_rpt_util_pkg.get_detail_column

1258: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE4') || '
1259: , ' || isc_maint_rpt_util_pkg.get_detail_column
1260: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE5') || '
1261: , oset.wo_status BIV_ATTRIBUTE6' || '
1262: , ' || isc_maint_rpt_util_pkg.get_detail_column
1263: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
1264: , oset.SCHEDULED_START_DATE BIV_ATTRIBUTE9
1265: , oset.SCHEDULED_COMPLETION_DATE BIV_ATTRIBUTE10
1266: , oset.COMPLETION_DATE BIV_ATTRIBUTE11

Line 1269: , ' || isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '

1265: , oset.SCHEDULED_COMPLETION_DATE BIV_ATTRIBUTE10
1266: , oset.COMPLETION_DATE BIV_ATTRIBUTE11
1267: , oset.DAYS_LATE BIV_ATTRIBUTE12 ' || '
1268: , null BIV_ATTRIBUTE13
1269: , ' || isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '
1270: from
1271: ' || isc_maint_rpt_util_pkg.detail_sql
1272: ( p_detail_col_tbl => l_detail_col_tbl
1273: , p_dimension_tbl => l_dimension_tbl

Line 1271: ' || isc_maint_rpt_util_pkg.detail_sql

1267: , oset.DAYS_LATE BIV_ATTRIBUTE12 ' || '
1268: , null BIV_ATTRIBUTE13
1269: , ' || isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE8') || '
1270: from
1271: ' || isc_maint_rpt_util_pkg.detail_sql
1272: ( p_detail_col_tbl => l_detail_col_tbl
1273: , p_dimension_tbl => l_dimension_tbl
1274: , p_mv_name => l_mv
1275: , p_where_clause => l_where_clause

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

1277: , p_override_date_clause => '1 = 1 '
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;