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

Line 22: l_custom_rec.attribute_value := isc_maint_rpt_util_pkg.get_parameter_value

18: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
19:
20: l_custom_rec.attribute_name := '&ISC_REQUEST_ID' ;
21: l_custom_rec.attribute_type := bis_pmv_parameters_pub.bind_type;
22: l_custom_rec.attribute_value := isc_maint_rpt_util_pkg.get_parameter_value
23: ( p_param
24: , 'BIV_ATTRIBUTE9'
25: );
26: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;

Line 47: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id

43: l_bucket_num varchar2(200);
44:
45: begin
46:
47: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
48: ( p_param
49: , isc_maint_rpt_util_pkg.G_ORGANIZATION
50: );
51:

Line 49: , isc_maint_rpt_util_pkg.G_ORGANIZATION

45: begin
46:
47: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
48: ( p_param
49: , isc_maint_rpt_util_pkg.G_ORGANIZATION
50: );
51:
52: if p_report_type = 'REQUEST_TO_COMPLETION' then
53:

Line 54: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

50: );
51:
52: if p_report_type = 'REQUEST_TO_COMPLETION' then
53:
54: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
55: ( p_param
56: , 'VIEW_BY'
57: );
58:

Line 59: isc_maint_rpt_util_pkg.bind_group_id

55: ( p_param
56: , 'VIEW_BY'
57: );
58:
59: isc_maint_rpt_util_pkg.bind_group_id
60: ( p_dim_bmap
61: , p_custom_output
62: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
63: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

Line 62: , isc_maint_rpt_util_pkg.G_ASSET_GROUP

58:
59: isc_maint_rpt_util_pkg.bind_group_id
60: ( p_dim_bmap
61: , p_custom_output
62: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
63: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
64: , isc_maint_rpt_util_pkg.G_DEPARTMENT
65: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING
66: );

Line 63: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

59: isc_maint_rpt_util_pkg.bind_group_id
60: ( p_dim_bmap
61: , p_custom_output
62: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
63: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
64: , isc_maint_rpt_util_pkg.G_DEPARTMENT
65: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING
66: );
67:

Line 64: , isc_maint_rpt_util_pkg.G_DEPARTMENT

60: ( p_dim_bmap
61: , p_custom_output
62: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
63: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
64: , isc_maint_rpt_util_pkg.G_DEPARTMENT
65: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING
66: );
67:
68: return '(

Line 65: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING

61: , p_custom_output
62: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
63: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
64: , isc_maint_rpt_util_pkg.G_DEPARTMENT
65: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING
66: );
67:
68: return '(
69: select

Line 75: when isc_maint_rpt_util_pkg.G_DEPARTMENT then

71: , period_type_id
72: , grp_id
73: , ' ||
74: case l_view_by /* replaced asset_number with instance_id */
75: when isc_maint_rpt_util_pkg.G_DEPARTMENT then
76: 'decode(department_id,-1,-1,organization_id) organization_id'
77: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
78: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
79: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

Line 77: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then

73: , ' ||
74: case l_view_by /* replaced asset_number with instance_id */
75: when isc_maint_rpt_util_pkg.G_DEPARTMENT then
76: 'decode(department_id,-1,-1,organization_id) organization_id'
77: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
78: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
79: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
80: 'decode(instance_id,-1,-1,organization_id) organization_id'
81: else

Line 79: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

75: when isc_maint_rpt_util_pkg.G_DEPARTMENT then
76: 'decode(department_id,-1,-1,organization_id) organization_id'
77: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then
78: 'decode(asset_group_id,-1,-1,organization_id) organization_id'
79: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
80: 'decode(instance_id,-1,-1,organization_id) organization_id'
81: else
82: 'organization_id'
83: end ||'

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

83: end ||'
84: , request_type
85: , ' ||
86: case l_view_by
87: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then /* replaced asset_number with instance_id */
88: 'decode(instance_id,-1,-1,asset_group_id) asset_group_id'
89: else
90: 'asset_group_id'
91: end || '

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

103: where fact.grp_id = &ISC_GRP_ID' ||
104: case
105: when l_org_id is null then
106: '
107: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
108: end || '
109: )';
110:
111: elsif p_report_type = 'REQUEST_TO_COMPLETION_DTL' then

Line 113: l_bucket_num := isc_maint_rpt_util_pkg.get_parameter_id

109: )';
110:
111: elsif p_report_type = 'REQUEST_TO_COMPLETION_DTL' then
112:
113: l_bucket_num := isc_maint_rpt_util_pkg.get_parameter_id
114: ( p_param
115: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING
116: );
117:

Line 115: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING

111: elsif p_report_type = 'REQUEST_TO_COMPLETION_DTL' then
112:
113: l_bucket_num := isc_maint_rpt_util_pkg.get_parameter_id
114: ( p_param
115: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING
116: );
117:
118: return '(
119: select

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

187: end ||
188: case
189: when l_org_id is null then
190: '
191: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'f', l_org_id )
192: end || '
193: )';
194:
195:

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

221: and f.maint_request_id = &ISC_REQUEST_ID' ||
222: case
223: when l_org_id is null then
224: '
225: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'f', l_org_id )
226: end || '
227: )';
228:
229: end if;

Line 240: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

236: , x_custom_output out nocopy bis_query_attributes_tbl
237: )
238: is
239:
240: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
241: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
242: l_custom_output bis_query_attributes_tbl;
243: l_curr_suffix varchar2(3);
244: l_where_clause varchar2(10000);

Line 257: isc_maint_rpt_util_pkg.register_dimension_levels

253: l_asset_grp_column varchar2(200);
254: l_inner_query varchar2(5000);
255: begin
256:
257: isc_maint_rpt_util_pkg.register_dimension_levels
258: ( l_dimension_tbl
259: , l_dim_filter_map
260: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
261: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 260: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

256:
257: isc_maint_rpt_util_pkg.register_dimension_levels
258: ( l_dimension_tbl
259: , l_dim_filter_map
260: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
261: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
262: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
263: );
264:

Line 261: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

257: isc_maint_rpt_util_pkg.register_dimension_levels
258: ( l_dimension_tbl
259: , l_dim_filter_map
260: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
261: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
262: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
263: );
264:
265: isc_maint_rpt_util_pkg.process_parameters

Line 262: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'

258: ( l_dimension_tbl
259: , l_dim_filter_map
260: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
261: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
262: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
263: );
264:
265: isc_maint_rpt_util_pkg.process_parameters
266: ( p_param => p_param

Line 265: isc_maint_rpt_util_pkg.process_parameters

261: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
262: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
263: );
264:
265: isc_maint_rpt_util_pkg.process_parameters
266: ( p_param => p_param
267: , p_dimension_tbl => l_dimension_tbl
268: , p_dim_filter_map => l_dim_filter_map
269: , p_trend => 'N'

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

304: , p_to_date_type => 'XTD'
305: );
306:
307: /* if view by is asset_number then add the asset_group column */
308: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
309: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
310: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
311: else
312: l_asset_grp_column :='NULL';

Line 309: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then

305: );
306:
307: /* if view by is asset_number then add the asset_group column */
308: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
309: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
310: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
311: else
312: l_asset_grp_column :='NULL';
313: end if ;

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

