APPS.OKI_DBI_NSCM_BAL_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 119: || poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl

115: ||' UNION ALL ' || get_bal_itd_sql(p_param ,'N')
116: ||' UNION ALL ' || l_ytd_sql
117: ||' ) oset05 GROUP BY '|| l_view_by_col ||
118: ') oset10) oset13) oset15) oset20 ) ' || l_filter_where || ')oset , '
119: || poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl
120: , p_use_windowing => 'Y' );
121:
122: x_custom_sql := '/* OKI_DBI_SCM_BAL_SUM_RPT */ '||l_query;
123: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

Line 451: ||poa_dbi_template_pkg.union_all_status_sql

447: END IF;
448:
449: IF (p_trend_flag = 'N') THEN
450: l_sql := get_xtd_sel_clause (p_ptd, l_view_by_col, 'N') || '('
451: ||poa_dbi_template_pkg.union_all_status_sql
452: (p_mv => l_mv_tbl,
453: p_join_tables => l_join_tbl,
454: p_use_windowing => 'Y',
455: p_paren_count => 1,

Line 511: || poa_dbi_template_pkg.union_all_trend_sql

507: END IF;
508:
509: ELSE
510: l_sql := get_xtd_sel_clause (p_ptd, l_view_by_col, 'Y')
511: || poa_dbi_template_pkg.union_all_trend_sql
512: (p_mv => l_mv_tbl,
513: p_comparison_type => l_comparison_type,
514: p_filter_where => NULL);
515:

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

979: l_ytd_sql := get_bal_ytd_sql(p_param ,'Y');
980:
981: l_xtd_sql := get_bal_trend_sel_clause(l_cur_suffix)
982: || ' from '
983: || poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd
984: , p_comparison_type => l_comparison_type
985: , p_fact_name => l_mv
986: , p_where_clause => l_where_clause
987: , p_col_name => l_col_tbl

Line 1156: || poa_dbi_template_pkg.dtl_status_sql2 (

1152: , OKI_SCM_OCR_MV k
1153: WHERE fact.chr_id = k.chr_id) ';
1154:
1155: l_query := get_bal_detail_sel_clause(l_cur_suffix, l_period_type, '1')
1156: || poa_dbi_template_pkg.dtl_status_sql2 (
1157: p_fact_name => l_mv
1158: , p_where_clause => l_where_clause || l_rpt_specific_where
1159: , p_join_tables => l_join_tbl
1160: , p_use_windowing => 'Y'