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_ASSET_DT_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: tmp1 varchar2(2000);
17:
18: begin
19: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
20: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);
21:
22: if p_report_type = 'ASSET_DOWNTIME_REPORT' then
23: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

Line 20: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);

16: tmp1 varchar2(2000);
17:
18: begin
19: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
20: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);
21:
22: if p_report_type = 'ASSET_DOWNTIME_REPORT' then
23: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
24: ( p_param , 'VIEW_BY');

Line 23: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

19: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
20: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);
21:
22: if p_report_type = 'ASSET_DOWNTIME_REPORT' then
23: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
24: ( p_param , 'VIEW_BY');
25:
26: isc_maint_rpt_util_pkg.bind_group_id
27: ( p_dim_bmap

Line 26: isc_maint_rpt_util_pkg.bind_group_id

22: if p_report_type = 'ASSET_DOWNTIME_REPORT' then
23: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
24: ( p_param , 'VIEW_BY');
25:
26: isc_maint_rpt_util_pkg.bind_group_id
27: ( p_dim_bmap
28: , p_custom_output
29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

Line 29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP

25:
26: isc_maint_rpt_util_pkg.bind_group_id
27: ( p_dim_bmap
28: , p_custom_output
29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
31: -- , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY
32: , isc_maint_rpt_util_pkg.G_DEPARTMENT
33: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY

Line 30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER

26: isc_maint_rpt_util_pkg.bind_group_id
27: ( p_dim_bmap
28: , p_custom_output
29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
31: -- , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY
32: , isc_maint_rpt_util_pkg.G_DEPARTMENT
33: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY
34: );

Line 31: -- , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY

27: ( p_dim_bmap
28: , p_custom_output
29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
31: -- , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY
32: , isc_maint_rpt_util_pkg.G_DEPARTMENT
33: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY
34: );
35:

Line 32: , isc_maint_rpt_util_pkg.G_DEPARTMENT

28: , p_custom_output
29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
31: -- , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY
32: , isc_maint_rpt_util_pkg.G_DEPARTMENT
33: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY
34: );
35:
36:

Line 33: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY

29: , isc_maint_rpt_util_pkg.G_ASSET_GROUP
30: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER
31: -- , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY
32: , isc_maint_rpt_util_pkg.G_DEPARTMENT
33: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY
34: );
35:
36:
37: return '(select

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

39: , period_type_id
40: , grp_id
41: , ' ||
42: case l_view_by /* replaced asset_number with instance_id */
43: when isc_maint_rpt_util_pkg.G_DEPARTMENT then 'decode(department_id,-1,-1,organization_id) organization_id'
44: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then 'decode(asset_group_id,-1,-1,organization_id) organization_id'
45: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,organization_id) organization_id'
46: when isc_maint_rpt_util_pkg.G_ASSET_CATEGORY then 'decode(category_id,-1,-1,organization_id) organization_id'
47: else 'organization_id'

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

40: , grp_id
41: , ' ||
42: case l_view_by /* replaced asset_number with instance_id */
43: when isc_maint_rpt_util_pkg.G_DEPARTMENT then 'decode(department_id,-1,-1,organization_id) organization_id'
44: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then 'decode(asset_group_id,-1,-1,organization_id) organization_id'
45: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,organization_id) organization_id'
46: when isc_maint_rpt_util_pkg.G_ASSET_CATEGORY then 'decode(category_id,-1,-1,organization_id) organization_id'
47: else 'organization_id'
48: end ||'

Line 45: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,organization_id) organization_id'

41: , ' ||
42: case l_view_by /* replaced asset_number with instance_id */
43: when isc_maint_rpt_util_pkg.G_DEPARTMENT then 'decode(department_id,-1,-1,organization_id) organization_id'
44: when isc_maint_rpt_util_pkg.G_ASSET_GROUP then 'decode(asset_group_id,-1,-1,organization_id) organization_id'
45: when isc_maint_rpt_util_pkg.G_ASSET_NUMBER then 'decode(instance_id,-1,-1,organization_id) organization_id'
46: when isc_maint_rpt_util_pkg.G_ASSET_CATEGORY then 'decode(category_id,-1,-1,organization_id) organization_id'
47: else 'organization_id'
48: end ||'
49: ,asset_group_id

Line 46: when isc_maint_rpt_util_pkg.G_ASSET_CATEGORY then 'decode(category_id,-1,-1,organization_id) organization_id'

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

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

60: where fact.grp_id = &ISC_GRP_ID ' ||
61: case
62: when l_org_id is null then
63: '
64: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
65: end || '
66: )';
67:
68: else

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

94: fact.start_date < &BIS_CURRENT_ASOF_DATE+1 and
95: fact.end_date >= &BIS_CURRENT_EFFECTIVE_START_DATE ' ||
96: case
97: when l_org_id is null then
98: 'and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
99: end || '
100: ) ';
101:
102: end if ;

Line 115: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

111: , x_custom_output out nocopy bis_query_attributes_tbl
112: )
113: is
114:
115: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
116: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
117: l_dim_bmap number;
118: l_comparison_type varchar2(200);
119: l_xtd varchar2(200);

Line 143: isc_maint_rpt_util_pkg.register_dimension_levels

139: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
140:
141: ---- view by dimensions that can be possible except org and dept ie register them -----
142:
143: isc_maint_rpt_util_pkg.register_dimension_levels
144: ( l_dimension_tbl
145: , l_dim_filter_map
146: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
147: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 146: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

142:
143: isc_maint_rpt_util_pkg.register_dimension_levels
144: ( l_dimension_tbl
145: , l_dim_filter_map
146: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
147: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
148: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
149: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
150: );

Line 147: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

143: isc_maint_rpt_util_pkg.register_dimension_levels
144: ( l_dimension_tbl
145: , l_dim_filter_map
146: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
147: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
148: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
149: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
150: );
151:

Line 148: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'

144: ( l_dimension_tbl
145: , l_dim_filter_map
146: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
147: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
148: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
149: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
150: );
151:
152: isc_maint_rpt_util_pkg.process_parameters

Line 149: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'

145: , l_dim_filter_map
146: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
147: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
148: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
149: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
150: );
151:
152: isc_maint_rpt_util_pkg.process_parameters
153: ( p_param => p_param

Line 152: isc_maint_rpt_util_pkg.process_parameters

148: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
149: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
150: );
151:
152: isc_maint_rpt_util_pkg.process_parameters
153: ( p_param => p_param
154: , p_dimension_tbl => l_dimension_tbl
155: , p_dim_filter_map => l_dim_filter_map
156: , p_trend => 'N'

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

181: /* check for view if asset_number add criticality and asset_group and drill across link
182: if asset_group then add drill down link only
183: else nullify all */
184:
185: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) = isc_maint_rpt_util_pkg.G_ASSET_NUMBER
186: then
187: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
188: l_criticality_column := isc_maint_rpt_util_pkg.add_view_by(isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, l_dimension_tbl,l_join_tbl);
189: l_drill_across := ' ''pFunctionName=ISC_MAINT_ASSET_DT_RPT_REP'' ||

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

183: else nullify all */
184:
185: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) = isc_maint_rpt_util_pkg.G_ASSET_NUMBER
186: then
187: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
188: l_criticality_column := isc_maint_rpt_util_pkg.add_view_by(isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, l_dimension_tbl,l_join_tbl);
189: l_drill_across := ' ''pFunctionName=ISC_MAINT_ASSET_DT_RPT_REP'' ||
190: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||''&pParamIds=Y'' ' ;
191: l_drill_down := 'NULL';

Line 188: l_criticality_column := isc_maint_rpt_util_pkg.add_view_by(isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, l_dimension_tbl,l_join_tbl);

