APPS.ISC_DEPOT_MTTR_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 108: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,

104: , x_bucket_rec => l_bucket_rec);
105:
106: l_query := GET_MTTR_TBL_SEL_CLAUSE (l_view_by,l_view_by_col,l_bucket_rec)
107: || ' from
108: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
109: p_where_clause => l_where_clause,
110: p_join_tables => l_join_tbl,
111: p_use_windowing => 'Y',
112: p_col_name => l_col_tbl,

Line 423: ' || poa_dbi_template_pkg.trend_sql(p_xtd => l_xtd,

419:
420:
421: l_query := GET_MTTR_TRD_SEL_CLAUSE (l_view_by,l_bucket_rec)
422: || ' from
423: ' || poa_dbi_template_pkg.trend_sql(p_xtd => l_xtd,
424: p_comparison_type => l_comparison_type,
425: p_fact_name => l_mv,
426: p_where_clause => l_where_clause,
427: p_col_name => l_col_tbl,

Line 736: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,

732: );
733:
734: l_query := GET_MTTR_DIST_TBL_SEL_CLAUSE (l_view_by,l_view_by_col,l_bucket_rec)
735: || ' from
736: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
737: p_where_clause => l_where_clause,
738: p_join_tables => l_join_tbl,
739: p_use_windowing => 'Y',
740: p_col_name => l_col_tbl,

Line 990: ' || poa_dbi_template_pkg.trend_sql(p_xtd => l_xtd,

986: );
987:
988: l_query := GET_MTTR_DIST_TRD_SEL_CLAUSE (l_view_by,l_bucket_rec)
989: || ' from
990: ' || poa_dbi_template_pkg.trend_sql(p_xtd => l_xtd,
991: p_comparison_type => l_comparison_type,
992: p_fact_name => l_mv,
993: p_where_clause => l_where_clause,
994: p_col_name => l_col_tbl,

Line 1138: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,

1134:
1135:
1136: l_query := GET_SRVC_TBL_SEL_CLAUSE(l_view_by,l_view_by_col)
1137: || ' from
1138: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv,
1139: p_where_clause => l_where_clause,
1140: p_join_tables => l_join_tbl,
1141: p_use_windowing => 'Y',
1142: p_col_name => l_col_tbl,