eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_DBI_NSCM_BAL_PVT dependencies on POA_DBI_UTIL_PKG

Line 64: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

60: l_cur_suffix VARCHAR2 (2);
61: l_where_clause VARCHAR2 (2000);
62: l_filter_where VARCHAR2 (240);
63: l_mv VARCHAR2 (2000);
64: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
65: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
66: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
67: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
68: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';

Line 65: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

61: l_where_clause VARCHAR2 (2000);
62: l_filter_where VARCHAR2 (240);
63: l_mv VARCHAR2 (2000);
64: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
65: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
66: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
67: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
68: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';
69: l_to_date_itd CONSTANT VARCHAR2 (3) := 'ITD';

Line 78: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();

74:
75: BEGIN
76:
77: l_comparison_type := 'Y';
78: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
79:
80:
81: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
82: , p_view_by => l_view_by

Line 148: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

144: l_where_clause3 VARCHAR2 (2000);
145: l_where_clause4 VARCHAR2 (2000);
146: l_filter_where VARCHAR2 (240);
147: l_mv VARCHAR2 (2000);
148: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
149: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
150: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';
151: l_to_date_itd CONSTANT VARCHAR2 (3) := 'ITD';
152: l_sql VARCHAR2(32767);

Line 149: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

145: l_where_clause4 VARCHAR2 (2000);
146: l_filter_where VARCHAR2 (240);
147: l_mv VARCHAR2 (2000);
148: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
149: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
150: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';
151: l_to_date_itd CONSTANT VARCHAR2 (3) := 'ITD';
152: l_sql VARCHAR2(32767);
153: l_mv1 VARCHAR2(100);

Line 157: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

153: l_mv1 VARCHAR2(100);
154: l_mv2 VARCHAR2(100);
155: l_mv3 VARCHAR2(100);
156: l_mv4 VARCHAR2(100);
157: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
158: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
159: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
160: l_col_tbl4 poa_dbi_util_pkg.poa_dbi_col_tbl;
161: l_xtd1 VARCHAR2(10);

Line 158: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

154: l_mv2 VARCHAR2(100);
155: l_mv3 VARCHAR2(100);
156: l_mv4 VARCHAR2(100);
157: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
158: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
159: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
160: l_col_tbl4 poa_dbi_util_pkg.poa_dbi_col_tbl;
161: l_xtd1 VARCHAR2(10);
162: l_xtd2 VARCHAR2(10);

Line 159: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;

155: l_mv3 VARCHAR2(100);
156: l_mv4 VARCHAR2(100);
157: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
158: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
159: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
160: l_col_tbl4 poa_dbi_util_pkg.poa_dbi_col_tbl;
161: l_xtd1 VARCHAR2(10);
162: l_xtd2 VARCHAR2(10);
163: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 160: l_col_tbl4 poa_dbi_util_pkg.poa_dbi_col_tbl;

156: l_mv4 VARCHAR2(100);
157: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
158: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
159: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
160: l_col_tbl4 poa_dbi_util_pkg.poa_dbi_col_tbl;
161: l_xtd1 VARCHAR2(10);
162: l_xtd2 VARCHAR2(10);
163: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
164: l_sql1 VARCHAR2(32767);

Line 163: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

159: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
160: l_col_tbl4 poa_dbi_util_pkg.poa_dbi_col_tbl;
161: l_xtd1 VARCHAR2(10);
162: l_xtd2 VARCHAR2(10);
163: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
164: l_sql1 VARCHAR2(32767);
165: l_sql2 VARCHAR2(32767);
166: l_sql3 VARCHAR2(32767);
167: l_sql4 VARCHAR2(32767);

Line 173: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();

169:
170: BEGIN
171:
172: l_comparison_type := 'Y';
173: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

Line 174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

170: BEGIN
171:
172: l_comparison_type := 'Y';
173: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
178: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

Line 175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

171:
172: l_comparison_type := 'Y';
173: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
178: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
179:

Line 176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

172: l_comparison_type := 'Y';
173: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
178: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
179:
180: /* Balance logic for OI */

Line 177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();

173: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
178: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
179:
180: /* Balance logic for OI */
181: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

Line 178: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

174: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
175: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
176: l_col_tbl3 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
177: l_col_tbl4 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
178: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
179:
180: /* Balance logic for OI */
181: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
182:

Line 205: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

201: , p_role => NULL
202: , p_mv_set => 'SRM_ST_71'
203: , p_rg_where => 'Y');
204:
205: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
206: , p_col_name => 's_g_o_amt_' || l_cur_suffix
207: , p_alias_name => 'xtd1'
208: , p_grand_total => 'N'
209: , p_to_date_type => p_ptd);

