APPS.OKI_DBI_SRM_PDUE_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 305: poa_dbi_template_pkg.union_all_status_sql

301: /* Additional filter needed to avoid displaying records queried due to total values at node */
302: l_filter_where := ' ( ABS(oki_measure_1) + ABS(oki_measure_2) ) <> 0';
303:
304: l_sql :=
305: poa_dbi_template_pkg.union_all_status_sql
306: (p_mv => l_mv_tbl,
307: p_join_tables => l_join_tbl,
308: p_use_windowing => 'Y',
309: p_paren_count => 2,

Line 316: poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl

312:
313: l_ytd_sel_clause := get_ytd_sel_clause( l_view_by ,l_view_by_col);
314: l_blgopn_ytd_sql := l_sql;
315: l_viewby_rank_where := ') oset15) oset20 WHERE ' || l_filter_where || ')oset , '||
316: poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl
317: , p_use_windowing => 'Y'
318: );
319:
320: /* YTD SQL */

Line 751: || poa_dbi_template_pkg.dtl_status_sql2 (p_fact_name => l_mv

747: WHERE fact.chr_id = k.chr_id) ';
748:
749: l_query := get_pduernwldetail_sel_clause (l_cur_suffix, l_period_type )
750:
751: || poa_dbi_template_pkg.dtl_status_sql2 (p_fact_name => l_mv
752: , p_where_clause => l_where_clause || l_rpt_specific_where
753: , p_join_tables => l_join_tbl
754: , p_use_windowing => 'Y'
755: , p_col_name => l_col_tbl

Line 1380: poa_dbi_template_pkg.union_all_trend_sql

1376: /* Additional filter needed to avoid displaying records queried due to total values at node */
1377:
1378:
1379: l_template_sql :=
1380: poa_dbi_template_pkg.union_all_trend_sql
1381: (p_mv => l_mv_tbl,
1382: p_comparison_type => l_comparison_type,
1383: p_filter_where => NULL);
1384: