APPS.OKI_DBI_SRM_BKRNWL_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 478: poa_dbi_template_pkg.union_all_status_sql

474:
475: l_filter_where := ' ( ABS(oki_measure_1) + ABS(oki_measure_2) ) <> 0';
476:
477: l_query :=
478: poa_dbi_template_pkg.union_all_status_sql
479: (p_mv => l_mv_tbl,
480: p_join_tables => l_join_tbl,
481: p_use_windowing => 'Y',
482: p_paren_count => 5,

Line 486: poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl

482: p_paren_count => 5,
483: p_filter_where => NULL,
484: p_generate_viewby => 'N');
485: l_viewby_rank_where := ' WHERE ' || l_filter_where || ')oset , '||
486: poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl
487: , p_use_windowing => 'Y'
488: );
489:
490: l_query :=

Line 493: /* poa_dbi_template_pkg.status_sql (

489:
490: l_query :=
491: get_table_sel_clause (l_view_by, l_view_by_col) ||
492: l_query||l_viewby_rank_where;
493: /* poa_dbi_template_pkg.status_sql (
494: -- p_nested_pattern => l_nested_pattern
495: p_fact_name => l_mv
496: , p_where_clause => l_where_clause
497: , p_filter_where => l_filter_where

Line 631: ||poa_dbi_template_pkg.union_all_trend_sql

627: l_mv_tbl(2).use_grp_id := 'N';
628: l_mv_tbl(2).mv_xtd := l_xtd2;
629:
630: l_query := get_trend_sel_clause || ' from '
631: ||poa_dbi_template_pkg.union_all_trend_sql
632: (p_mv => l_mv_tbl,
633: p_comparison_type => 'R',
634: p_filter_where => NULL);
635:

Line 636: /*poa_dbi_template_pkg.trend_sql ( l_xtd

632: (p_mv => l_mv_tbl,
633: p_comparison_type => 'R',
634: p_filter_where => NULL);
635:
636: /*poa_dbi_template_pkg.trend_sql ( l_xtd
637: , l_comparison_type
638: , l_mv
639: , l_where_clause
640: , l_col_tbl