eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_MAINT_WO_CMPL_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 222: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

218: )
219: is
220:
221: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
222: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
223: l_dim_bmap number;
224: l_comparison_type varchar2(200);
225: l_xtd varchar2(200);
226: l_where_clause varchar2(10000);

Line 230: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

226: l_where_clause varchar2(10000);
227: l_mv varchar2(10000);
228: l_stmt varchar2(32767);
229:
230: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
231: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
232:
233: l_custom_output bis_query_attributes_tbl;
234:

Line 231: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

227: l_mv varchar2(10000);
228: l_stmt varchar2(32767);
229:
230: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
231: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
232:
233: l_custom_output bis_query_attributes_tbl;
234:
235: l_cost_element varchar2(200);

Line 245: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

241:
242: begin
243:
244: -- clear out the tables.
245: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
246: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
247:
248: isc_maint_rpt_util_pkg.register_dimension_levels
249: ( l_dimension_tbl

Line 246: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

242: begin
243:
244: -- clear out the tables.
245: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
246: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
247:
248: isc_maint_rpt_util_pkg.register_dimension_levels
249: ( l_dimension_tbl
250: , l_dim_filter_map

Line 282: poa_dbi_util_pkg.add_column (l_col_tbl,

278:
279: -- The measure columns that need to be aggregated are
280: -- completed_wo, on_time_cmp_wo, late_cmp_wo
281:
282: poa_dbi_util_pkg.add_column (l_col_tbl,
283: 'num_completion',
284: 'num_completion');
285:
286: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 286: poa_dbi_util_pkg.add_column (l_col_tbl,

282: poa_dbi_util_pkg.add_column (l_col_tbl,
283: 'num_completion',
284: 'num_completion');
285:
286: poa_dbi_util_pkg.add_column (l_col_tbl,
287: 'num_late_completion',
288: 'num_late_completion');
289: poa_dbi_util_pkg.add_column (l_col_tbl,
290: 'days_late',

Line 289: poa_dbi_util_pkg.add_column (l_col_tbl,

285:
286: poa_dbi_util_pkg.add_column (l_col_tbl,
287: 'num_late_completion',
288: 'num_late_completion');
289: poa_dbi_util_pkg.add_column (l_col_tbl,
290: 'days_late',
291: 'days_late');
292:
293: /* if view by is asset number add asset_group column */

Line 525: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

521: )
522: is
523:
524: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
525: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
526: l_dim_bmap number;
527: l_comparison_type varchar2(200);
528: l_xtd varchar2(200);
529: l_where_clause varchar2(10000);

Line 533: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

529: l_where_clause varchar2(10000);
530: l_mv varchar2(10000);
531: l_stmt varchar2(32767);
532:
533: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
534: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
535:
536: l_custom_output bis_query_attributes_tbl;
537:

Line 534: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

530: l_mv varchar2(10000);
531: l_stmt varchar2(32767);
532:
533: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
534: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
535:
536: l_custom_output bis_query_attributes_tbl;
537:
538: l_cost_element varchar2(200);

Line 546: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

542:
543: begin
544:
545: -- clear out the tables.
546: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
547: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
548:
549: isc_maint_rpt_util_pkg.register_dimension_levels
550: ( l_dimension_tbl

Line 547: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

543: begin
544:
545: -- clear out the tables.
546: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
547: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
548:
549: isc_maint_rpt_util_pkg.register_dimension_levels
550: ( l_dimension_tbl
551: , l_dim_filter_map

Line 584: poa_dbi_util_pkg.add_column (l_col_tbl,

580: -- The measure columns that need to be aggregated are
581: -- completed_wo, on_time_cmp_wo, late_cmp_wo
582: -- No Grand totals required.
583:
584: poa_dbi_util_pkg.add_column (l_col_tbl,
585: 'num_completion',
586: 'num_completion',
587: 'N');
588:

Line 589: poa_dbi_util_pkg.add_column (l_col_tbl,

585: 'num_completion',
586: 'num_completion',
587: 'N');
588:
589: poa_dbi_util_pkg.add_column (l_col_tbl,
590: 'num_late_completion',
591: 'num_late_completion',
592: 'N');
593: poa_dbi_util_pkg.add_column (l_col_tbl,

Line 593: poa_dbi_util_pkg.add_column (l_col_tbl,

589: poa_dbi_util_pkg.add_column (l_col_tbl,
590: 'num_late_completion',
591: 'num_late_completion',
592: 'N');
593: poa_dbi_util_pkg.add_column (l_col_tbl,
594: 'days_late',
595: 'days_late',
596: 'N');
597:

Line 694: poa_dbi_util_pkg.get_custom_trend_binds

690: x_custom_sql := l_stmt;
691:
692: x_custom_output := l_custom_output;
693:
694: poa_dbi_util_pkg.get_custom_trend_binds
695: ( x_custom_output => l_custom_output
696: , p_xtd => l_xtd
697: , p_comparison_type => l_comparison_type
698: );

Line 719: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

715: )
716: is
717:
718: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
719: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
720: l_dim_bmap number;
721:
722: l_comparison_type varchar2(200);
723: l_xtd varchar2(200);

Line 728: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

724: l_where_clause varchar2(10000);
725: l_mv varchar2(10000);
726: l_stmt varchar2(32767);
727:
728: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
729: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
730:
731: l_custom_output bis_query_attributes_tbl;
732:

Line 729: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

725: l_mv varchar2(10000);
726: l_stmt varchar2(32767);
727:
728: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
729: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
730:
731: l_custom_output bis_query_attributes_tbl;
732:
733: l_cost_element varchar2(200);

Line 743: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

739:
740: begin
741:
742: -- clear out the tables.
743: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
744: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
745:
746: isc_maint_rpt_util_pkg.register_dimension_levels
747: ( l_dimension_tbl

Line 744: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

740: begin
741:
742: -- clear out the tables.
743: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
744: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
745:
746: isc_maint_rpt_util_pkg.register_dimension_levels
747: ( l_dimension_tbl
748: , l_dim_filter_map

Line 781: poa_dbi_util_pkg.add_column (l_col_tbl,

777:
778: -- The measure columns that need to be aggregated are
779: -- late_comp_wo
780:
781: poa_dbi_util_pkg.add_column (l_col_tbl,
782: 'num_count',
783: 'num_count');
784:
785: l_stmt := 'select

Line 854: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

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

Line 862: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

858: l_where_clause varchar2(10000);
859: l_mv varchar2(10000);
860: l_stmt varchar2(32767);
861:
862: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
863: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
864:
865: l_custom_output bis_query_attributes_tbl;
866:

Line 863: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

859: l_mv varchar2(10000);
860: l_stmt varchar2(32767);
861:
862: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
863: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
864:
865: l_custom_output bis_query_attributes_tbl;
866:
867: l_curr_suffix varchar2(2);

Line 880: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

876:
877: BEGIN
878:
879: -- clear out the tables.
880: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
881: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
882:
883: isc_maint_rpt_util_pkg.register_dimension_levels
884: ( l_dimension_tbl

Line 881: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

877: BEGIN
878:
879: -- clear out the tables.
880: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
881: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
882:
883: isc_maint_rpt_util_pkg.register_dimension_levels
884: ( l_dimension_tbl
885: , l_dim_filter_map

Line 1068: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

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

Line 1077: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1073: l_where_clause varchar2(10000);
1074: l_mv varchar2(10000);
1075: l_stmt varchar2(32767);
1076:
1077: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1078: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1079:
1080: l_custom_output bis_query_attributes_tbl;
1081:

Line 1078: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1074: l_mv varchar2(10000);
1075: l_stmt varchar2(32767);
1076:
1077: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1078: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1079:
1080: l_custom_output bis_query_attributes_tbl;
1081:
1082: l_curr_suffix varchar2(2);

Line 1095: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

1091:
1092: BEGIN
1093:
1094: -- clear out the tables.
1095: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1096: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1097:
1098: isc_maint_rpt_util_pkg.register_dimension_levels
1099: ( l_dimension_tbl

Line 1096: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();

1092: BEGIN
1093:
1094: -- clear out the tables.
1095: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
1096: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
1097:
1098: isc_maint_rpt_util_pkg.register_dimension_levels
1099: ( l_dimension_tbl
1100: , l_dim_filter_map