306:
307: /* if view by is asset_number then add the asset_group column */
308: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =
309: isc_maint_rpt_util_pkg.G_ASSET_NUMBER then
310: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
311: else
312: l_asset_grp_column :='NULL';
313: end if ;
314:

Line 342: isc_maint_rpt_util_pkg.change_column

338: from (select
339: nvl(oset05.p_requests,0) BIV_MEASURE1
340: , nvl(oset05.c_requests,0) BIV_MEASURE2' || '
341: , ' ||
342: isc_maint_rpt_util_pkg.change_column
343: ( 'oset05.c_requests'
344: , 'oset05.p_requests'
345: , 'BIV_MEASURE3' ) || '
346: , ' ||

Line 347: isc_maint_rpt_util_pkg.rate_column

343: ( 'oset05.c_requests'
344: , 'oset05.p_requests'
345: , 'BIV_MEASURE3' ) || '
346: , ' ||
347: isc_maint_rpt_util_pkg.rate_column
348: ( 'oset05.p_response_days'
349: , 'oset05.p_requests'
350: , 'BIV_MEASURE4' -- prior response days
351: , 'N' ) || '

Line 353: isc_maint_rpt_util_pkg.rate_column

349: , 'oset05.p_requests'
350: , 'BIV_MEASURE4' -- prior response days
351: , 'N' ) || '
352: , ' ||
353: isc_maint_rpt_util_pkg.rate_column
354: ( 'oset05.c_response_days'
355: , 'oset05.c_requests'
356: , 'BIV_MEASURE5' -- current response days
357: , 'N' ) || '

Line 359: isc_maint_rpt_util_pkg.change_column

355: , 'oset05.c_requests'
356: , 'BIV_MEASURE5' -- current response days
357: , 'N' ) || '
358: , ' ||
359: isc_maint_rpt_util_pkg.change_column
360: ( isc_maint_rpt_util_pkg.rate_column
361: ( 'oset05.c_response_days'
362: , 'oset05.c_requests'
363: , null

Line 360: ( isc_maint_rpt_util_pkg.rate_column

356: , 'BIV_MEASURE5' -- current response days
357: , 'N' ) || '
358: , ' ||
359: isc_maint_rpt_util_pkg.change_column
360: ( isc_maint_rpt_util_pkg.rate_column
361: ( 'oset05.c_response_days'
362: , 'oset05.c_requests'
363: , null
364: , 'N' )

Line 365: , isc_maint_rpt_util_pkg.rate_column

361: ( 'oset05.c_response_days'
362: , 'oset05.c_requests'
363: , null
364: , 'N' )
365: , isc_maint_rpt_util_pkg.rate_column
366: ( 'oset05.p_response_days'
367: , 'oset05.p_requests'
368: , null
369: , 'N' )

Line 373: isc_maint_rpt_util_pkg.rate_column

369: , 'N' )
370: , 'BIV_MEASURE6' -- change response days (as float)
371: , 'N' ) || '
372: , ' ||
373: isc_maint_rpt_util_pkg.rate_column
374: ( 'oset05.p_completion_days'
375: , 'oset05.p_requests'
376: , 'BIV_MEASURE7' -- prior completion days
377: , 'N' ) || '

Line 379: isc_maint_rpt_util_pkg.rate_column

375: , 'oset05.p_requests'
376: , 'BIV_MEASURE7' -- prior completion days
377: , 'N' ) || '
378: , ' ||
379: isc_maint_rpt_util_pkg.rate_column
380: ( 'oset05.c_completion_days'
381: , 'oset05.c_requests'
382: , 'BIV_MEASURE8' -- current completion days
383: , 'N' ) || '

Line 385: isc_maint_rpt_util_pkg.change_column