184:
185: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) = isc_maint_rpt_util_pkg.G_ASSET_NUMBER
186: then
187: l_asset_grp_column := isc_maint_rpt_util_pkg.add_asset_group_column(isc_maint_rpt_util_pkg.G_ASSET_NUMBER,l_dimension_tbl);
188: l_criticality_column := isc_maint_rpt_util_pkg.add_view_by(isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, l_dimension_tbl,l_join_tbl);
189: l_drill_across := ' ''pFunctionName=ISC_MAINT_ASSET_DT_RPT_REP'' ||
190: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||''&pParamIds=Y'' ' ;
191: l_drill_down := 'NULL';
192: else

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

189: l_drill_across := ' ''pFunctionName=ISC_MAINT_ASSET_DT_RPT_REP'' ||
190: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||''&pParamIds=Y'' ' ;
191: l_drill_down := 'NULL';
192: else
193: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')=isc_maint_rpt_util_pkg.G_ASSET_GROUP)
194: then
195: l_asset_grp_column :='NULL';
196: l_criticality_column := 'NULL';
197: l_drill_across := 'NULL';

Line 231: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs,0)',

227: /* calculate the rank on the sorting column in the inline view */
228: l_inner_query := 'from ( select row_number() over(&ORDER_BY_CLAUSE nulls last )-1 rnk,iset.*'||
229: ' from ( select nvl(oset05.p_dt_non_overlap_hrs,0) BIV_MEASURE1
230: ,nvl(oset05.c_dt_non_overlap_hrs,0) BIV_MEASURE2, ' ||
231: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs,0)',
232: 'nvl(oset05.p_dt_non_overlap_hrs,0)','BIV_MEASURE3','X') || '
233: ,nvl(oset05.c_dt_non_overlap_hrs_total,0) BIV_MEASURE13, ' ||
234: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs_total,0)',
235: 'nvl(oset05.p_dt_non_overlap_hrs_total,0)','BIV_MEASURE14','X') || '

Line 234: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs_total,0)',

230: ,nvl(oset05.c_dt_non_overlap_hrs,0) BIV_MEASURE2, ' ||
231: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs,0)',
232: 'nvl(oset05.p_dt_non_overlap_hrs,0)','BIV_MEASURE3','X') || '
233: ,nvl(oset05.c_dt_non_overlap_hrs_total,0) BIV_MEASURE13, ' ||
234: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs_total,0)',
235: 'nvl(oset05.p_dt_non_overlap_hrs_total,0)','BIV_MEASURE14','X') || '
236: ,nvl(oset05.p_dt_non_overlap_hrs_total,0) BIV_MEASURE15,'||
237: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ' from ';
238:

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

233: ,nvl(oset05.c_dt_non_overlap_hrs_total,0) BIV_MEASURE13, ' ||
234: isc_maint_rpt_util_pkg.change_column('nvl(oset05.c_dt_non_overlap_hrs_total,0)',
235: 'nvl(oset05.p_dt_non_overlap_hrs_total,0)','BIV_MEASURE14','X') || '
236: ,nvl(oset05.p_dt_non_overlap_hrs_total,0) BIV_MEASURE15,'||
237: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl) || ' from ';
238:
239:
240:
241: l_stmt := l_stmt || l_inner_query;

Line 268: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

264: , x_custom_sql out nocopy varchar2
265: , x_custom_output out nocopy bis_query_attributes_tbl
266: )
267: is
268: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
269: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
270: l_dim_bmap number;
271: l_comparison_type varchar2(200);
272: l_xtd varchar2(200);

Line 284: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

280: l_custom_output bis_query_attributes_tbl;
281: l_rank_order varchar2(100);
282: l_cost_element varchar2(200);
283: l_curr_suffix varchar2(2);
284: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
285: l_viewby_select varchar2(200);
286: BEGIN
287:
288: -- clear out the tables.

Line 292: isc_maint_rpt_util_pkg.register_dimension_levels