Line 211: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

207: , p_alias_name => 'xtd1'
208: , p_grand_total => 'N'
209: , p_to_date_type => p_ptd);
210:
211: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
212: , p_col_name => 's_r_o_amt_' || l_cur_suffix
213: , p_alias_name => 'xtd11'
214: , p_grand_total => 'N'
215: , p_to_date_type => p_ptd);

Line 239: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

235: , p_mv_set => 'SRM_EN_71'
236: , p_rg_where => 'Y');
237:
238:
239: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
240: , p_col_name => 'bal_k_amt_' || l_cur_suffix
241: , p_alias_name => 'xtd2'
242: , p_grand_total => 'N'
243: , p_to_date_type => p_ptd);

Line 265: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl3

261: , p_role => NULL
262: , p_mv_set => 'SRM_TM_71'
263: , p_rg_where => 'Y');
264:
265: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl3
266: , p_col_name => 'bal_k_amt_' || l_cur_suffix
267: , p_alias_name => 'xtd3'
268: , p_grand_total => 'N'
269: , p_to_date_type => p_ptd);

Line 318: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

314: , p_role => NULL
315: , p_mv_set => 'SRM_ST_71'
316: , p_rg_where => 'Y');
317:
318: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
319: , p_col_name => 's_g_amt_' || l_cur_suffix
320: , p_alias_name => 'xtd1'
321: , p_grand_total => 'N'
322: , p_to_date_type => p_ptd);

Line 324: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

320: , p_alias_name => 'xtd1'
321: , p_grand_total => 'N'
322: , p_to_date_type => p_ptd);
323:
324: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
325: , p_col_name => 's_rg_amt_' || l_cur_suffix
326: , p_alias_name => 'xtd11'
327: , p_grand_total => 'N'
328: , p_to_date_type => p_ptd);

Line 352: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

348: , p_mv_set => 'SRM_EN_71'
349: , p_rg_where => 'Y');
350:
351:
352: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
353: , p_col_name => 'bal_k_amt_' || l_cur_suffix
354: , p_alias_name => 'xtd2'
355: , p_grand_total => 'N'
356: , p_to_date_type => p_ptd);

Line 378: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl3

374: , p_role => NULL
375: , p_mv_set => 'SRM_TM_71'
376: , p_rg_where => 'Y');
377:
378: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl3
379: , p_col_name => 'bal_k_amt_' || l_cur_suffix
380: , p_alias_name => 'xtd3'
381: , p_grand_total => 'N'
382: , p_to_date_type => p_ptd);

Line 425: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl4

421: , p_role => NULL
422: , p_mv_set => 'SRM_SG_71'
423: , p_rg_where => 'Y');
424:
425: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl4
426: , p_col_name => 'gl_s_amt_' || l_cur_suffix
427: , p_alias_name => 'xtd4'
428: , p_grand_total => 'N'
429: , p_to_date_type => p_ptd);

Line 431: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl4

427: , p_alias_name => 'xtd4'
428: , p_grand_total => 'N'
429: , p_to_date_type => p_ptd);
430:
431: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl4
432: , p_col_name => 'gl_r_amt_' || l_cur_suffix
433: , p_alias_name => 'xtd44'
434: , p_grand_total => 'N'
435: , p_to_date_type => p_ptd);

Line 692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||

688: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur','oset15.c_beg','NP') || ' ptd_chg '||
689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||
690: ' from (select '|| p_view_by_col ||', oset13.c_cur , oset13.c_cur_tot '||
691: ' , oset13.p_cur , oset13.p_cur_tot '||
692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||
693: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_cur','oset13.p_cur_tot') || ' p_cur_per '||
694: ' , oset13.c_beg , oset13.c_beg_tot, oset13.p_beg , oset13.p_beg_tot '||
695: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_beg','oset13.c_beg_tot') || ' c_beg_per '||
696: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_beg','oset13.p_beg_tot') || ' p_beg_per '||

Line 693: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_cur','oset13.p_cur_tot') || ' p_cur_per '||

689: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_cur_tot','oset15.c_beg_tot','NP') || ' ptd_chg_tot '||
690: ' from (select '|| p_view_by_col ||', oset13.c_cur , oset13.c_cur_tot '||
691: ' , oset13.p_cur , oset13.p_cur_tot '||
692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||
693: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_cur','oset13.p_cur_tot') || ' p_cur_per '||
694: ' , oset13.c_beg , oset13.c_beg_tot, oset13.p_beg , oset13.p_beg_tot '||
695: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_beg','oset13.c_beg_tot') || ' c_beg_per '||
696: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_beg','oset13.p_beg_tot') || ' p_beg_per '||
697: ' from (select '|| p_view_by_col ||