381: , 'oset05.c_requests'
382: , 'BIV_MEASURE8' -- current completion days
383: , 'N' ) || '
384: , ' ||
385: isc_maint_rpt_util_pkg.change_column
386: ( isc_maint_rpt_util_pkg.rate_column
387: ( 'oset05.c_completion_days'
388: , 'oset05.c_requests'
389: , null

Line 386: ( isc_maint_rpt_util_pkg.rate_column

382: , 'BIV_MEASURE8' -- current completion days
383: , 'N' ) || '
384: , ' ||
385: isc_maint_rpt_util_pkg.change_column
386: ( isc_maint_rpt_util_pkg.rate_column
387: ( 'oset05.c_completion_days'
388: , 'oset05.c_requests'
389: , null
390: , 'N' )

Line 391: , isc_maint_rpt_util_pkg.rate_column

387: ( 'oset05.c_completion_days'
388: , 'oset05.c_requests'
389: , null
390: , 'N' )
391: , isc_maint_rpt_util_pkg.rate_column
392: ( 'oset05.p_completion_days'
393: , 'oset05.p_requests'
394: , null
395: , 'N' )

Line 400: isc_maint_rpt_util_pkg.change_column

396: , 'BIV_MEASURE9' -- change completion days (as float)
397: , 'N' ) || '
398: , nvl(oset05.c_requests_total,0) BIV_MEASURE10' || '
399: , ' ||
400: isc_maint_rpt_util_pkg.change_column
401: ( 'oset05.c_requests_total'
402: , 'oset05.p_requests_total'
403: , 'BIV_MEASURE11' ) || '
404: , ' ||

Line 405: isc_maint_rpt_util_pkg.rate_column

401: ( 'oset05.c_requests_total'
402: , 'oset05.p_requests_total'
403: , 'BIV_MEASURE11' ) || '
404: , ' ||
405: isc_maint_rpt_util_pkg.rate_column
406: ( 'oset05.c_response_days_total'
407: , 'oset05.c_requests_total'
408: , 'BIV_MEASURE12' -- grand total current response days
409: , 'N' ) || '

Line 411: isc_maint_rpt_util_pkg.change_column

407: , 'oset05.c_requests_total'
408: , 'BIV_MEASURE12' -- grand total current response days
409: , 'N' ) || '
410: , ' ||
411: isc_maint_rpt_util_pkg.change_column
412: ( isc_maint_rpt_util_pkg.rate_column
413: ( 'oset05.c_response_days_total'
414: , 'oset05.c_requests_total'
415: , null

Line 412: ( isc_maint_rpt_util_pkg.rate_column

408: , 'BIV_MEASURE12' -- grand total current response days
409: , 'N' ) || '
410: , ' ||
411: isc_maint_rpt_util_pkg.change_column
412: ( isc_maint_rpt_util_pkg.rate_column
413: ( 'oset05.c_response_days_total'
414: , 'oset05.c_requests_total'
415: , null
416: , 'N' )

Line 417: , isc_maint_rpt_util_pkg.rate_column

413: ( 'oset05.c_response_days_total'
414: , 'oset05.c_requests_total'
415: , null
416: , 'N' )
417: , isc_maint_rpt_util_pkg.rate_column
418: ( 'oset05.p_response_days_total'
419: , 'oset05.p_requests_total'
420: , null
421: , 'N' )

Line 425: isc_maint_rpt_util_pkg.rate_column

421: , 'N' )
422: , 'BIV_MEASURE13' -- grand total change response days (as float)
423: , 'N' ) || '
424: , ' ||
425: isc_maint_rpt_util_pkg.rate_column
426: ( 'oset05.c_completion_days_total'
427: , 'oset05.c_requests_total'
428: , 'BIV_MEASURE14' -- grand total current completion days
429: , 'N' ) || '

Line 431: isc_maint_rpt_util_pkg.change_column

427: , 'oset05.c_requests_total'
428: , 'BIV_MEASURE14' -- grand total current completion days
429: , 'N' ) || '
430: , ' ||
431: isc_maint_rpt_util_pkg.change_column
432: ( isc_maint_rpt_util_pkg.rate_column
433: ( 'oset05.c_completion_days_total'
434: , 'oset05.c_requests_total'
435: , null

Line 432: ( isc_maint_rpt_util_pkg.rate_column

428: , 'BIV_MEASURE14' -- grand total current completion days
429: , 'N' ) || '
430: , ' ||
431: isc_maint_rpt_util_pkg.change_column
432: ( isc_maint_rpt_util_pkg.rate_column
433: ( 'oset05.c_completion_days_total'
434: , 'oset05.c_requests_total'
435: , null
436: , 'N' )

Line 437: , isc_maint_rpt_util_pkg.rate_column

433: ( 'oset05.c_completion_days_total'
434: , 'oset05.c_requests_total'
435: , null
436: , 'N' )
437: , isc_maint_rpt_util_pkg.rate_column
438: ( 'oset05.p_completion_days_total'
439: , 'oset05.p_requests_total'
440: , null
441: , 'N' )

Line 445: isc_maint_rpt_util_pkg.rate_column

441: , 'N' )
442: , 'BIV_MEASURE15' -- grand total change completion days (as float)
443: , 'N' ) || '
444: , ' ||
445: isc_maint_rpt_util_pkg.rate_column
446: ( 'oset05.p_completion_days_total'
447: , 'oset05.p_requests_total'
448: , 'BIV_MEASURE17' -- grand total prior completion days
449: , 'N' ) ||

Line 451: when isc_maint_rpt_util_pkg.get_parameter_value

447: , 'oset05.p_requests_total'
448: , 'BIV_MEASURE17' -- grand total prior completion days
449: , 'N' ) ||
450: case
451: when isc_maint_rpt_util_pkg.get_parameter_value
452: ( p_param
453: , 'VIEW_BY'
454: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
455: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER ) then

Line 454: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP

450: case
451: when isc_maint_rpt_util_pkg.get_parameter_value
452: ( p_param
453: , 'VIEW_BY'
454: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
455: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER ) then
456: '
457: , ''pFunctionName=ISC_MAINT_REQ_CMPL_DTL_RPT_REP'' ||
458: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||

Line 455: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER ) then

451: when isc_maint_rpt_util_pkg.get_parameter_value
452: ( p_param
453: , 'VIEW_BY'
454: ) in ( isc_maint_rpt_util_pkg.G_ASSET_GROUP
455: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER ) then
456: '
457: , ''pFunctionName=ISC_MAINT_REQ_CMPL_DTL_RPT_REP'' ||
458: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||
459: ''&pParamIds=Y'' BIV_ATTRIBUTE1, '

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

459: ''&pParamIds=Y'' BIV_ATTRIBUTE1, '
460: else
461: '
462: , null BIV_ATTRIBUTE1, '
463: end || isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
464:
465: l_stmt := l_stmt || l_inner_query ||
466: poa_dbi_template_pkg.status_sql
467: ( p_fact_name => l_mv

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

475: , p_generate_viewby => 'Y'
476: );
477:
478: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
479: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
480: x_custom_output := l_custom_output;
481: x_custom_sql := l_stmt;
482:
483: end get_tbl_sql;

Line 492: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

488: , x_custom_output out nocopy bis_query_attributes_tbl
489: )
490: is
491:
492: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
493: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
494: l_custom_output bis_query_attributes_tbl;
495: l_curr_suffix varchar2(3);
496: l_where_clause varchar2(10000);

Line 510: isc_maint_rpt_util_pkg.register_dimension_levels