288: -- clear out the tables.
289: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
290: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
291:
292: isc_maint_rpt_util_pkg.register_dimension_levels
293: ( l_dimension_tbl
294: , l_dim_filter_map
295: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
296: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 295: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

291:
292: isc_maint_rpt_util_pkg.register_dimension_levels
293: ( l_dimension_tbl
294: , l_dim_filter_map
295: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
296: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
297: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
298: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
299: );

Line 296: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

292: isc_maint_rpt_util_pkg.register_dimension_levels
293: ( l_dimension_tbl
294: , l_dim_filter_map
295: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
296: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
297: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
298: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
299: );
300:

Line 297: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'

293: ( l_dimension_tbl
294: , l_dim_filter_map
295: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
296: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
297: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
298: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
299: );
300:
301: isc_maint_rpt_util_pkg.process_parameters

Line 298: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'

294: , l_dim_filter_map
295: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
296: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
297: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
298: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
299: );
300:
301: isc_maint_rpt_util_pkg.process_parameters
302: ( p_param => p_param

Line 301: isc_maint_rpt_util_pkg.process_parameters

297: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
298: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
299: );
300:
301: isc_maint_rpt_util_pkg.process_parameters
302: ( p_param => p_param
303: , p_dimension_tbl => l_dimension_tbl
304: , p_dim_filter_map => l_dim_filter_map
305: , p_trend => 'D'

Line 322: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value

318: , p_param
319: , l_dim_bmap
320: , l_custom_output
321: );
322: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value
323: ( p_param
324: , 'ORDERBY'
325: );
326: if l_order_by like '%DESC%' then

Line 347: isc_maint_rpt_util_pkg.add_detail_column