Line 695: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_beg','oset13.c_beg_tot') || ' c_beg_per '||

691: ' , oset13.p_cur , oset13.p_cur_tot '||
692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||
693: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_cur','oset13.p_cur_tot') || ' p_cur_per '||
694: ' , oset13.c_beg , oset13.c_beg_tot, oset13.p_beg , oset13.p_beg_tot '||
695: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_beg','oset13.c_beg_tot') || ' c_beg_per '||
696: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_beg','oset13.p_beg_tot') || ' p_beg_per '||
697: ' from (select '|| p_view_by_col ||
698: ' , (oset10.c_itd + oset10.c_ytd) c_cur '||
699: ' , (oset10.c_itd_tot + oset10.c_ytd_tot) c_cur_tot '||

Line 696: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_beg','oset13.p_beg_tot') || ' p_beg_per '||

692: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_cur','oset13.c_cur_tot') || ' c_cur_per '||
693: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_cur','oset13.p_cur_tot') || ' p_cur_per '||
694: ' , oset13.c_beg , oset13.c_beg_tot, oset13.p_beg , oset13.p_beg_tot '||
695: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_beg','oset13.c_beg_tot') || ' c_beg_per '||
696: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_beg','oset13.p_beg_tot') || ' p_beg_per '||
697: ' from (select '|| p_view_by_col ||
698: ' , (oset10.c_itd + oset10.c_ytd) c_cur '||
699: ' , (oset10.c_itd_tot + oset10.c_ytd_tot) c_cur_tot '||
700: ' , (oset10.p_itd + oset10.p_ytd) p_cur '||

Line 739: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

735: l_cur_suffix VARCHAR2 (2);
736: l_where_clause VARCHAR2 (2000);
737: l_filter_where VARCHAR2 (240);
738: l_mv VARCHAR2 (2000);
739: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
740: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
741: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
742: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
743: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';

Line 740: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

736: l_where_clause VARCHAR2 (2000);
737: l_filter_where VARCHAR2 (240);
738: l_mv VARCHAR2 (2000);
739: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
740: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
741: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
742: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
743: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';
744: l_to_date_itd CONSTANT VARCHAR2 (3) := 'ITD';

Line 752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

748:
749: BEGIN
750:
751: l_comparison_type := 'Y';
752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
753: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
754:
755: oki_dbi_util_pvt.process_parameters (p_param => p_param
756: , p_view_by => l_view_by

Line 753: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();

749: BEGIN
750:
751: l_comparison_type := 'Y';
752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
753: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
754:
755: oki_dbi_util_pvt.process_parameters (p_param => p_param
756: , p_view_by => l_view_by
757: , p_view_by_col_name => l_view_by_col

Line 775: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

771: , p_role => NULL
772: , p_mv_set => 'SRM_BAL'
773: , p_rg_where => 'Y');
774:
775: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
776: , p_col_name => 'NULL'
777: , p_alias_name => 'xtd'
778: , p_grand_total => 'N'
779: , p_to_date_type => l_to_date_xtd);

Line 781: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

777: , p_alias_name => 'xtd'
778: , p_grand_total => 'N'
779: , p_to_date_type => l_to_date_xtd);
780:
781: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
782: , p_col_name => 'bal_amt_' || l_cur_suffix
783: , p_alias_name => 'itd'
784: , p_grand_total => 'N'
785: , p_to_date_type => l_to_date_itd);

Line 787: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

783: , p_alias_name => 'itd'
784: , p_grand_total => 'N'
785: , p_to_date_type => l_to_date_itd);
786:
787: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
788: , p_col_name => 'NULL'
789: , p_alias_name => 'ytd'
790: , p_grand_total => 'N'
791: , p_to_date_type => l_to_date_ytd);

Line 827: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

823: l_cur_suffix VARCHAR2 (2);
824: l_where_clause VARCHAR2 (2000);
825: l_filter_where VARCHAR2 (240);
826: l_mv VARCHAR2 (2000);
827: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
828: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
829: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
830: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
831: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';

Line 828: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

824: l_where_clause VARCHAR2 (2000);
825: l_filter_where VARCHAR2 (240);
826: l_mv VARCHAR2 (2000);
827: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
828: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
829: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
830: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
831: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';
832: l_to_date_itd CONSTANT VARCHAR2 (3) := 'ITD';