506: l_stmt varchar2(32767);
507:
508: begin
509:
510: isc_maint_rpt_util_pkg.register_dimension_levels
511: ( l_dimension_tbl
512: , l_dim_filter_map
513: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
514: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 513: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

509:
510: isc_maint_rpt_util_pkg.register_dimension_levels
511: ( l_dimension_tbl
512: , l_dim_filter_map
513: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
514: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
515: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
516: );
517:

Line 514: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

510: isc_maint_rpt_util_pkg.register_dimension_levels
511: ( l_dimension_tbl
512: , l_dim_filter_map
513: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
514: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
515: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
516: );
517:
518: isc_maint_rpt_util_pkg.process_parameters

Line 515: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'

511: ( l_dimension_tbl
512: , l_dim_filter_map
513: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
514: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
515: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
516: );
517:
518: isc_maint_rpt_util_pkg.process_parameters
519: ( p_param => p_param

Line 518: isc_maint_rpt_util_pkg.process_parameters

514: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
515: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
516: );
517:
518: isc_maint_rpt_util_pkg.process_parameters
519: ( p_param => p_param
520: , p_dimension_tbl => l_dimension_tbl
521: , p_dim_filter_map => l_dim_filter_map
522: , p_trend => 'Y'

Line 568: isc_maint_rpt_util_pkg.change_column

564: cal.name VIEWBY
565: , nvl(iset.p_requests,0) BIV_MEASURE1
566: , nvl(iset.c_requests,0) BIV_MEASURE2' || '
567: , ' ||
568: isc_maint_rpt_util_pkg.change_column
569: ( 'iset.c_requests'
570: , 'iset.p_requests'
571: , 'BIV_MEASURE3' ) || '
572: , ' ||

Line 573: isc_maint_rpt_util_pkg.rate_column

569: ( 'iset.c_requests'
570: , 'iset.p_requests'
571: , 'BIV_MEASURE3' ) || '
572: , ' ||
573: isc_maint_rpt_util_pkg.rate_column
574: ( 'iset.p_response_days'
575: , 'iset.p_requests'
576: , 'BIV_MEASURE4' -- prior response days
577: , 'N' ) || '

Line 579: isc_maint_rpt_util_pkg.rate_column

575: , 'iset.p_requests'
576: , 'BIV_MEASURE4' -- prior response days
577: , 'N' ) || '
578: , ' ||
579: isc_maint_rpt_util_pkg.rate_column
580: ( 'iset.c_response_days'
581: , 'iset.c_requests'
582: , 'BIV_MEASURE5' -- current response days
583: , 'N' ) || '

Line 585: isc_maint_rpt_util_pkg.change_column

581: , 'iset.c_requests'
582: , 'BIV_MEASURE5' -- current response days
583: , 'N' ) || '
584: , ' ||
585: isc_maint_rpt_util_pkg.change_column
586: ( isc_maint_rpt_util_pkg.rate_column
587: ( 'iset.c_response_days'
588: , 'iset.c_requests'
589: , null

Line 586: ( isc_maint_rpt_util_pkg.rate_column

582: , 'BIV_MEASURE5' -- current response days
583: , 'N' ) || '
584: , ' ||
585: isc_maint_rpt_util_pkg.change_column
586: ( isc_maint_rpt_util_pkg.rate_column
587: ( 'iset.c_response_days'
588: , 'iset.c_requests'
589: , null
590: , 'N' )

Line 591: , isc_maint_rpt_util_pkg.rate_column

587: ( 'iset.c_response_days'
588: , 'iset.c_requests'
589: , null
590: , 'N' )
591: , isc_maint_rpt_util_pkg.rate_column
592: ( 'iset.p_response_days'
593: , 'iset.p_requests'
594: , null
595: , 'N' )

Line 599: isc_maint_rpt_util_pkg.rate_column

595: , 'N' )
596: , 'BIV_MEASURE6' -- change response days (as float)
597: , 'N' ) || '
598: , ' ||
599: isc_maint_rpt_util_pkg.rate_column
600: ( 'iset.p_completion_days'
601: , 'iset.p_requests'
602: , 'BIV_MEASURE7' -- prior completion days
603: , 'N' ) || '

Line 605: isc_maint_rpt_util_pkg.rate_column

601: , 'iset.p_requests'
602: , 'BIV_MEASURE7' -- prior completion days
603: , 'N' ) || '
604: , ' ||
605: isc_maint_rpt_util_pkg.rate_column
606: ( 'iset.c_completion_days'
607: , 'iset.c_requests'
608: , 'BIV_MEASURE8' -- current completion days
609: , 'N' ) || '

Line 611: isc_maint_rpt_util_pkg.change_column

607: , 'iset.c_requests'
608: , 'BIV_MEASURE8' -- current completion days
609: , 'N' ) || '
610: , ' ||
611: isc_maint_rpt_util_pkg.change_column
612: ( isc_maint_rpt_util_pkg.rate_column
613: ( 'iset.c_completion_days'
614: , 'iset.c_requests'
615: , null

Line 612: ( isc_maint_rpt_util_pkg.rate_column

608: , 'BIV_MEASURE8' -- current completion days
609: , 'N' ) || '
610: , ' ||
611: isc_maint_rpt_util_pkg.change_column
612: ( isc_maint_rpt_util_pkg.rate_column
613: ( 'iset.c_completion_days'
614: , 'iset.c_requests'
615: , null
616: , 'N' )

Line 617: , isc_maint_rpt_util_pkg.rate_column

613: ( 'iset.c_completion_days'
614: , 'iset.c_requests'
615: , null
616: , 'N' )
617: , isc_maint_rpt_util_pkg.rate_column
618: ( 'iset.p_completion_days'
619: , 'iset.p_requests'
620: , null
621: , 'N' )

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

631: , p_use_grpid => 'N'
632: );
633:
634: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
635: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
636:
637: x_custom_sql := l_stmt;
638:
639: x_custom_output := l_custom_output;

Line 663: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

659: , x_custom_output out nocopy bis_query_attributes_tbl
660: )
661: as
662:
663: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
664: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
665: l_custom_output bis_query_attributes_tbl;
666: l_curr_suffix varchar2(3);
667: l_where_clause varchar2(10000);

Line 681: isc_maint_rpt_util_pkg.register_dimension_levels

677: l_stmt varchar2(32767);
678:
679: begin
680:
681: isc_maint_rpt_util_pkg.register_dimension_levels
682: ( l_dimension_tbl
683: , l_dim_filter_map
684: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
685: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 684: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

680:
681: isc_maint_rpt_util_pkg.register_dimension_levels
682: ( l_dimension_tbl
683: , l_dim_filter_map
684: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
685: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
686: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
687: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
688: );

Line 685: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

681: isc_maint_rpt_util_pkg.register_dimension_levels
682: ( l_dimension_tbl
683: , l_dim_filter_map
684: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
685: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
686: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
687: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
688: );
689:

Line 686: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'

682: ( l_dimension_tbl
683: , l_dim_filter_map
684: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
685: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
686: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
687: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
688: );
689:
690: isc_maint_rpt_util_pkg.process_parameters

Line 687: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'

683: , l_dim_filter_map
684: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
685: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
686: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
687: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
688: );
689:
690: isc_maint_rpt_util_pkg.process_parameters
691: ( p_param => p_param

Line 690: isc_maint_rpt_util_pkg.process_parameters

686: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
687: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
688: );
689:
690: isc_maint_rpt_util_pkg.process_parameters
691: ( p_param => p_param
692: , p_dimension_tbl => l_dimension_tbl
693: , p_dim_filter_map => l_dim_filter_map
694: , p_trend => 'N'

Line 734: isc_maint_rpt_util_pkg.change_column

730: ' || l_viewby_select || '
731: , nvl(oset.p_requests,0) BIV_MEASURE1 /* prior requests */
732: , nvl(oset.c_requests,0) BIV_MEASURE2 /* current requests */' || '
733: , ' ||
734: isc_maint_rpt_util_pkg.change_column
735: ( 'oset.c_requests'
736: , 'oset.p_requests'
737: , 'BIV_MEASURE3' ) || ' /* change requests */
738: , ' ||

Line 739: isc_maint_rpt_util_pkg.rate_column

735: ( 'oset.c_requests'
736: , 'oset.p_requests'
737: , 'BIV_MEASURE3' ) || ' /* change requests */
738: , ' ||
739: isc_maint_rpt_util_pkg.rate_column
740: ( 'oset.c_requests'
741: , 'avg(oset.c_requests_total) over()'
742: , 'BIV_MEASURE4'
743: , 'Y' ) || ' /* percent of total */

Line 746: isc_maint_rpt_util_pkg.change_column

742: , 'BIV_MEASURE4'
743: , 'Y' ) || ' /* percent of total */
744: , nvl(avg(oset.c_requests_total) over(),0) BIV_MEASURE5 /* grand total current requests */' || '
745: , ' ||
746: isc_maint_rpt_util_pkg.change_column
747: ( 'avg(oset.c_requests_total) over()'
748: , 'avg(oset.p_requests_total) over()'
749: , 'BIV_MEASURE6' ) || ' /* grand total change requests */
750: , ' ||

Line 751: isc_maint_rpt_util_pkg.change_column

747: ( 'avg(oset.c_requests_total) over()'
748: , 'avg(oset.p_requests_total) over()'
749: , 'BIV_MEASURE6' ) || ' /* grand total change requests */
750: , ' ||
751: isc_maint_rpt_util_pkg.change_column
752: ( 'avg(oset.c_requests_total) over()'
753: , 'avg(oset.c_requests_total) over()'
754: , 'BIV_MEASURE7' ) || ' /* grand total current percent of total */
755: , ''pFunctionName=ISC_MAINT_REQ_CMPL_DTL_RPT_REP'' ||

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

775: , 'ORDER BY VIEWBYID'
776: );
777:
778: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
779: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
780:
781: x_custom_sql := l_stmt;
782:
783: x_custom_output := l_custom_output;

