APPS.ISC_MAINT_ASSET_DT_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 242: l_stmt := l_stmt || poa_dbi_template_pkg.status_sql

238:
239:
240:
241: l_stmt := l_stmt || l_inner_query;
242: l_stmt := l_stmt || poa_dbi_template_pkg.status_sql
243: ( p_fact_name => l_mv
244: , p_where_clause => l_where_clause
245: , p_join_tables => l_join_tbl
246: , p_use_windowing => 'Y'

Line 525: poa_dbi_template_pkg.trend_sql

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
527: , p_comparison_type => l_comparison_type
528: , p_fact_name => l_mv
529: , p_where_clause => l_where_clause