DBA Data[Home] [Help]

APPS.ISC_FS_MTTR_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 499: from ' || poa_dbi_template_pkg.status_sql

495: , p_prefix => 'nvl(c_'
496: , p_suffix => ',0)/abs(decode(c_count_total,0,null,c_count_total))*100'
497: , p_total_flag => 'Y'
498: ) || '
499: from ' || poa_dbi_template_pkg.status_sql
500: ( p_fact_name => l_mv
501: , p_where_clause => l_where_clause
502: , p_join_tables => l_join_tbl
503: , p_use_windowing => 'Y' --'N'

Line 647: ' || poa_dbi_template_pkg.trend_sql

643: , 'ISC_ATTRIBUTE_2'
644: , 'ISC_ATTRIBUTE_3'
645: ) || '
646: from
647: ' || poa_dbi_template_pkg.trend_sql
648: ( p_xtd => l_xtd
649: , p_comparison_type => l_comparison_type
650: , p_fact_name => l_mv
651: , p_where_clause => l_where_clause