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.

[Home] [Help]

APPS.ISC_MAINT_WO_CST_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 287: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

283: )
284: is
285:
286: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
287: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
288: l_custom_output bis_query_attributes_tbl;
289: l_curr_suffix varchar2(3);
290: l_where_clause varchar2(10000);
291: l_viewby_select varchar2(200);

Line 292: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

288: l_custom_output bis_query_attributes_tbl;
289: l_curr_suffix varchar2(3);
290: l_where_clause varchar2(10000);
291: l_viewby_select varchar2(200);
292: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
293: l_dim_bmap number;
294: l_comparison_type varchar2(200);
295: l_xtd varchar2(200);
296: l_mv varchar2(10000);

Line 299: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

295: l_xtd varchar2(200);
296: l_mv varchar2(10000);
297: l_cost_element varchar2(200);
298: l_estimated varchar2(200);
299: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
300: l_stmt varchar2(32767);
301: l_asset_grp_column varchar2(200);
302: l_inner_query varchar2(5000);
303: begin

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

353: else
354: l_cost_element := 'tot';
355: end if;
356:
357: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
358:
359: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
360: , p_col_name => 'estimated_' || l_cost_element || '_cost_' || l_curr_suffix
361: , p_alias_name => 'estimated_cost'

Line 359: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

355: end if;
356:
357: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
358:
359: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
360: , p_col_name => 'estimated_' || l_cost_element || '_cost_' || l_curr_suffix
361: , p_alias_name => 'estimated_cost'
362: , p_to_date_type => 'XTD'
363: );

Line 365: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

361: , p_alias_name => 'estimated_cost'
362: , p_to_date_type => 'XTD'
363: );
364:
365: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
366: , p_col_name => 'actual_' || l_cost_element || '_cost_' || l_curr_suffix
367: , p_alias_name => 'actual_cost'
368: , p_to_date_type => 'XTD'
369: );

Line 371: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

367: , p_alias_name => 'actual_cost'
368: , p_to_date_type => 'XTD'
369: );
370:
371: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
372: , p_col_name => 'variance_' || l_cost_element || '_cost_' || l_curr_suffix
373: , p_alias_name => 'variance_cost'
374: , p_to_date_type => 'XTD'
375: );

Line 557: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

553: )
554: is
555:
556: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
557: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
558: l_custom_output bis_query_attributes_tbl;
559: l_curr_suffix varchar2(3);
560: l_where_clause varchar2(10000);
561: l_viewby_select varchar2(200);

Line 562: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

558: l_custom_output bis_query_attributes_tbl;
559: l_curr_suffix varchar2(3);
560: l_where_clause varchar2(10000);
561: l_viewby_select varchar2(200);
562: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
563: l_dim_bmap number;
564: l_comparison_type varchar2(200);
565: l_xtd varchar2(200);
566: l_mv varchar2(10000);

Line 569: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

565: l_xtd varchar2(200);
566: l_mv varchar2(10000);
567: l_cost_element varchar2(200);
568: l_estimated varchar2(200);
569: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
570: l_stmt varchar2(32767);
571:
572: begin
573:

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

620: else
621: l_cost_element := 'tot';
622: end if;
623:
624: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
625:
626: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
627: , p_col_name => 'estimated_' || l_cost_element || '_cost_' || l_curr_suffix
628: , p_alias_name => 'estimated_cost'

Line 626: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

622: end if;
623:
624: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
625:
626: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
627: , p_col_name => 'estimated_' || l_cost_element || '_cost_' || l_curr_suffix
628: , p_alias_name => 'estimated_cost'
629: , p_to_date_type => 'XTD'
630: , p_grand_total => 'N'

Line 633: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

629: , p_to_date_type => 'XTD'
630: , p_grand_total => 'N'
631: );
632:
633: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
634: , p_col_name => 'actual_' || l_cost_element || '_cost_' || l_curr_suffix
635: , p_alias_name => 'actual_cost'
636: , p_to_date_type => 'XTD'
637: , p_grand_total => 'N'

Line 640: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

636: , p_to_date_type => 'XTD'
637: , p_grand_total => 'N'
638: );
639:
640: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
641: , p_col_name => 'variance_' || l_cost_element || '_cost_' || l_curr_suffix
642: , p_alias_name => 'variance_cost'
643: , p_to_date_type => 'XTD'
644: , p_grand_total => 'N'

Line 713: poa_dbi_util_pkg.get_custom_trend_binds

709: x_custom_sql := l_stmt;
710:
711: x_custom_output := l_custom_output;
712:
713: poa_dbi_util_pkg.get_custom_trend_binds
714: ( x_custom_output => l_custom_output
715: , p_xtd => l_xtd
716: , p_comparison_type => l_comparison_type
717: );

Line 736: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

732: )
733: as
734:
735: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
736: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
737: l_custom_output bis_query_attributes_tbl;
738: l_curr_suffix varchar2(3);
739: l_where_clause varchar2(10000);
740: l_viewby_select varchar2(200);

Line 741: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

737: l_custom_output bis_query_attributes_tbl;
738: l_curr_suffix varchar2(3);
739: l_where_clause varchar2(10000);
740: l_viewby_select varchar2(200);
741: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
742: l_dim_bmap number;
743: l_comparison_type varchar2(200);
744: l_xtd varchar2(200);
745: l_mv varchar2(10000);

Line 748: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

744: l_xtd varchar2(200);
745: l_mv varchar2(10000);
746: l_cost_element varchar2(200);
747: l_estimated varchar2(200);
748: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
749: l_stmt varchar2(32767);
750: l_inner_query varchar2(5000);
751: l_asset_grp_column varchar2(200);
752: begin

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

787: , l_custom_output
788: , l_estimated
789: );
790:
791: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
792:
793: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
794: , p_col_name => 'estimated_mat_cost_' || l_curr_suffix
795: , p_alias_name => 'estimated_mat_cost'

Line 793: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

789: );
790:
791: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
792:
793: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
794: , p_col_name => 'estimated_mat_cost_' || l_curr_suffix
795: , p_alias_name => 'estimated_mat_cost'
796: , p_to_date_type => 'XTD'
797: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 797: , p_prior_code => poa_dbi_util_pkg.no_priors

793: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
794: , p_col_name => 'estimated_mat_cost_' || l_curr_suffix
795: , p_alias_name => 'estimated_mat_cost'
796: , p_to_date_type => 'XTD'
797: , p_prior_code => poa_dbi_util_pkg.no_priors
798: );
799:
800: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
801: , p_col_name => 'actual_mat_cost_' || l_curr_suffix

Line 800: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

796: , p_to_date_type => 'XTD'
797: , p_prior_code => poa_dbi_util_pkg.no_priors
798: );
799:
800: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
801: , p_col_name => 'actual_mat_cost_' || l_curr_suffix
802: , p_alias_name => 'actual_mat_cost'
803: , p_to_date_type => 'XTD'
804: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 804: , p_prior_code => poa_dbi_util_pkg.no_priors

800: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
801: , p_col_name => 'actual_mat_cost_' || l_curr_suffix
802: , p_alias_name => 'actual_mat_cost'
803: , p_to_date_type => 'XTD'
804: , p_prior_code => poa_dbi_util_pkg.no_priors
805: );
806:
807: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
808: , p_col_name => 'variance_mat_cost_' || l_curr_suffix

Line 807: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

803: , p_to_date_type => 'XTD'
804: , p_prior_code => poa_dbi_util_pkg.no_priors
805: );
806:
807: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
808: , p_col_name => 'variance_mat_cost_' || l_curr_suffix
809: , p_alias_name => 'variance_mat_cost'
810: , p_to_date_type => 'XTD'
811: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 811: , p_prior_code => poa_dbi_util_pkg.no_priors

807: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
808: , p_col_name => 'variance_mat_cost_' || l_curr_suffix
809: , p_alias_name => 'variance_mat_cost'
810: , p_to_date_type => 'XTD'
811: , p_prior_code => poa_dbi_util_pkg.no_priors
812: );
813:
814: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
815: , p_col_name => 'estimated_lab_cost_' || l_curr_suffix

Line 814: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

