APPS.OPI_DBI_INV_CURR_RPT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 212: l_query := poa_dbi_template_pkg.status_sql (

208: -- at the start of the where clause, since it starts with an AND.
209: l_where_clause := '1 = 1 ' || l_where_clause;
210:
211: -- The status query provided by POA
212: l_query := poa_dbi_template_pkg.status_sql (
213: p_fact_name => l_mv,
214: p_where_clause => l_where_clause,
215: p_join_tables => l_join_tbl,
216: p_use_windowing => 'Y',

Line 667: l_query := poa_dbi_template_pkg.union_all_status_sql (

663: -- }
664: END CASE;
665:
666: -- The union all query provided by POA
667: l_query := poa_dbi_template_pkg.union_all_status_sql (
668: p_mv => l_unionall_tbl,
669: p_join_tables => l_join_tbl,
670: p_use_windowing => 'Y',
671: p_paren_count => 5,

Line 1242: poa_dbi_template_pkg.get_viewby_rank_clause (

1238:
1239: -- The outermost ranking/order by clause with
1240: -- the join to the dimension tables.
1241: l_viewby_rank_clause :=
1242: poa_dbi_template_pkg.get_viewby_rank_clause (
1243: p_join_tables => l_join_tbl,
1244: p_use_windowing => 'Y');
1245:
1246: -- Put the query together