APPS.OKI_DBI_SRM_PRNWL_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 212: ' || poa_dbi_template_pkg.union_all_status_sql

208:
209: l_query := get_table_sel_clause (l_view_by, l_view_by_col) -- in poa : l_join_tbl
210:
211: || ' from (
212: ' || poa_dbi_template_pkg.union_all_status_sql
213: (p_mv => l_mv_tbl,
214: p_join_tables => l_join_tbl,
215: p_use_windowing => 'Y',
216: p_paren_count => 7,

Line 766: || poa_dbi_template_pkg.dtl_status_sql2 (

762: l_additional_mv := ' ) fact
763: , OKI_SCM_OCR_MV k
764: WHERE fact.chr_id = k.chr_id) ';
765: l_query := get_bookings_sel_clause (l_curr_suffix, l_period_type )
766: || poa_dbi_template_pkg.dtl_status_sql2 (
767: p_fact_name => l_mv
768: , p_where_clause => l_where_clause || l_rpt_specific_where
769: , p_join_tables => l_join_tbl
770: , p_use_windowing => 'Y'

Line 1293: ||poa_dbi_template_pkg.union_all_trend_sql

1289:
1290: l_query :=
1291: get_trend_sel_clause
1292: || ' from '
1293: ||poa_dbi_template_pkg.union_all_trend_sql
1294: (p_mv => l_mv_tbl,
1295: p_comparison_type => 'R',
1296: p_filter_where => NULL);
1297: