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

Line 17: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id

13: l_view_by varchar2(200);
14: tmp1 varchar2(2000);
15:
16: begin
17: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
18: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);
19:
20:
21:

Line 18: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);

14: tmp1 varchar2(2000);
15:
16: begin
17: l_org_id := isc_maint_rpt_util_pkg.get_parameter_id
18: ( p_param, isc_maint_rpt_util_pkg.G_ORGANIZATION);
19:
20:
21:
22:

Line 25: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value

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

Line 27: isc_maint_rpt_util_pkg.bind_group_id

23: if p_report_type = 'LAB_BLG_RPT' then
24:
25: l_view_by := isc_maint_rpt_util_pkg.get_parameter_value
26: (p_param , 'VIEW_BY');
27: isc_maint_rpt_util_pkg.bind_group_id
28: ( p_dim_bmap
29: , p_custom_output
30: , isc_maint_rpt_util_pkg.G_DEPARTMENT
31: , isc_maint_rpt_util_pkg.G_RESOURCE

Line 30: , isc_maint_rpt_util_pkg.G_DEPARTMENT

26: (p_param , 'VIEW_BY');
27: isc_maint_rpt_util_pkg.bind_group_id
28: ( p_dim_bmap
29: , p_custom_output
30: , isc_maint_rpt_util_pkg.G_DEPARTMENT
31: , isc_maint_rpt_util_pkg.G_RESOURCE
32: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS
33: );
34:

Line 31: , isc_maint_rpt_util_pkg.G_RESOURCE

27: isc_maint_rpt_util_pkg.bind_group_id
28: ( p_dim_bmap
29: , p_custom_output
30: , isc_maint_rpt_util_pkg.G_DEPARTMENT
31: , isc_maint_rpt_util_pkg.G_RESOURCE
32: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS
33: );
34:
35: return '(select

Line 32: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS

28: ( p_dim_bmap
29: , p_custom_output
30: , isc_maint_rpt_util_pkg.G_DEPARTMENT
31: , isc_maint_rpt_util_pkg.G_RESOURCE
32: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS
33: );
34:
35: return '(select
36: grp_id,'||

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

34:
35: return '(select
36: grp_id,'||
37: case l_view_by
38: when isc_maint_rpt_util_pkg.G_DEPARTMENT then 'decode(department_id,-1,-1,organization_id) organization_id'
39: when isc_maint_rpt_util_pkg.G_RESOURCE then 'decode(resource_id,-1,-1,organization_id) organization_id'
40: else 'organization_id'
41: end ||'
42: ,user_defined_status_id /* system and user defined status id */

Line 39: when isc_maint_rpt_util_pkg.G_RESOURCE then 'decode(resource_id,-1,-1,organization_id) organization_id'

35: return '(select
36: grp_id,'||
37: case l_view_by
38: when isc_maint_rpt_util_pkg.G_DEPARTMENT then 'decode(department_id,-1,-1,organization_id) organization_id'
39: when isc_maint_rpt_util_pkg.G_RESOURCE then 'decode(resource_id,-1,-1,organization_id) organization_id'
40: else 'organization_id'
41: end ||'
42: ,user_defined_status_id /* system and user defined status id */
43: ,organization_id organization_id_c

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

51: where fact.grp_id = &ISC_GRP_ID ' ||
52: case
53: when l_org_id is null then
54: '
55: and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
56: end || '
57: )';
58:
59: end if;

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

77: from
78: isc_maint_lab_blg_f fact where 1=1 ' ||
79: case
80: when l_org_id is null then
81: 'and ' || isc_maint_rpt_util_pkg.get_sec_where_clause( 'fact', l_org_id )
82: end || '
83: ) ';
84:
85: end get_fact_mv_name;

Line 98: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

94: )
95: is
96:
97:
98: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
99: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
100: l_dim_bmap number;
101: l_comparison_type varchar2(200);
102: l_xtd varchar2(200);

Line 124: isc_maint_rpt_util_pkg.register_dimension_levels