Line 840: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

836:
837: BEGIN
838:
839: l_comparison_type := 'Y';
840: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
841: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
842:
843: oki_dbi_util_pvt.process_parameters (p_param => p_param
844: , p_view_by => l_view_by

Line 841: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();

837: BEGIN
838:
839: l_comparison_type := 'Y';
840: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
841: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
842:
843: oki_dbi_util_pvt.process_parameters (p_param => p_param
844: , p_view_by => l_view_by
845: , p_view_by_col_name => l_view_by_col

Line 864: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

860: , p_mv_set => 'SRM'
861: , p_rg_where => 'Y');
862:
863:
864: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
865: , p_col_name => 'NULL'
866: , p_alias_name => 'xtd'
867: , p_grand_total => 'N'
868: , p_to_date_type => l_to_date_xtd);

Line 870: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

866: , p_alias_name => 'xtd'
867: , p_grand_total => 'N'
868: , p_to_date_type => l_to_date_xtd);
869:
870: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
871: , p_col_name => 'NULL'
872: , p_alias_name => 'itd'
873: , p_grand_total => 'N'
874: , p_to_date_type => l_to_date_itd);

Line 876: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

872: , p_alias_name => 'itd'
873: , p_grand_total => 'N'
874: , p_to_date_type => l_to_date_itd);
875:
876: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
877: , p_col_name => 'bal_k_amt_' || l_cur_suffix
878: , p_alias_name => 'ytd'
879: , p_grand_total => 'N'
880: , p_to_date_type => l_to_date_ytd);

Line 928: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

924: l_dim_bmap NUMBER;
925: l_cur_suffix VARCHAR2 (2);
926: l_custom_sql VARCHAR2 (10000);
927:
928: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
929: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
930: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
931: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
932: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';

Line 929: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

925: l_cur_suffix VARCHAR2 (2);
926: l_custom_sql VARCHAR2 (10000);
927:
928: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
929: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
930: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
931: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
932: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';
933: l_to_date_itd CONSTANT VARCHAR2 (3) := 'ITD';

Line 946: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

942:
943: BEGIN
944:
945: l_comparison_type := 'Y';
946: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
947: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
948:
949: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
950: , p_view_by => l_view_by

Line 947: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();

943: BEGIN
944:
945: l_comparison_type := 'Y';
946: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
947: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
948:
949: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
950: , p_view_by => l_view_by
951: , p_view_by_col_name => l_view_by_col

Line 1083: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

1079: l_nested_pattern NUMBER;
1080: l_cur_suffix VARCHAR2 (2);
1081: l_where_clause VARCHAR2 (2000);
1082: l_mv VARCHAR2 (2000);
1083: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1084: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1085: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
1086: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
1087:

Line 1084: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1080: l_cur_suffix VARCHAR2 (2);
1081: l_where_clause VARCHAR2 (2000);
1082: l_mv VARCHAR2 (2000);
1083: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
1084: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1085: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
1086: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
1087:
1088: l_rpt_specific_where VARCHAR2 (1000);

Line 1102: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

1098: BEGIN
1099:
1100:
1101: l_comparison_type := 'Y';
1102: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1103: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1104:
1105:
1106: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param

Line 1103: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();

1099:
1100:
1101: l_comparison_type := 'Y';
1102: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1103: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1104:
1105:
1106: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
1107: , p_view_by => l_view_by

Line 1135: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

1131: AND fact.effective_end_date > &BIS_CURRENT_ASOF_DATE';
1132:
1133: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id,fact.date_signed';
1134:
1135: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1136: , p_col_name => 'price_negotiated_' || l_cur_suffix
1137: , p_alias_name => 'Bal'
1138: , p_prior_code => poa_dbi_util_pkg.no_priors);
1139:

Line 1138: , p_prior_code => poa_dbi_util_pkg.no_priors);

1134:
1135: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
1136: , p_col_name => 'price_negotiated_' || l_cur_suffix
1137: , p_alias_name => 'Bal'
1138: , p_prior_code => poa_dbi_util_pkg.no_priors);
1139:
1140: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1141:
1142: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl

Line 1140: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

1136: , p_col_name => 'price_negotiated_' || l_cur_suffix
1137: , p_alias_name => 'Bal'
1138: , p_prior_code => poa_dbi_util_pkg.no_priors);
1139:
1140: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1141:
1142: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl
1143: , p_func_area => 'SRM'
1144: , p_version => '6.0'