343: /* added organization_id since making asset_group independent of org. the org_id is
344: not getting propogated which is required as a parameter in the hyperlink to the
345: work order */
346:
347: isc_maint_rpt_util_pkg.add_detail_column
348: ( p_detail_col_tbl => l_detail_col_tbl
349: , p_dimension_tbl => l_dimension_tbl
350: , p_dimension_level => isc_maint_rpt_util_pkg.G_ORGANIZATION
351: , p_column_key => 'organization_id'

Line 350: , p_dimension_level => isc_maint_rpt_util_pkg.G_ORGANIZATION

346:
347: isc_maint_rpt_util_pkg.add_detail_column
348: ( p_detail_col_tbl => l_detail_col_tbl
349: , p_dimension_tbl => l_dimension_tbl
350: , p_dimension_level => isc_maint_rpt_util_pkg.G_ORGANIZATION
351: , p_column_key => 'organization_id'
352: );
353:
354:

Line 355: isc_maint_rpt_util_pkg.add_detail_column

351: , p_column_key => 'organization_id'
352: );
353:
354:
355: isc_maint_rpt_util_pkg.add_detail_column
356: ( p_detail_col_tbl => l_detail_col_tbl
357: , p_dimension_tbl => l_dimension_tbl
358: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
359: , p_column_key => 'instance_id'

Line 358: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER

354:
355: isc_maint_rpt_util_pkg.add_detail_column
356: ( p_detail_col_tbl => l_detail_col_tbl
357: , p_dimension_tbl => l_dimension_tbl
358: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
359: , p_column_key => 'instance_id'
360: );
361:
362: isc_maint_rpt_util_pkg.add_detail_column

Line 362: isc_maint_rpt_util_pkg.add_detail_column

358: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_NUMBER
359: , p_column_key => 'instance_id'
360: );
361:
362: isc_maint_rpt_util_pkg.add_detail_column
363: ( p_detail_col_tbl => l_detail_col_tbl
364: , p_dimension_tbl => l_dimension_tbl
365: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
366: , p_column_key => 'asset_group'

Line 365: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP

361:
362: isc_maint_rpt_util_pkg.add_detail_column
363: ( p_detail_col_tbl => l_detail_col_tbl
364: , p_dimension_tbl => l_dimension_tbl
365: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
366: , p_column_key => 'asset_group'
367: );
368:
369: isc_maint_rpt_util_pkg.add_detail_column

Line 369: isc_maint_rpt_util_pkg.add_detail_column

365: , p_dimension_level => isc_maint_rpt_util_pkg.G_ASSET_GROUP
366: , p_column_key => 'asset_group'
367: );
368:
369: isc_maint_rpt_util_pkg.add_detail_column
370: ( p_detail_col_tbl => l_detail_col_tbl
371: , p_dimension_tbl => l_dimension_tbl
372: , p_fact_col_name => 'START_DATE'
373: , p_fact_col_total => 'N'

Line 377: isc_maint_rpt_util_pkg.add_detail_column

373: , p_fact_col_total => 'N'
374: , p_column_key => 'START_DATE'
375: );
376:
377: isc_maint_rpt_util_pkg.add_detail_column
378: ( p_detail_col_tbl => l_detail_col_tbl
379: , p_dimension_tbl => l_dimension_tbl
380: , p_fact_col_name => 'END_DATE'
381: , p_fact_col_total => 'N'

Line 385: isc_maint_rpt_util_pkg.add_detail_column

381: , p_fact_col_total => 'N'
382: , p_column_key => 'END_DATE'
383: );
384:
385: isc_maint_rpt_util_pkg.add_detail_column
386: ( p_detail_col_tbl => l_detail_col_tbl
387: , p_dimension_tbl => l_dimension_tbl
388: , p_fact_col_name => 'WORK_ORDER_ID'
389: , p_fact_col_total => 'N'

Line 393: isc_maint_rpt_util_pkg.add_detail_column

389: , p_fact_col_total => 'N'
390: , p_column_key => 'WORK_ORDER_ID'
391: );
392:
393: isc_maint_rpt_util_pkg.add_detail_column
394: ( p_detail_col_tbl => l_detail_col_tbl
395: , p_dimension_tbl => l_dimension_tbl
396: , p_fact_col_name => 'WORK_ORDER_NAME'
397: , p_fact_col_total => 'N'

Line 401: isc_maint_rpt_util_pkg.add_detail_column

397: , p_fact_col_total => 'N'
398: , p_column_key => 'WORK_ORDER_NAME'
399: );
400:
401: isc_maint_rpt_util_pkg.add_detail_column
402: ( p_detail_col_tbl => l_detail_col_tbl
403: , p_dimension_tbl => l_dimension_tbl
404: , p_fact_col_name => 'OPERATION_SEQ_NUMBER'
405: , p_fact_col_total => 'N'

Line 409: isc_maint_rpt_util_pkg.add_detail_column

405: , p_fact_col_total => 'N'
406: , p_column_key => 'OPERATION'
407: );
408:
409: isc_maint_rpt_util_pkg.add_detail_column
410: ( p_detail_col_tbl => l_detail_col_tbl
411: , p_dimension_tbl => l_dimension_tbl
412: , p_fact_col_name => 'DESCRIPTION'
413: , p_fact_col_total => 'N'

Line 417: isc_maint_rpt_util_pkg.add_detail_column

413: , p_fact_col_total => 'N'
414: , p_column_key => 'DESCRIPTION'
415: );
416:
417: isc_maint_rpt_util_pkg.add_detail_column
418: ( p_detail_col_tbl => l_detail_col_tbl
419: , p_dimension_tbl => l_dimension_tbl
420: , p_fact_col_name => 'dt_overlap_hrs'
421: , p_fact_col_total => 'N'

Line 427: ' || isc_maint_rpt_util_pkg.get_detail_column

423: );
424:
425:
426: l_stmt := 'select
427: ' || isc_maint_rpt_util_pkg.get_detail_column
428: (l_detail_col_tbl,'instance_id','BIV_MEASURE1') || '
429: , ' || isc_maint_rpt_util_pkg.get_detail_column
430: (l_detail_col_tbl,'asset_group','BIV_MEASURE2') || '
431: , oset.START_DATE BIV_MEASURE3

Line 429: , ' || isc_maint_rpt_util_pkg.get_detail_column

425:
426: l_stmt := 'select
427: ' || isc_maint_rpt_util_pkg.get_detail_column
428: (l_detail_col_tbl,'instance_id','BIV_MEASURE1') || '
429: , ' || isc_maint_rpt_util_pkg.get_detail_column
430: (l_detail_col_tbl,'asset_group','BIV_MEASURE2') || '
431: , oset.START_DATE BIV_MEASURE3
432: , oset.END_DATE BIV_MEASURE13
433: , oset.dt_overlap_hrs BIV_MEASURE14

Line 438: isc_maint_rpt_util_pkg.get_drill_detail(' ') ||

