APPS.OPI_DBI_WMS_RTP_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 184: ' || poa_dbi_template_pkg.union_all_status_sql

180:
181:
182: l_query := get_tbl_sel_clause1 (l_view_by, l_join_tbl)
183: || ' from (
184: ' || poa_dbi_template_pkg.union_all_status_sql
185: (p_mv => l_mv_tbl,
186: p_join_tables => l_join_tbl,
187: p_use_windowing => 'Y',
188: p_paren_count => 3,

Line 195: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv2,

191:
192: ELSE
193: l_query := get_tbl_sel_clause2(l_view_by, l_join_tbl)
194: || ' from
195: ' || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv2,
196: p_where_clause => l_where_clause2,
197: p_join_tables => l_join_tbl,
198: p_use_windowing => 'Y',
199: p_col_name => l_col_tbl2,

Line 801: poa_dbi_template_pkg.union_all_trend_sql(

797: l_mv_tbl(2).mv_xtd := l_xtd2;
798:
799: l_query := get_trd_sel_clause(l_view_by) ||
800: ' from ' ||
801: poa_dbi_template_pkg.union_all_trend_sql(
802: p_mv => l_mv_tbl,
803: p_comparison_type => l_comparison_type,
804:
805: p_filter_where => NULL

Line 811: poa_dbi_template_pkg.trend_sql(

807:
808: ELSE
809: l_query := get_trd_sel_clause2(l_view_by) ||
810: ' from ' ||
811: poa_dbi_template_pkg.trend_sql(
812: p_xtd => l_xtd2,
813: p_comparison_type => l_comparison_type,
814: p_fact_name => l_mv2,
815: p_where_clause => l_where_clause2,