Line 794: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

790: , x_custom_output out nocopy bis_query_attributes_tbl
791: )
792: as
793:
794: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
795: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
796: l_custom_output bis_query_attributes_tbl;
797: l_curr_suffix varchar2(3);
798: l_where_clause varchar2(10000);

Line 810: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

806: l_estimated varchar2(200);
807: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
808: l_stmt varchar2(32767);
809: l_rank_order varchar2(200);
810: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
811: l_order_by varchar2(200);
812: l_asc_desc varchar2(100);
813:
814: begin

Line 816: isc_maint_rpt_util_pkg.register_dimension_levels

812: l_asc_desc varchar2(100);
813:
814: begin
815:
816: isc_maint_rpt_util_pkg.register_dimension_levels
817: ( l_dimension_tbl
818: , l_dim_filter_map
819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

815:
816: isc_maint_rpt_util_pkg.register_dimension_levels
817: ( l_dimension_tbl
818: , l_dim_filter_map
819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'

Line 820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

816: isc_maint_rpt_util_pkg.register_dimension_levels
817: ( l_dimension_tbl
818: , l_dim_filter_map
819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'
824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'

Line 821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'

817: ( l_dimension_tbl
818: , l_dim_filter_map
819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'
824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'
825: );

Line 822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'

818: , l_dim_filter_map
819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'
824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'
825: );
826:

Line 823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'

819: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'
824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'
825: );
826:
827: isc_maint_rpt_util_pkg.process_parameters

Line 824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'

820: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
821: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
822: , isc_maint_rpt_util_pkg.G_REQ_CMPL_AGING, 'Y'
823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'
824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'
825: );
826:
827: isc_maint_rpt_util_pkg.process_parameters
828: ( p_param => p_param

Line 827: isc_maint_rpt_util_pkg.process_parameters

823: , isc_maint_rpt_util_pkg.G_REQUESTS, 'N'
824: , isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES, 'N'
825: );
826:
827: isc_maint_rpt_util_pkg.process_parameters
828: ( p_param => p_param
829: , p_dimension_tbl => l_dimension_tbl
830: , p_dim_filter_map => l_dim_filter_map
831: , p_trend => 'D'

Line 849: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value

845: , l_dim_bmap
846: , l_custom_output
847: );
848:
849: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value
850: ( p_param
851: , 'ORDERBY'
852: );
853:

Line 872: isc_maint_rpt_util_pkg.add_detail_column

