APPS.OKI_DBI_NSCM_EXP_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 119: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv

115: l_query :=
116: get_expirations_sel_clause (l_view_by
117: , l_view_by_col)
118: || ' from '
119: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv
120: , p_where_clause => l_where_clause
121: , p_filter_where => l_filter_where
122: , p_join_tables => l_join_tbl
123: , p_use_windowing => 'Y'

Line 223: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv

219: l_query :=
220: get_period_expiring_sel_clause (l_view_by
221: , l_view_by_col)
222: || ' from '
223: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv
224: , p_where_clause => l_where_clause
225: , p_filter_where => l_filter_where
226: , p_join_tables => l_join_tbl
227: , p_use_windowing => 'Y'

Line 773: || poa_dbi_template_pkg.dtl_status_sql2 (

769: l_rpt_specific_where:=l_rpt_specific_where||l_exp_type_filter;
770:
771:
772: l_query := get_exp_detail_sel_clause(l_cur_suffix, l_period_type, l_exp_type)
773: || poa_dbi_template_pkg.dtl_status_sql2 (
774: p_fact_name => l_mv
775: , p_where_clause => l_where_clause || l_rpt_specific_where
776: , p_join_tables => l_join_tbl
777: , p_use_windowing => 'Y'

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

969: , p_mv_set => 'SRM_CDTL_RPT');
970:
971:
972: l_query := get_prd_exp_cont_sel_clause (l_cur_suffix, l_period_type, l_exp_type )
973: ||poa_dbi_template_pkg.dtl_status_sql2 (p_fact_name => l_mv
974: , p_where_clause => l_where_clause || l_rpt_specific_where
975: , p_join_tables => l_join_tbl
976: , p_use_windowing => 'Y'
977: , p_col_name => l_col_tbl