APPS.OKI_DBI_SRM_RNWL_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 189: ' || poa_dbi_template_pkg.union_all_status_sql

185:
186:
187: l_query := get_table_sel_clause (l_view_by, l_view_by_col)
188: || ' from (
189: ' || poa_dbi_template_pkg.union_all_status_sql
190: (p_mv => l_mv_tbl,
191: p_join_tables => l_join_tbl,
192: p_use_windowing => 'Y',
193: p_paren_count => 7,

Line 476: poa_dbi_template_pkg.dtl_status_sql2 (

472: /* Additional filter needed to avoid displaying records queried due to total values at node */
473: l_filter_where := ' ( ABS(oki_measure_1) ) <> 0 ';
474:
475: l_query := get_bookings_sel_clause (l_cur_suffix, l_period_type ) ||
476: poa_dbi_template_pkg.dtl_status_sql2 (
477: p_fact_name => l_mv
478: , p_where_clause => l_where_clause || l_rpt_specific_where
479: , p_join_tables => l_join_tbl
480: , p_use_windowing => 'Y'

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

570: , p_role => NULL
571: , p_mv_set => 'SRM_TBK_RPT');
572:
573: l_query := get_top_bookings_sel_clause (l_curr_suffix, l_period_type )
574: || poa_dbi_template_pkg.dtl_status_sql2 (p_fact_name => l_mv
575: , p_where_clause => l_where_clause || l_rpt_specific_where
576: , p_join_tables => l_join_tbl
577: , p_use_windowing => 'Y'
578: , p_col_name => l_col_tbl

Line 831: || poa_dbi_template_pkg.dtl_status_sql2 (

827: , p_mv_set => 'SRM_DTL_RPT');
828:
829: l_query := get_renwlforecast_sel_clause (l_cur_suffix, l_period_type )
830:
831: || poa_dbi_template_pkg.dtl_status_sql2 (
832: p_fact_name => l_mv
833: , p_where_clause => l_where_clause || l_rpt_specific_where
834: , p_join_tables => l_join_tbl
835: , p_use_windowing => 'Y'

Line 1058: || poa_dbi_template_pkg.status_sql (

1054: l_query :=
1055: get_late_rnwl_table_sel_clause (l_view_by
1056: , l_view_by_col)
1057: || ' from '
1058: || poa_dbi_template_pkg.status_sql (
1059: p_fact_name => l_mv
1060: , p_where_clause => l_where_clause
1061: , p_filter_where => l_filter_where
1062: , p_join_tables => l_join_tbl

Line 1395: || poa_dbi_template_pkg.status_sql (

1391: l_query :=
1392: get_cncl_table_sel_clause ( l_view_by
1393: , l_view_by_col)
1394: || ' from '
1395: || poa_dbi_template_pkg.status_sql (
1396: p_fact_name => l_mv
1397: , p_where_clause => l_where_clause
1398: , p_filter_where => l_filter_where
1399: , p_join_tables => l_join_tbl

Line 1622: || poa_dbi_template_pkg.dtl_status_sql2 (

1618:
1619:
1620: l_query := get_cancellations_sel_clause (l_curr_suffix, l_period_type )
1621:
1622: || poa_dbi_template_pkg.dtl_status_sql2 (
1623: p_fact_name => l_mv
1624: , p_where_clause => l_where_clause || l_rpt_specific_where
1625: , p_join_tables => l_join_tbl
1626: , p_use_windowing => 'Y'

Line 2089: || poa_dbi_template_pkg.union_all_trend_sql(

2085: l_mv_tbl(2).mv_xtd := l_xtd2;
2086: /* Additional filter needed to avoid displaying records queried due to total values at node */
2087: l_query := get_bkng_trend_sel_clause
2088: || ' from '
2089: || poa_dbi_template_pkg.union_all_trend_sql(
2090: p_mv => l_mv_tbl,
2091: p_comparison_type => l_comparison_type,
2092: p_filter_where => NULL);
2093: -- insert into brrao_temp values ( l_query);

Line 2099: || poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd

2095: /*
2096: l_query :=
2097: get_bkng_trend_sel_clause
2098: || ' from '
2099: || poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd
2100: , p_comparison_type => l_comparison_type
2101: , p_fact_name => l_mv
2102: , p_where_clause => l_where_clause
2103: , p_col_name => l_col_tbl