868: end ||
869: l_asc_desc ||
870: 'nulls last, organization_id, request_type, maint_request_id';
871:
872: isc_maint_rpt_util_pkg.add_detail_column
873: ( p_detail_col_tbl => l_detail_col_tbl
874: , p_dimension_tbl => l_dimension_tbl
875: , p_fact_col_name => 'request_number'
876: , p_fact_col_total => 'N'

Line 880: isc_maint_rpt_util_pkg.add_detail_column

876: , p_fact_col_total => 'N'
877: , p_column_key => 'request_number'
878: );
879:
880: isc_maint_rpt_util_pkg.add_detail_column
881: ( p_detail_col_tbl => l_detail_col_tbl
882: , p_dimension_tbl => l_dimension_tbl
883: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUESTS
884: , p_dim_level_col_name => 'description'

Line 883: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUESTS

879:
880: isc_maint_rpt_util_pkg.add_detail_column
881: ( p_detail_col_tbl => l_detail_col_tbl
882: , p_dimension_tbl => l_dimension_tbl
883: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUESTS
884: , p_dim_level_col_name => 'description'
885: , p_column_key => 'description'
886: );
887:

Line 888: isc_maint_rpt_util_pkg.add_detail_column

884: , p_dim_level_col_name => 'description'
885: , p_column_key => 'description'
886: );
887:
888: isc_maint_rpt_util_pkg.add_detail_column
889: ( p_detail_col_tbl => l_detail_col_tbl
890: , p_dimension_tbl => l_dimension_tbl
891: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_TYPE
892: , p_column_key => 'request_type'

Line 891: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_TYPE

887:
888: isc_maint_rpt_util_pkg.add_detail_column
889: ( p_detail_col_tbl => l_detail_col_tbl
890: , p_dimension_tbl => l_dimension_tbl
891: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_TYPE
892: , p_column_key => 'request_type'
893: );
894:
895: isc_maint_rpt_util_pkg.add_detail_column

Line 895: isc_maint_rpt_util_pkg.add_detail_column

891: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_TYPE
892: , p_column_key => 'request_type'
893: );
894:
895: isc_maint_rpt_util_pkg.add_detail_column
896: ( p_detail_col_tbl => l_detail_col_tbl
897: , p_dimension_tbl => l_dimension_tbl
898: , p_fact_col_name => 'work_order_count'
899: , p_fact_col_total => 'N'

Line 903: isc_maint_rpt_util_pkg.add_detail_column

899: , p_fact_col_total => 'N'
900: , p_column_key => 'work_order_count'
901: );
902:
903: isc_maint_rpt_util_pkg.add_detail_column
904: ( p_detail_col_tbl => l_detail_col_tbl
905: , p_dimension_tbl => l_dimension_tbl
906: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
907: , p_column_key => 'asset_number'

Line 906: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER

902:
903: isc_maint_rpt_util_pkg.add_detail_column
904: ( p_detail_col_tbl => l_detail_col_tbl
905: , p_dimension_tbl => l_dimension_tbl
906: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
907: , p_column_key => 'asset_number'
908: );
909:
910: isc_maint_rpt_util_pkg.add_detail_column

Line 910: isc_maint_rpt_util_pkg.add_detail_column

906: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
907: , p_column_key => 'asset_number'
908: );
909:
910: isc_maint_rpt_util_pkg.add_detail_column
911: ( p_detail_col_tbl => l_detail_col_tbl
912: , p_dimension_tbl => l_dimension_tbl
913: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
914: , p_column_key => 'asset_group'

Line 913: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP

909:
910: isc_maint_rpt_util_pkg.add_detail_column
911: ( p_detail_col_tbl => l_detail_col_tbl
912: , p_dimension_tbl => l_dimension_tbl
913: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
914: , p_column_key => 'asset_group'
915: );
916:
917: isc_maint_rpt_util_pkg.add_detail_column

Line 917: isc_maint_rpt_util_pkg.add_detail_column

913: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
914: , p_column_key => 'asset_group'
915: );
916:
917: isc_maint_rpt_util_pkg.add_detail_column
918: ( p_detail_col_tbl => l_detail_col_tbl
919: , p_dimension_tbl => l_dimension_tbl
920: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
921: , p_column_key => 'department'

Line 920: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT

916:
917: isc_maint_rpt_util_pkg.add_detail_column
918: ( p_detail_col_tbl => l_detail_col_tbl
919: , p_dimension_tbl => l_dimension_tbl
920: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
921: , p_column_key => 'department'
922: );
923:
924: isc_maint_rpt_util_pkg.add_detail_column

Line 924: isc_maint_rpt_util_pkg.add_detail_column

920: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
921: , p_column_key => 'department'
922: );
923:
924: isc_maint_rpt_util_pkg.add_detail_column
925: ( p_detail_col_tbl => l_detail_col_tbl
926: , p_dimension_tbl => l_dimension_tbl
927: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES
928: , p_dim_level_col_name => 'name'

Line 927: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES

923:
924: isc_maint_rpt_util_pkg.add_detail_column
925: ( p_detail_col_tbl => l_detail_col_tbl
926: , p_dimension_tbl => l_dimension_tbl
927: , p_dimension_level => isc_maint_rpt_util_pkg.G_REQUEST_SEVERITIES
928: , p_dim_level_col_name => 'name'
929: , p_column_key => 'request_severity'
930: );
931:

Line 932: isc_maint_rpt_util_pkg.add_detail_column

928: , p_dim_level_col_name => 'name'
929: , p_column_key => 'request_severity'
930: );
931:
932: isc_maint_rpt_util_pkg.add_detail_column
933: ( p_detail_col_tbl => l_detail_col_tbl
934: , p_dimension_tbl => l_dimension_tbl
935: , p_fact_col_name => 'request_start_date'
936: , p_fact_col_total => 'N'

Line 941: isc_maint_rpt_util_pkg.add_detail_column

937: , p_column_key => 'request_start_date'
938: );
939:
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 => 'response_days'
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 => 'response_days'
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 => 'completion_days'
953: , p_fact_col_total => 'N'

Line 959: , ' || isc_maint_rpt_util_pkg.get_detail_column

955: );
956:
957: l_stmt := 'select
958: oset.request_number BIV_ATTRIBUTE1
959: , ' || isc_maint_rpt_util_pkg.get_detail_column
960: (l_detail_col_tbl,'description','BIV_ATTRIBUTE2') || '
961: , ' || isc_maint_rpt_util_pkg.get_detail_column
962: (l_detail_col_tbl,'request_type','BIV_ATTRIBUTE3') || '
963: , oset.work_order_count BIV_ATTRIBUTE4' || '

Line 961: , ' || isc_maint_rpt_util_pkg.get_detail_column

957: l_stmt := 'select
958: oset.request_number BIV_ATTRIBUTE1
959: , ' || isc_maint_rpt_util_pkg.get_detail_column
960: (l_detail_col_tbl,'description','BIV_ATTRIBUTE2') || '
961: , ' || isc_maint_rpt_util_pkg.get_detail_column
962: (l_detail_col_tbl,'request_type','BIV_ATTRIBUTE3') || '
963: , oset.work_order_count BIV_ATTRIBUTE4' || '
964: , ' || isc_maint_rpt_util_pkg.get_detail_column
965: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE5') || '

Line 964: , ' || isc_maint_rpt_util_pkg.get_detail_column

960: (l_detail_col_tbl,'description','BIV_ATTRIBUTE2') || '
961: , ' || isc_maint_rpt_util_pkg.get_detail_column
962: (l_detail_col_tbl,'request_type','BIV_ATTRIBUTE3') || '
963: , oset.work_order_count BIV_ATTRIBUTE4' || '
964: , ' || isc_maint_rpt_util_pkg.get_detail_column
965: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE5') || '
966: , ' || isc_maint_rpt_util_pkg.get_detail_column
967: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE6') || '
968: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 966: , ' || isc_maint_rpt_util_pkg.get_detail_column

962: (l_detail_col_tbl,'request_type','BIV_ATTRIBUTE3') || '
963: , oset.work_order_count BIV_ATTRIBUTE4' || '
964: , ' || isc_maint_rpt_util_pkg.get_detail_column
965: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE5') || '
966: , ' || isc_maint_rpt_util_pkg.get_detail_column
967: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE6') || '
968: , ' || isc_maint_rpt_util_pkg.get_detail_column
969: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
970: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 968: , ' || isc_maint_rpt_util_pkg.get_detail_column