810: , p_to_date_type => 'XTD'
811: , p_prior_code => poa_dbi_util_pkg.no_priors
812: );
813:
814: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
815: , p_col_name => 'estimated_lab_cost_' || l_curr_suffix
816: , p_alias_name => 'estimated_lab_cost'
817: , p_to_date_type => 'XTD'
818: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 818: , p_prior_code => poa_dbi_util_pkg.no_priors

814: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
815: , p_col_name => 'estimated_lab_cost_' || l_curr_suffix
816: , p_alias_name => 'estimated_lab_cost'
817: , p_to_date_type => 'XTD'
818: , p_prior_code => poa_dbi_util_pkg.no_priors
819: );
820:
821: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
822: , p_col_name => 'actual_lab_cost_' || l_curr_suffix

Line 821: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

817: , p_to_date_type => 'XTD'
818: , p_prior_code => poa_dbi_util_pkg.no_priors
819: );
820:
821: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
822: , p_col_name => 'actual_lab_cost_' || l_curr_suffix
823: , p_alias_name => 'actual_lab_cost'
824: , p_to_date_type => 'XTD'
825: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 825: , p_prior_code => poa_dbi_util_pkg.no_priors

821: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
822: , p_col_name => 'actual_lab_cost_' || l_curr_suffix
823: , p_alias_name => 'actual_lab_cost'
824: , p_to_date_type => 'XTD'
825: , p_prior_code => poa_dbi_util_pkg.no_priors
826: );
827:
828: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
829: , p_col_name => 'variance_lab_cost_' || l_curr_suffix

Line 828: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

824: , p_to_date_type => 'XTD'
825: , p_prior_code => poa_dbi_util_pkg.no_priors
826: );
827:
828: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
829: , p_col_name => 'variance_lab_cost_' || l_curr_suffix
830: , p_alias_name => 'variance_lab_cost'
831: , p_to_date_type => 'XTD'
832: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 832: , p_prior_code => poa_dbi_util_pkg.no_priors

828: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
829: , p_col_name => 'variance_lab_cost_' || l_curr_suffix
830: , p_alias_name => 'variance_lab_cost'
831: , p_to_date_type => 'XTD'
832: , p_prior_code => poa_dbi_util_pkg.no_priors
833: );
834:
835: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
836: , p_col_name => 'estimated_eqp_cost_' || l_curr_suffix

Line 835: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

831: , p_to_date_type => 'XTD'
832: , p_prior_code => poa_dbi_util_pkg.no_priors
833: );
834:
835: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
836: , p_col_name => 'estimated_eqp_cost_' || l_curr_suffix
837: , p_alias_name => 'estimated_eqp_cost'
838: , p_to_date_type => 'XTD'
839: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 839: , p_prior_code => poa_dbi_util_pkg.no_priors

835: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
836: , p_col_name => 'estimated_eqp_cost_' || l_curr_suffix
837: , p_alias_name => 'estimated_eqp_cost'
838: , p_to_date_type => 'XTD'
839: , p_prior_code => poa_dbi_util_pkg.no_priors
840: );
841:
842: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
843: , p_col_name => 'actual_eqp_cost_' || l_curr_suffix

Line 842: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

838: , p_to_date_type => 'XTD'
839: , p_prior_code => poa_dbi_util_pkg.no_priors
840: );
841:
842: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
843: , p_col_name => 'actual_eqp_cost_' || l_curr_suffix
844: , p_alias_name => 'actual_eqp_cost'
845: , p_to_date_type => 'XTD'
846: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 846: , p_prior_code => poa_dbi_util_pkg.no_priors

842: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
843: , p_col_name => 'actual_eqp_cost_' || l_curr_suffix
844: , p_alias_name => 'actual_eqp_cost'
845: , p_to_date_type => 'XTD'
846: , p_prior_code => poa_dbi_util_pkg.no_priors
847: );
848:
849: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
850: , p_col_name => 'variance_eqp_cost_' || l_curr_suffix

Line 849: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

845: , p_to_date_type => 'XTD'
846: , p_prior_code => poa_dbi_util_pkg.no_priors
847: );
848:
849: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
850: , p_col_name => 'variance_eqp_cost_' || l_curr_suffix
851: , p_alias_name => 'variance_eqp_cost'
852: , p_to_date_type => 'XTD'
853: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 853: , p_prior_code => poa_dbi_util_pkg.no_priors

