DBA Data[Home] [Help]

APPS.ISC_MAINT_WO_CST_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 527: poa_dbi_template_pkg.status_sql

523: ''&pParamIds=Y'' BIV_ATTRIBUTE1,'||
524: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
525:
526: l_stmt := l_stmt || l_inner_query ||
527: poa_dbi_template_pkg.status_sql
528: ( p_fact_name => l_mv
529: , p_where_clause => l_where_clause
530: , p_join_tables => l_join_tbl
531: , p_use_windowing => 'N'

Line 697: ' || poa_dbi_template_pkg.trend_sql

693: , 'Y' )
694: , 'BIV_MEASURE12'
695: , 'N' ) || '
696: from
697: ' || poa_dbi_template_pkg.trend_sql
698: ( p_xtd => l_xtd
699: , p_comparison_type => l_comparison_type
700: , p_fact_name => l_mv
701: , p_where_clause => l_where_clause

Line 993: l_stmt := l_stmt || l_inner_query || poa_dbi_template_pkg.status_sql

989: else '
990: , null BIV_ATTRIBUTE5'
991: end || ', ' ||
992: isc_maint_rpt_util_pkg.get_inner_select_col(l_join_tbl)||' from ';
993: l_stmt := l_stmt || l_inner_query || poa_dbi_template_pkg.status_sql
994: ( p_fact_name => l_mv
995: , p_where_clause => l_where_clause
996: , p_join_tables => l_join_tbl
997: , p_use_windowing => 'Y'