964: , ' || isc_maint_rpt_util_pkg.get_detail_column
965: (l_detail_col_tbl,'asset_number','BIV_ATTRIBUTE5') || '
966: , ' || isc_maint_rpt_util_pkg.get_detail_column
967: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE6') || '
968: , ' || isc_maint_rpt_util_pkg.get_detail_column
969: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
970: , ' || isc_maint_rpt_util_pkg.get_detail_column
971: (l_detail_col_tbl,'request_severity','BIV_ATTRIBUTE8') || '
972: , oset.request_start_date BIV_MEASURE1

Line 970: , ' || isc_maint_rpt_util_pkg.get_detail_column

966: , ' || isc_maint_rpt_util_pkg.get_detail_column
967: (l_detail_col_tbl,'asset_group','BIV_ATTRIBUTE6') || '
968: , ' || isc_maint_rpt_util_pkg.get_detail_column
969: (l_detail_col_tbl,'department','BIV_ATTRIBUTE7') || '
970: , ' || isc_maint_rpt_util_pkg.get_detail_column
971: (l_detail_col_tbl,'request_severity','BIV_ATTRIBUTE8') || '
972: , oset.request_start_date BIV_MEASURE1
973: , oset.response_days BIV_MEASURE2
974: , oset.completion_days BIV_MEASURE3

Line 985: '''&BIV_ATTRIBUTE7='' || ' || isc_maint_rpt_util_pkg.get_detail_column

981: '''&BIV_MAINT_REQUEST_TYPE_LVL='' || oset.request_type ||' ||
982: '''&BIV_ATTRIBUTE9='' || oset.maint_request_id || ' ||
983: '''&BIV_ATTRIBUTE6='' || oset.request_number || ' ||
984: '''&BIV_ATTRIBUTE8='' || to_char(oset.request_start_date,fnd_profile.value(''ICX_DATE_FORMAT_MASK'')) || ' ||
985: '''&BIV_ATTRIBUTE7='' || ' || isc_maint_rpt_util_pkg.get_detail_column
986: (l_detail_col_tbl,'request_severity',null) || ' || ' ||
987: ''''' BIV_ATTRIBUTE9
988: , null BIV_ATTRIBUTE10' -- this is needed for bucket to AK region association
989: || '

Line 991: ' || isc_maint_rpt_util_pkg.detail_sql

987: ''''' BIV_ATTRIBUTE9
988: , null BIV_ATTRIBUTE10' -- this is needed for bucket to AK region association
989: || '
990: from
991: ' || isc_maint_rpt_util_pkg.detail_sql
992: ( p_detail_col_tbl => l_detail_col_tbl
993: , p_dimension_tbl => l_dimension_tbl
994: , p_mv_name => l_mv
995: , p_where_clause => l_where_clause

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

996: , p_rank_order => l_rank_order
997: );
998:
999: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
1000: --l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
1001:
1002: x_custom_sql := l_stmt;
1003:
1004: x_custom_output := l_custom_output;

Line 1015: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

1011: , x_custom_output out nocopy bis_query_attributes_tbl
1012: )
1013: as
1014:
1015: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1016: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1017: l_custom_output bis_query_attributes_tbl;
1018: l_curr_suffix varchar2(3);
1019: l_where_clause varchar2(10000);

Line 1031: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

1027: l_estimated varchar2(200);
1028: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1029: l_stmt varchar2(32767);
1030: l_rank_order varchar2(200);
1031: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
1032:
1033: begin
1034:
1035: isc_maint_rpt_util_pkg.register_dimension_levels

Line 1035: isc_maint_rpt_util_pkg.register_dimension_levels