120: -- clear out the tables.
121: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
122: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
123:
124: isc_maint_rpt_util_pkg.register_dimension_levels
125: ( l_dimension_tbl
126: , l_dim_filter_map
127: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
128: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'

Line 127: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'

123:
124: isc_maint_rpt_util_pkg.register_dimension_levels
125: ( l_dimension_tbl
126: , l_dim_filter_map
127: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
128: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'
129: );
130:
131: isc_maint_rpt_util_pkg.process_parameters

Line 128: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'

124: isc_maint_rpt_util_pkg.register_dimension_levels
125: ( l_dimension_tbl
126: , l_dim_filter_map
127: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
128: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'
129: );
130:
131: isc_maint_rpt_util_pkg.process_parameters
132: ( p_param => p_param

Line 131: isc_maint_rpt_util_pkg.process_parameters

127: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
128: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'
129: );
130:
131: isc_maint_rpt_util_pkg.process_parameters
132: ( p_param => p_param
133: , p_dimension_tbl => l_dimension_tbl
134: , p_dim_filter_map => l_dim_filter_map
135: , p_trend => 'K'

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

178: biv_measure6,
179: biv_attribute1 ';
180:
181:
182: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY') = isc_maint_rpt_util_pkg.G_RESOURCE)
183: then
184: l_drill_across := ', ''pFunctionName=ISC_MAINT_LAB_BLG_RPT_REP'' ||
185: ''&VIEW_BY_NAME=VIEW_BY_ID'' ||''&pParamIds=Y'' BIV_ATTRIBUTE1 ' ;
186: else

Line 194: isc_maint_rpt_util_pkg.change_column('c_hours_required','c_hours_charged','BIV_MEASURE3','X') ||

190: /* calculate the rank on the sorting column in the inline view */
191: l_inner_query := 'from ( select iset.*, row_number() over(&ORDER_BY_CLAUSE nulls last )-1 rnk'||
192: ' from ( select c_hours_required BIV_MEASURE1, '||
193: ' c_hours_charged BIV_MEASURE2, ' ||
194: isc_maint_rpt_util_pkg.change_column('c_hours_required','c_hours_charged','BIV_MEASURE3','X') ||
195: ', c_hours_required_total BIV_MEASURE4 , c_hours_charged_total BIV_MEASURE5 ,' ||
196: isc_maint_rpt_util_pkg.change_column('c_hours_required_total','c_hours_charged_total','BIV_MEASURE6','X')
197: ||l_drill_across ||','
198: ||isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';

Line 196: isc_maint_rpt_util_pkg.change_column('c_hours_required_total','c_hours_charged_total','BIV_MEASURE6','X')

192: ' from ( select c_hours_required BIV_MEASURE1, '||
193: ' c_hours_charged BIV_MEASURE2, ' ||
194: isc_maint_rpt_util_pkg.change_column('c_hours_required','c_hours_charged','BIV_MEASURE3','X') ||
195: ', c_hours_required_total BIV_MEASURE4 , c_hours_charged_total BIV_MEASURE5 ,' ||
196: isc_maint_rpt_util_pkg.change_column('c_hours_required_total','c_hours_charged_total','BIV_MEASURE6','X')
197: ||l_drill_across ||','
198: ||isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
199:
200: l_stmt := l_stmt || l_inner_query;

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

194: isc_maint_rpt_util_pkg.change_column('c_hours_required','c_hours_charged','BIV_MEASURE3','X') ||
195: ', c_hours_required_total BIV_MEASURE4 , c_hours_charged_total BIV_MEASURE5 ,' ||
196: isc_maint_rpt_util_pkg.change_column('c_hours_required_total','c_hours_charged_total','BIV_MEASURE6','X')
197: ||l_drill_across ||','
198: ||isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
199:
200: l_stmt := l_stmt || l_inner_query;
201: l_stmt := l_stmt || poa_dbi_template_pkg.status_sql
202: ( p_fact_name => l_mv

Line 227: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;

223: , x_custom_sql out nocopy varchar2
224: , x_custom_output out nocopy bis_query_attributes_tbl
225: )
226: is
227: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
228: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
229: l_dim_bmap number;
230: l_comparison_type varchar2(200);
231: l_xtd varchar2(200);

Line 243: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;

239: l_custom_output bis_query_attributes_tbl;
240: l_rank_order varchar2(100);
241: l_cost_element varchar2(200);
242: l_curr_suffix varchar2(2);
243: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
244: l_viewby_select varchar2(200);
245:
246: BEGIN
247:

Line 251: isc_maint_rpt_util_pkg.register_dimension_levels

247:
248: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
249: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
250:
251: isc_maint_rpt_util_pkg.register_dimension_levels
252: ( l_dimension_tbl
253: , l_dim_filter_map
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'
255: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'

Line 254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'

250:
251: isc_maint_rpt_util_pkg.register_dimension_levels
252: ( l_dimension_tbl
253: , l_dim_filter_map
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'
255: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
256: );
257:
258:

Line 255: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'

251: isc_maint_rpt_util_pkg.register_dimension_levels
252: ( l_dimension_tbl
253: , l_dim_filter_map
254: , isc_maint_rpt_util_pkg.G_WORK_ORDER_STATUS, 'Y'
255: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
256: );
257:
258:
259: isc_maint_rpt_util_pkg.process_parameters

Line 259: isc_maint_rpt_util_pkg.process_parameters

255: , isc_maint_rpt_util_pkg.G_RESOURCE, 'Y'
256: );
257:
258:
259: isc_maint_rpt_util_pkg.process_parameters
260: ( p_param => p_param
261: , p_dimension_tbl => l_dimension_tbl
262: , p_dim_filter_map => l_dim_filter_map
263: , p_trend => 'D'

Line 280: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value

276: , p_param
277: , l_dim_bmap
278: , l_custom_output
279: );
280: l_order_by := isc_maint_rpt_util_pkg.get_parameter_value
281: ( p_param
282: , 'ORDERBY'
283: );
284:

Line 310: isc_maint_rpt_util_pkg.add_detail_column

306: 'hours_backlog'
307: end || l_asc_desc||',work_order_id,operation_seq_number,department_id,resource_id,rowid';
308:
309:
310: isc_maint_rpt_util_pkg.add_detail_column
311: ( p_detail_col_tbl => l_detail_col_tbl
312: , p_dimension_tbl => l_dimension_tbl
313: , p_dimension_level => isc_maint_rpt_util_pkg.G_RESOURCE
314: , p_column_key => 'resource_id'

Line 313: , p_dimension_level => isc_maint_rpt_util_pkg.G_RESOURCE

309:
310: isc_maint_rpt_util_pkg.add_detail_column
311: ( p_detail_col_tbl => l_detail_col_tbl
312: , p_dimension_tbl => l_dimension_tbl
313: , p_dimension_level => isc_maint_rpt_util_pkg.G_RESOURCE
314: , p_column_key => 'resource_id'
315: );
316:
317: isc_maint_rpt_util_pkg.add_detail_column

Line 317: isc_maint_rpt_util_pkg.add_detail_column

313: , p_dimension_level => isc_maint_rpt_util_pkg.G_RESOURCE
314: , p_column_key => 'resource_id'
315: );
316:
317: isc_maint_rpt_util_pkg.add_detail_column
318: ( p_detail_col_tbl => l_detail_col_tbl
319: , p_dimension_tbl => l_dimension_tbl
320: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
321: , p_column_key => 'department_id'

Line 320: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT

316:
317: isc_maint_rpt_util_pkg.add_detail_column
318: ( p_detail_col_tbl => l_detail_col_tbl
319: , p_dimension_tbl => l_dimension_tbl
320: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
321: , p_column_key => 'department_id'
322: );
323:
324: isc_maint_rpt_util_pkg.add_detail_column

Line 324: isc_maint_rpt_util_pkg.add_detail_column

320: , p_dimension_level => isc_maint_rpt_util_pkg.G_DEPARTMENT
321: , p_column_key => 'department_id'
322: );
323:
324: isc_maint_rpt_util_pkg.add_detail_column
325: ( p_detail_col_tbl => l_detail_col_tbl
326: , p_dimension_tbl => l_dimension_tbl
327: , p_fact_col_name => 'OP_START_DATE'
328: , p_fact_col_total => 'N'

Line 332: isc_maint_rpt_util_pkg.add_detail_column

328: , p_fact_col_total => 'N'
329: , p_column_key => 'OP_START_DATE'
330: );
331:
332: isc_maint_rpt_util_pkg.add_detail_column
333: ( p_detail_col_tbl => l_detail_col_tbl
334: , p_dimension_tbl => l_dimension_tbl
335: , p_fact_col_name => 'OP_END_DATE'
336: , p_fact_col_total => 'N'

Line 341: isc_maint_rpt_util_pkg.add_detail_column

337: , p_column_key => 'OP_END_DATE'
338: );
339:
340:
341: isc_maint_rpt_util_pkg.add_detail_column
342: ( p_detail_col_tbl => l_detail_col_tbl
343: , p_dimension_tbl => l_dimension_tbl
344: , p_fact_col_name => 'WORK_ORDER_NAME'
345: , p_fact_col_total => 'N'

Line 349: isc_maint_rpt_util_pkg.add_detail_column

345: , p_fact_col_total => 'N'
346: , p_column_key => 'WORK_ORDER_NAME'
347: );
348:
349: isc_maint_rpt_util_pkg.add_detail_column
350: ( p_detail_col_tbl => l_detail_col_tbl
351: , p_dimension_tbl => l_dimension_tbl
352: , p_fact_col_name => 'WORK_ORDER_ID'
353: , p_fact_col_total => 'N'

Line 357: isc_maint_rpt_util_pkg.add_detail_column

353: , p_fact_col_total => 'N'
354: , p_column_key => 'WORK_ORDER_ID'
355: );
356:
357: isc_maint_rpt_util_pkg.add_detail_column
358: ( p_detail_col_tbl => l_detail_col_tbl
359: , p_dimension_tbl => l_dimension_tbl
360: , p_fact_col_name => 'OPERATION_SEQ_NUMBER'
361: , p_fact_col_total => 'N'

Line 367: isc_maint_rpt_util_pkg.add_detail_column

363: );
364:
365:
366:
367: isc_maint_rpt_util_pkg.add_detail_column
368: ( p_detail_col_tbl => l_detail_col_tbl
369: , p_dimension_tbl => l_dimension_tbl
370: , p_fact_col_name => 'hours_required'
371: , p_fact_col_total => 'Y'

Line 375: isc_maint_rpt_util_pkg.add_detail_column

371: , p_fact_col_total => 'Y'
372: , p_column_key => 'hours_required'
373: );
374:
375: isc_maint_rpt_util_pkg.add_detail_column
376: ( p_detail_col_tbl => l_detail_col_tbl
377: , p_dimension_tbl => l_dimension_tbl
378: , p_fact_col_name => 'hours_charged'
379: , p_fact_col_total => 'Y'

Line 383: isc_maint_rpt_util_pkg.add_detail_column

379: , p_fact_col_total => 'Y'
380: , p_column_key => 'hours_charged'
381: );
382:
383: isc_maint_rpt_util_pkg.add_detail_column
384: ( p_detail_col_tbl => l_detail_col_tbl
385: , p_dimension_tbl => l_dimension_tbl
386: , p_fact_col_name => 'hours_backlog'
387: , p_fact_col_total => 'Y'

Line 394: ' || isc_maint_rpt_util_pkg.get_detail_column

390:
391:
392:
393: l_stmt := 'select
394: ' || isc_maint_rpt_util_pkg.get_detail_column
395: (l_detail_col_tbl,'resource_id','BIV_MEASURE1') || '
396: , ' || isc_maint_rpt_util_pkg.get_detail_column
397: (l_detail_col_tbl,'department_id','BIV_MEASURE2') || '
398: , oset.WORK_ORDER_NAME BIV_MEASURE3

Line 396: , ' || isc_maint_rpt_util_pkg.get_detail_column

392:
393: l_stmt := 'select
394: ' || isc_maint_rpt_util_pkg.get_detail_column
395: (l_detail_col_tbl,'resource_id','BIV_MEASURE1') || '
396: , ' || isc_maint_rpt_util_pkg.get_detail_column
397: (l_detail_col_tbl,'department_id','BIV_MEASURE2') || '
398: , oset.WORK_ORDER_NAME BIV_MEASURE3
399: , oset.OPERATION_SEQ_NUMBER BIV_MEASURE4
400: , oset.OP_START_DATE BIV_MEASURE5

Line 407: isc_maint_rpt_util_pkg.change_column('oset.hours_required_total','oset.hours_charged_total'

403: , oset.hours_charged BIV_MEASURE8
404: , oset.hours_backlog BIV_MEASURE9
405: , oset.hours_required_total BIV_MEASURE10
406: , oset.hours_charged_total BIV_MEASURE11 , '||
407: isc_maint_rpt_util_pkg.change_column('oset.hours_required_total','oset.hours_charged_total'
408: ,'BIV_MEASURE12','X') ||' , ' ||
409: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE1') ||
410: ' from
411: ' || isc_maint_rpt_util_pkg.detail_sql

Line 409: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE1') ||

405: , oset.hours_required_total BIV_MEASURE10
406: , oset.hours_charged_total BIV_MEASURE11 , '||
407: isc_maint_rpt_util_pkg.change_column('oset.hours_required_total','oset.hours_charged_total'
408: ,'BIV_MEASURE12','X') ||' , ' ||
409: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE1') ||
410: ' from
411: ' || isc_maint_rpt_util_pkg.detail_sql
412: ( p_detail_col_tbl => l_detail_col_tbl
413: , p_dimension_tbl => l_dimension_tbl

Line 411: ' || isc_maint_rpt_util_pkg.detail_sql

407: isc_maint_rpt_util_pkg.change_column('oset.hours_required_total','oset.hours_charged_total'
408: ,'BIV_MEASURE12','X') ||' , ' ||
409: isc_maint_rpt_util_pkg.get_drill_detail('BIV_ATTRIBUTE1') ||
410: ' from
411: ' || isc_maint_rpt_util_pkg.detail_sql
412: ( p_detail_col_tbl => l_detail_col_tbl
413: , p_dimension_tbl => l_dimension_tbl
414: , p_mv_name => l_mv
415: , p_where_clause => l_where_clause