434: , oset.WORK_ORDER_NAME BIV_MEASURE15
435: , oset.OPERATION BIV_MEASURE16
436: , oset.DESCRIPTION BIV_MEASURE17 ,
437: case when oset.work_order_id is null then null else '||
438: isc_maint_rpt_util_pkg.get_drill_detail(' ') ||
439: ' end BIV_ATTRIBUTE1 from
440: ' || isc_maint_rpt_util_pkg.detail_sql
441: ( p_detail_col_tbl => l_detail_col_tbl
442: , p_dimension_tbl => l_dimension_tbl

Line 440: ' || isc_maint_rpt_util_pkg.detail_sql

436: , oset.DESCRIPTION BIV_MEASURE17 ,
437: case when oset.work_order_id is null then null else '||
438: isc_maint_rpt_util_pkg.get_drill_detail(' ') ||
439: ' end BIV_ATTRIBUTE1 from
440: ' || isc_maint_rpt_util_pkg.detail_sql
441: ( p_detail_col_tbl => l_detail_col_tbl
442: , p_dimension_tbl => l_dimension_tbl
443: , p_mv_name => l_mv
444: , p_where_clause => l_where_clause

Line 462: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

458: , x_custom_sql out nocopy varchar2
459: , x_custom_output out nocopy bis_query_attributes_tbl
460: )
461: is
462: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
463: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
464: l_dim_bmap number;
465: l_comparison_type varchar2(200);
466: l_xtd varchar2(200);

Line 481: isc_maint_rpt_util_pkg.register_dimension_levels

477: -- clear out the tables.
478: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
479: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
480:
481: isc_maint_rpt_util_pkg.register_dimension_levels
482: ( l_dimension_tbl
483: , l_dim_filter_map
484: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
485: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

Line 484: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'

480:
481: isc_maint_rpt_util_pkg.register_dimension_levels
482: ( l_dimension_tbl
483: , l_dim_filter_map
484: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
485: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
486: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
487: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
488: );

Line 485: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'

481: isc_maint_rpt_util_pkg.register_dimension_levels
482: ( l_dimension_tbl
483: , l_dim_filter_map
484: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
485: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
486: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
487: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
488: );
489:

Line 486: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'

482: ( l_dimension_tbl
483: , l_dim_filter_map
484: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
485: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
486: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
487: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
488: );
489:
490: isc_maint_rpt_util_pkg.process_parameters

Line 487: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'

483: , l_dim_filter_map
484: , isc_maint_rpt_util_pkg.G_ASSET_GROUP, 'Y'
485: , isc_maint_rpt_util_pkg.G_ASSET_NUMBER, 'Y'
486: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
487: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
488: );
489:
490: isc_maint_rpt_util_pkg.process_parameters
491: ( p_param => p_param

Line 490: isc_maint_rpt_util_pkg.process_parameters

486: , isc_maint_rpt_util_pkg.G_ASSET_CATEGORY, 'Y'
487: , isc_maint_rpt_util_pkg.G_ASSET_CRITICALITY, 'Y'
488: );
489:
490: isc_maint_rpt_util_pkg.process_parameters
491: ( p_param => p_param
492: , p_dimension_tbl => l_dimension_tbl
493: , p_dim_filter_map => l_dim_filter_map
494: , p_trend => 'Y'

Line 522: isc_maint_rpt_util_pkg.change_column('nvl(iset.c_dt_non_overlap_hrs,0)',

518: l_stmt := 'select
519: cal.name VIEWBY
520: , nvl(iset.p_dt_non_overlap_hrs,0) BIV_MEASURE2
521: , nvl(iset.c_dt_non_overlap_hrs,0) BIV_MEASURE3 , ' ||
522: isc_maint_rpt_util_pkg.change_column('nvl(iset.c_dt_non_overlap_hrs,0)',
523: 'nvl(iset.p_dt_non_overlap_hrs,0)','BIV_MEASURE4','X')||'
524: from ' ||
525: poa_dbi_template_pkg.trend_sql
526: ( p_xtd => l_xtd