1031: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
1032:
1033: begin
1034:
1035: isc_maint_rpt_util_pkg.register_dimension_levels
1036: ( l_dimension_tbl
1037: , l_dim_filter_map
1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'
1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'

Line 1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'

1034:
1035: isc_maint_rpt_util_pkg.register_dimension_levels
1036: ( l_dimension_tbl
1037: , l_dim_filter_map
1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'
1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'
1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'
1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'

Line 1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'

1035: isc_maint_rpt_util_pkg.register_dimension_levels
1036: ( l_dimension_tbl
1037: , l_dim_filter_map
1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'
1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'
1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'
1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'
1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'

Line 1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'

1036: ( l_dimension_tbl
1037: , l_dim_filter_map
1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'
1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'
1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'
1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'
1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'
1044: );

Line 1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'

1037: , l_dim_filter_map
1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'
1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'
1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'
1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'
1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'
1044: );
1045:

Line 1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'

1038: , isc_maint_rpt_util_pkg.G_ORGANIZATION, 'Y'
1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'
1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'
1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'
1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'
1044: );
1045:
1046: isc_maint_rpt_util_pkg.process_parameters

Line 1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'

1039: , isc_maint_rpt_util_pkg.G_DEPARTMENT, 'N'
1040: , isc_maint_rpt_util_pkg.G_REQUEST_TYPE, 'Y'
1041: , isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE, 'N'
1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'
1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'
1044: );
1045:
1046: isc_maint_rpt_util_pkg.process_parameters
1047: ( p_param => p_param

Line 1046: isc_maint_rpt_util_pkg.process_parameters

1042: , isc_maint_rpt_util_pkg.G_ACTIVITY, 'N'
1043: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'N'
1044: );
1045:
1046: isc_maint_rpt_util_pkg.process_parameters
1047: ( p_param => p_param
1048: , p_dimension_tbl => l_dimension_tbl
1049: , p_dim_filter_map => l_dim_filter_map
1050: , p_trend => 'D'

Line 1068: isc_maint_rpt_util_pkg.add_detail_column

1064: , l_dim_bmap
1065: , l_custom_output
1066: );
1067:
1068: isc_maint_rpt_util_pkg.add_detail_column
1069: ( p_detail_col_tbl => l_detail_col_tbl
1070: , p_dimension_tbl => l_dimension_tbl
1071: , p_fact_col_name => 'work_order_id'
1072: , p_fact_col_total => 'N'

Line 1076: isc_maint_rpt_util_pkg.add_detail_column

1072: , p_fact_col_total => 'N'
1073: , p_column_key => 'work_order_id'
1074: );
1075:
1076: isc_maint_rpt_util_pkg.add_detail_column
1077: ( p_detail_col_tbl => l_detail_col_tbl
1078: , p_dimension_tbl => l_dimension_tbl
1079: , p_fact_col_name => 'work_order_name'
1080: , p_fact_col_total => 'N'

Line 1084: isc_maint_rpt_util_pkg.add_detail_column

1080: , p_fact_col_total => 'N'
1081: , p_column_key => 'work_order_name'
1082: );
1083:
1084: isc_maint_rpt_util_pkg.add_detail_column
1085: ( p_detail_col_tbl => l_detail_col_tbl
1086: , p_dimension_tbl => l_dimension_tbl
1087: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1088: , p_column_key => 'work_order_type'

Line 1087: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE

1083:
1084: isc_maint_rpt_util_pkg.add_detail_column
1085: ( p_detail_col_tbl => l_detail_col_tbl
1086: , p_dimension_tbl => l_dimension_tbl
1087: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1088: , p_column_key => 'work_order_type'
1089: );
1090:
1091: isc_maint_rpt_util_pkg.add_detail_column

Line 1091: isc_maint_rpt_util_pkg.add_detail_column

1087: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_TYPE
1088: , p_column_key => 'work_order_type'
1089: );
1090:
1091: isc_maint_rpt_util_pkg.add_detail_column
1092: ( p_detail_col_tbl => l_detail_col_tbl
1093: , p_dimension_tbl => l_dimension_tbl
1094: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1095: , p_column_key => 'activity'

Line 1094: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY

1090:
1091: isc_maint_rpt_util_pkg.add_detail_column
1092: ( p_detail_col_tbl => l_detail_col_tbl
1093: , p_dimension_tbl => l_dimension_tbl
1094: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1095: , p_column_key => 'activity'
1096: );
1097:
1098: isc_maint_rpt_util_pkg.add_detail_column

Line 1098: isc_maint_rpt_util_pkg.add_detail_column

1094: , p_dimension_level => isc_maint_rpt_util_pkg.G_ACTIVITY
1095: , p_column_key => 'activity'
1096: );
1097:
1098: isc_maint_rpt_util_pkg.add_detail_column
1099: ( p_detail_col_tbl => l_detail_col_tbl
1100: , p_dimension_tbl => l_dimension_tbl
1101: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS
1102: , p_column_key => 'work_order_status'

Line 1101: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS

1097:
1098: isc_maint_rpt_util_pkg.add_detail_column
1099: ( p_detail_col_tbl => l_detail_col_tbl
1100: , p_dimension_tbl => l_dimension_tbl
1101: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS
1102: , p_column_key => 'work_order_status'
1103: );
1104:
1105: isc_maint_rpt_util_pkg.add_detail_column

Line 1105: isc_maint_rpt_util_pkg.add_detail_column

1101: , p_dimension_level => isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS
1102: , p_column_key => 'work_order_status'
1103: );
1104:
1105: isc_maint_rpt_util_pkg.add_detail_column
1106: ( p_detail_col_tbl => l_detail_col_tbl
1107: , p_dimension_tbl => l_dimension_tbl
1108: , p_fact_col_name => 'scheduled_start_date'
1109: , p_fact_col_total => 'N'

Line 1113: isc_maint_rpt_util_pkg.add_detail_column

1109: , p_fact_col_total => 'N'
1110: , p_column_key => 'scheduled_start_date'
1111: );
1112:
1113: isc_maint_rpt_util_pkg.add_detail_column
1114: ( p_detail_col_tbl => l_detail_col_tbl
1115: , p_dimension_tbl => l_dimension_tbl
1116: , p_fact_col_name => 'scheduled_completion_date'
1117: , p_fact_col_total => 'N'

Line 1121: isc_maint_rpt_util_pkg.add_detail_column

1117: , p_fact_col_total => 'N'
1118: , p_column_key => 'scheduled_completion_date'
1119: );
1120:
1121: isc_maint_rpt_util_pkg.add_detail_column
1122: ( p_detail_col_tbl => l_detail_col_tbl
1123: , p_dimension_tbl => l_dimension_tbl
1124: , p_fact_col_name => 'completion_date'
1125: , p_fact_col_total => 'N'

Line 1131: , ' || isc_maint_rpt_util_pkg.get_detail_column

1127: );
1128:
1129: l_stmt := 'select
1130: oset.work_order_name BIV_ATTRIBUTE1
1131: , ' || isc_maint_rpt_util_pkg.get_detail_column
1132: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1133: , ' || isc_maint_rpt_util_pkg.get_detail_column
1134: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE3') || '
1135: , ' || isc_maint_rpt_util_pkg.get_detail_column

Line 1133: , ' || isc_maint_rpt_util_pkg.get_detail_column

1129: l_stmt := 'select
1130: oset.work_order_name BIV_ATTRIBUTE1
1131: , ' || isc_maint_rpt_util_pkg.get_detail_column
1132: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1133: , ' || isc_maint_rpt_util_pkg.get_detail_column
1134: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE3') || '
1135: , ' || isc_maint_rpt_util_pkg.get_detail_column
1136: (l_detail_col_tbl,'work_order_status','BIV_ATTRIBUTE4') || '
1137: , oset.scheduled_start_date BIV_MEASURE1

Line 1135: , ' || isc_maint_rpt_util_pkg.get_detail_column

1131: , ' || isc_maint_rpt_util_pkg.get_detail_column
1132: (l_detail_col_tbl,'work_order_type','BIV_ATTRIBUTE2') || '
1133: , ' || isc_maint_rpt_util_pkg.get_detail_column
1134: (l_detail_col_tbl,'activity','BIV_ATTRIBUTE3') || '
1135: , ' || isc_maint_rpt_util_pkg.get_detail_column
1136: (l_detail_col_tbl,'work_order_status','BIV_ATTRIBUTE4') || '
1137: , oset.scheduled_start_date BIV_MEASURE1
1138: , oset.scheduled_completion_date BIV_MEASURE2
1139: , oset.completion_date BIV_MEASURE3

Line 1141: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE5') || '

1137: , oset.scheduled_start_date BIV_MEASURE1
1138: , oset.scheduled_completion_date BIV_MEASURE2
1139: , oset.completion_date BIV_MEASURE3
1140: , ' ||
1141: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE5') || '
1142: from
1143: ' || isc_maint_rpt_util_pkg.detail_sql
1144: ( p_detail_col_tbl => l_detail_col_tbl
1145: , p_dimension_tbl => l_dimension_tbl

Line 1143: ' || isc_maint_rpt_util_pkg.detail_sql

1139: , oset.completion_date BIV_MEASURE3
1140: , ' ||
1141: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE5') || '
1142: from
1143: ' || isc_maint_rpt_util_pkg.detail_sql
1144: ( p_detail_col_tbl => l_detail_col_tbl
1145: , p_dimension_tbl => l_dimension_tbl
1146: , p_mv_name => l_mv
1147: , p_where_clause => l_where_clause

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

1148: , p_rank_order => null
1149: );
1150:
1151: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
1152: -- l_stmt := l_stmt || isc_maint_rpt_util_pkg.dump_parameters(p_param);
1153:
1154: x_custom_sql := l_stmt;
1155:
1156: bind_request_id( l_custom_output, p_param );