849: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
850: , p_col_name => 'variance_eqp_cost_' || l_curr_suffix
851: , p_alias_name => 'variance_eqp_cost'
852: , p_to_date_type => 'XTD'
853: , p_prior_code => poa_dbi_util_pkg.no_priors
854: );
855:
856: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
857: , p_col_name => 'estimated_tot_cost_' || l_curr_suffix

Line 856: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

852: , p_to_date_type => 'XTD'
853: , p_prior_code => poa_dbi_util_pkg.no_priors
854: );
855:
856: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
857: , p_col_name => 'estimated_tot_cost_' || l_curr_suffix
858: , p_alias_name => 'estimated_tot_cost'
859: , p_to_date_type => 'XTD'
860: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 860: , p_prior_code => poa_dbi_util_pkg.no_priors

856: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
857: , p_col_name => 'estimated_tot_cost_' || l_curr_suffix
858: , p_alias_name => 'estimated_tot_cost'
859: , p_to_date_type => 'XTD'
860: , p_prior_code => poa_dbi_util_pkg.no_priors
861: );
862:
863: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
864: , p_col_name => 'actual_tot_cost_' || l_curr_suffix

Line 863: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

859: , p_to_date_type => 'XTD'
860: , p_prior_code => poa_dbi_util_pkg.no_priors
861: );
862:
863: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
864: , p_col_name => 'actual_tot_cost_' || l_curr_suffix
865: , p_alias_name => 'actual_tot_cost'
866: , p_to_date_type => 'XTD'
867: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 867: , p_prior_code => poa_dbi_util_pkg.no_priors

863: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
864: , p_col_name => 'actual_tot_cost_' || l_curr_suffix
865: , p_alias_name => 'actual_tot_cost'
866: , p_to_date_type => 'XTD'
867: , p_prior_code => poa_dbi_util_pkg.no_priors
868: );
869:
870: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
871: , p_col_name => 'variance_tot_cost_' || l_curr_suffix

Line 870: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

866: , p_to_date_type => 'XTD'
867: , p_prior_code => poa_dbi_util_pkg.no_priors
868: );
869:
870: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
871: , p_col_name => 'variance_tot_cost_' || l_curr_suffix
872: , p_alias_name => 'variance_tot_cost'
873: , p_to_date_type => 'XTD'
874: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 874: , p_prior_code => poa_dbi_util_pkg.no_priors

870: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
871: , p_col_name => 'variance_tot_cost_' || l_curr_suffix
872: , p_alias_name => 'variance_tot_cost'
873: , p_to_date_type => 'XTD'
874: , p_prior_code => poa_dbi_util_pkg.no_priors
875: );
876:
877: /* if view by is asset number add the asset_group column */
878: if(isc_maint_rpt_util_pkg.get_parameter_id(p_param,'VIEW_BY')) =

Line 1023: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

1019: )
1020: as
1021:
1022: l_dimension_tbl isc_maint_rpt_util_pkg.t_dimension_tbl;
1023: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
1024: l_custom_output bis_query_attributes_tbl;
1025: l_curr_suffix varchar2(3);
1026: l_where_clause varchar2(10000);
1027: l_viewby_select varchar2(200);

Line 1028: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1024: l_custom_output bis_query_attributes_tbl;
1025: l_curr_suffix varchar2(3);
1026: l_where_clause varchar2(10000);
1027: l_viewby_select varchar2(200);
1028: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1029: l_dim_bmap number;
1030: l_comparison_type varchar2(200);
1031: l_xtd varchar2(200);
1032: l_mv varchar2(10000);

Line 1035: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1031: l_xtd varchar2(200);
1032: l_mv varchar2(10000);
1033: l_cost_element varchar2(200);
1034: l_estimated varchar2(200);
1035: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1036: l_stmt varchar2(32767);
1037: l_rank_order varchar2(200);
1038: l_detail_col_tbl isc_maint_rpt_util_pkg.t_detail_column_tbl;
1039: l_order_by varchar2(200);