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_ACT_PVT dependencies on POA_DBI_UTIL_PKG

Line 33: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

29: l_where_clause2 VARCHAR2 (2000);
30: l_mv VARCHAR2 (2000);
31: l_mv1 VARCHAR2 (2000);
32: l_mv2 VARCHAR2 (2000);
33: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
34: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
35: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
36: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
37: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 34: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

30: l_mv VARCHAR2 (2000);
31: l_mv1 VARCHAR2 (2000);
32: l_mv2 VARCHAR2 (2000);
33: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
34: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
35: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
36: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
37: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
38:

Line 35: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

31: l_mv1 VARCHAR2 (2000);
32: l_mv2 VARCHAR2 (2000);
33: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
34: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
35: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
36: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
37: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
38:
39: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';

Line 36: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

32: l_mv2 VARCHAR2 (2000);
33: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
34: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
35: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
36: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
37: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
38:
39: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
40: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';

Line 37: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

33: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
34: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
35: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
36: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
37: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
38:
39: l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
40: l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
41: l_to_date_ytd CONSTANT VARCHAR2 (3) := 'YTD';

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

44:
45: BEGIN
46:
47: l_comparison_type := 'Y';
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
50: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
51: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
52: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

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

45: BEGIN
46:
47: l_comparison_type := 'Y';
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
50: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
51: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
52: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
53:

Line 50: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();

46:
47: l_comparison_type := 'Y';
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
50: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
51: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
52: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
53:
54: l_filter_where := ' (ABS(oki_measure_1)+ABS(oki_pmeasure_1)+ABS(oki_measure_3)) <> 0';

Line 51: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();

47: l_comparison_type := 'Y';
48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
50: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
51: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
52: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
53:
54: l_filter_where := ' (ABS(oki_measure_1)+ABS(oki_pmeasure_1)+ABS(oki_measure_3)) <> 0';
55:

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

48: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
49: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
50: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
51: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
52: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
53:
54: l_filter_where := ' (ABS(oki_measure_1)+ABS(oki_pmeasure_1)+ABS(oki_measure_3)) <> 0';
55:
56: /* Balance logic for OI */

Line 82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

78: , p_role => NULL
79: , p_mv_set => 'SRM_ST_71' --Change done to support customer classication (NGM)
80: , p_rg_where => 'Y');
81:
82: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
83: , p_col_name => 's_g_amt_' || l_cur_suffix
84: , p_alias_name => 'NBsgo'
85: , p_to_date_type => l_to_date_xtd);
86:

Line 88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

84: , p_alias_name => 'NBsgo'
85: , p_to_date_type => l_to_date_xtd);
86:
87:
88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
89: , p_col_name => 's_xg_r_amt_' || l_cur_suffix
90: , p_alias_name => 'AEsxr'
91: , p_to_date_type => l_to_date_xtd);
92:

Line 93: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

89: , p_col_name => 's_xg_r_amt_' || l_cur_suffix
90: , p_alias_name => 'AEsxr'
91: , p_to_date_type => l_to_date_xtd);
92:
93: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
94: , p_col_name => 's_rg_amt_' || l_cur_suffix
95: , p_alias_name => 'ARsro'
96: , p_to_date_type => l_to_date_xtd);
97:

Line 119: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

115: , p_role => NULL
116: , p_mv_set => 'SRM_SG_71' --Change done to support customer classication (NGM)
117: , p_rg_where => 'Y');
118:
119: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
120: , p_col_name => 'gl_s_amt_' || l_cur_suffix
121: , p_alias_name => 'NBgo'
122: , p_to_date_type => l_to_date_xtd);
123:

Line 125: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

121: , p_alias_name => 'NBgo'
122: , p_to_date_type => l_to_date_xtd);
123:
124:
125: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
126: , p_col_name => 'gL_o_amt_' || l_cur_suffix
127: , p_alias_name => 'AEglr'
128: , p_to_date_type => l_to_date_xtd);
129:

Line 130: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

126: , p_col_name => 'gL_o_amt_' || l_cur_suffix
127: , p_alias_name => 'AEglr'
128: , p_to_date_type => l_to_date_xtd);
129:
130: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
131: , p_col_name => 'gl_r_amt_' || l_cur_suffix
132: , p_alias_name => 'ARgls'
133: , p_to_date_type => l_to_date_xtd);
134:

Line 196: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

192: , p_role => NULL
193: , p_mv_set => 'SRM_ST_71' --Change done to support customer classication (NGM)
194: , p_rg_where => 'Y');
195:
196: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
197: , p_col_name => 's_g_o_amt_' || l_cur_suffix
198: , p_alias_name => 'NBsgo'
199: , p_to_date_type => l_to_date_xtd);
200:

Line 202: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

198: , p_alias_name => 'NBsgo'
199: , p_to_date_type => l_to_date_xtd);
200:
201:
202: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
203: , p_col_name => 's_x_r_amt_' || l_cur_suffix
204: , p_alias_name => 'AEsxr'
205: , p_to_date_type => l_to_date_xtd);
206:

Line 207: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

203: , p_col_name => 's_x_r_amt_' || l_cur_suffix
204: , p_alias_name => 'AEsxr'
205: , p_to_date_type => l_to_date_xtd);
206:
207: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
208: , p_col_name => 's_r_o_amt_' || l_cur_suffix
209: , p_alias_name => 'ARsro'
210: , p_to_date_type => l_to_date_xtd);
211:

Line 348: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC','oset15.c_TAC_tot') || 'tac_PoT '||

344: ' '|| p_view_by_col ||
345: ' , oset15.C_TAC C_TAC '||
346: ' , oset15.P_TAC P_TAC '||
347: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAC','oset15.P_TAC','NP') || ' TAC_chg '||
348: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC','oset15.c_TAC_tot') || 'tac_PoT '||
349: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_TAC','oset15.p_TAC_tot') || 'p_tac_PoT '||
350: ' , oset15.C_TAC_tot C_TAC_tot '||
351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||
352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||

Line 349: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_TAC','oset15.p_TAC_tot') || 'p_tac_PoT '||

345: ' , oset15.C_TAC C_TAC '||
346: ' , oset15.P_TAC P_TAC '||
347: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAC','oset15.P_TAC','NP') || ' TAC_chg '||
348: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC','oset15.c_TAC_tot') || 'tac_PoT '||
349: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_TAC','oset15.p_TAC_tot') || 'p_tac_PoT '||
350: ' , oset15.C_TAC_tot C_TAC_tot '||
351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||
352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||
353: ' , oset15.c_NB '||

Line 352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||

348: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC','oset15.c_TAC_tot') || 'tac_PoT '||
349: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_TAC','oset15.p_TAC_tot') || 'p_tac_PoT '||
350: ' , oset15.C_TAC_tot C_TAC_tot '||
351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||
352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||
353: ' , oset15.c_NB '||
354: ' , oset15.p_NB '||
355: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB','oset15.c_TAC') || ' NB_PoT '||
356: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_NB','oset15.p_TAC') || ' p_NB_PoT '||

Line 355: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB','oset15.c_TAC') || ' NB_PoT '||

351: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.C_TAc_tot','oset15.P_TAC_tot','NP') || ' TAC_chg_tot '||
352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||
353: ' , oset15.c_NB '||
354: ' , oset15.p_NB '||
355: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB','oset15.c_TAC') || ' NB_PoT '||
356: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_NB','oset15.p_TAC') || ' p_NB_PoT '||
357: ' , oset15.c_NB_tot '||
358: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB_tot','oset15.c_TAC_tot') || ' NB_PoT_tot '||
359: ' , oset15.c_AE '||

Line 356: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_NB','oset15.p_TAC') || ' p_NB_PoT '||

352: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_TAC_tot','oset15.c_TAC_tot') || 'tac_PoT_tot '||
353: ' , oset15.c_NB '||
354: ' , oset15.p_NB '||
355: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB','oset15.c_TAC') || ' NB_PoT '||
356: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_NB','oset15.p_TAC') || ' p_NB_PoT '||
357: ' , oset15.c_NB_tot '||
358: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB_tot','oset15.c_TAC_tot') || ' NB_PoT_tot '||
359: ' , oset15.c_AE '||
360: ' , oset15.c_Upl '||

Line 358: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB_tot','oset15.c_TAC_tot') || ' NB_PoT_tot '||

354: ' , oset15.p_NB '||
355: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB','oset15.c_TAC') || ' NB_PoT '||
356: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_NB','oset15.p_TAC') || ' p_NB_PoT '||
357: ' , oset15.c_NB_tot '||
358: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_NB_tot','oset15.c_TAC_tot') || ' NB_PoT_tot '||
359: ' , oset15.c_AE '||
360: ' , oset15.c_Upl '||
361: ' , oset15.c_AR '||
362: ' , oset15.p_AE '||

Line 364: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_AR','oset15.c_TAC') || 'AR_PoT '||

360: ' , oset15.c_Upl '||
361: ' , oset15.c_AR '||
362: ' , oset15.p_AE '||
363: ' , oset15.p_AR '||
364: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_AR','oset15.c_TAC') || 'AR_PoT '||
365: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_AR','oset15.p_TAC') || 'p_AR_PoT '||
366: ' , oset15.p_NB_tot '||
367: ' , oset15.c_AE_tot '||
368: ' , oset15.c_Upl_tot '||

Line 365: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_AR','oset15.p_TAC') || 'p_AR_PoT '||

361: ' , oset15.c_AR '||
362: ' , oset15.p_AE '||
363: ' , oset15.p_AR '||
364: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_AR','oset15.c_TAC') || 'AR_PoT '||
365: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.p_AR','oset15.p_TAC') || 'p_AR_PoT '||
366: ' , oset15.p_NB_tot '||
367: ' , oset15.c_AE_tot '||
368: ' , oset15.c_Upl_tot '||
369: ' , oset15.c_AR_tot '||

Line 371: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_AR_tot','oset15.c_TAC_tot') || 'AR_PoT_tot '||

367: ' , oset15.c_AE_tot '||
368: ' , oset15.c_Upl_tot '||
369: ' , oset15.c_AR_tot '||
370: ' , oset15.p_AR_tot '||
371: ' ,'||poa_dbi_util_pkg.rate_clause('oset15.c_AR_tot','oset15.c_TAC_tot') || 'AR_PoT_tot '||
372: ' from '||
373: ' (select '||
374: -- Calculated Measures
375: p_view_by_col ||

Line 459: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

455: l_dim_bmap NUMBER;
456: l_cur_suffix VARCHAR2 (2);
457: l_custom_sql VARCHAR2 (10000);
458:
459: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
460: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
461: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
462: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
463: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 460: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

456: l_cur_suffix VARCHAR2 (2);
457: l_custom_sql VARCHAR2 (10000);
458:
459: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
460: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
461: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
462: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
463: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
464:

Line 461: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

457: l_custom_sql VARCHAR2 (10000);
458:
459: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
460: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
461: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
462: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
463: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
464:
465: l_period_code varchar2(1);

Line 462: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

458:
459: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
460: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
461: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
462: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
463: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
464:
465: l_period_code varchar2(1);
466: l_where_clause VARCHAR2 (2000);

Line 463: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

459: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
460: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
461: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
462: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
463: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
464:
465: l_period_code varchar2(1);
466: l_where_clause VARCHAR2 (2000);
467: l_where_clause1 VARCHAR2 (2000);

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

473:
474: BEGIN
475:
476: l_comparison_type := 'Y';
477: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
478: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
479: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
481: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

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

474: BEGIN
475:
476: l_comparison_type := 'Y';
477: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
478: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
479: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
481: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
482:

Line 479: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();

475:
476: l_comparison_type := 'Y';
477: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
478: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
479: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
481: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
482:
483: /* Balance logic for OI */

Line 480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();

476: l_comparison_type := 'Y';
477: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
478: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
479: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
481: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
482:
483: /* Balance logic for OI */
484: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');

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

477: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
478: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
479: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
480: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
481: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
482:
483: /* Balance logic for OI */
484: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
485:

Line 508: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

504: , p_role => NULL
505: --, p_mv_set => 'SRM' --NGM
506: , p_mv_set => 'SRM_ST_71' --Change done to support customer classication (NGM)
507: , p_rg_where => 'Y');
508: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
509: , p_col_name => 's_rg_amt_' || l_cur_suffix
510: , p_alias_name => 'sro_amt'
511: , p_grand_total => 'N'
512: , p_to_date_type => 'XTD');

Line 514: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

510: , p_alias_name => 'sro_amt'
511: , p_grand_total => 'N'
512: , p_to_date_type => 'XTD');
513:
514: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
515: , p_col_name => 's_g_amt_' || l_cur_suffix
516: , p_alias_name => 'sgo_amt'
517: , p_grand_total => 'N'
518: , p_to_date_type => 'XTD');

Line 539: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

535: , p_version => '7.0'
536: , p_role => NULL
537: , p_mv_set => 'SRM_SG_71'
538: , p_rg_where => 'Y');
539: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
540: , p_col_name => 'gl_s_amt_' || l_cur_suffix
541: , p_alias_name => 'gls_amt'
542: , p_grand_total => 'N'
543: , p_to_date_type => 'XTD');

Line 545: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

541: , p_alias_name => 'gls_amt'
542: , p_grand_total => 'N'
543: , p_to_date_type => 'XTD');
544:
545: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
546: , p_col_name => 'gl_r_amt_' || l_cur_suffix
547: , p_alias_name => 'glr_amt'
548: , p_grand_total => 'N'
549: , p_to_date_type => 'XTD');

Line 600: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

596: , p_role => NULL
597: --, p_mv_set => 'SRM' --NGM
598: , p_mv_set => 'SRM_ST_71' --Change done to support customer classication (NGM)
599: , p_rg_where => 'Y');
600: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
601: , p_col_name => 's_r_o_amt_' || l_cur_suffix
602: , p_alias_name => 'sro_amt'
603: , p_grand_total => 'N'
604: , p_to_date_type => 'XTD');

Line 606: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

602: , p_alias_name => 'sro_amt'
603: , p_grand_total => 'N'
604: , p_to_date_type => 'XTD');
605:
606: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
607: , p_col_name => 's_g_o_amt_' || l_cur_suffix
608: , p_alias_name => 'sgo_amt'
609: , p_grand_total => 'N'
610: , p_to_date_type => 'XTD');

Line 696: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

692: l_nested_pattern NUMBER;
693: l_cur_suffix VARCHAR2 (2);
694: l_where_clause VARCHAR2 (2000);
695: l_mv VARCHAR2 (2000);
696: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
697: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
698: --l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
699: --l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
700:

Line 697: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

693: l_cur_suffix VARCHAR2 (2);
694: l_where_clause VARCHAR2 (2000);
695: l_mv VARCHAR2 (2000);
696: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
697: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
698: --l_to_date_xed CONSTANT VARCHAR2 (3) := 'XED';
699: --l_to_date_xtd CONSTANT VARCHAR2 (3) := 'XTD';
700:
701: l_rpt_specific_where VARCHAR2 (1000);

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

708:
709: BEGIN
710:
711: l_comparison_type := 'Y';
712: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
713: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
714: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
715: , p_view_by => l_view_by
716: , p_view_by_col_name => l_view_by_col

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

709: BEGIN
710:
711: l_comparison_type := 'Y';
712: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
713: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
714: OKI_DBI_UTIL_PVT.process_parameters ( p_param => p_param
715: , p_view_by => l_view_by
716: , p_view_by_col_name => l_view_by_col
717: , p_comparison_type => l_comparison_type

Line 741: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

737: ';
738:
739: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id,fact.date_signed';
740:
741: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
742: , p_col_name => 'price_negotiated_' || l_cur_suffix
743: , p_alias_name => 'act_value'
744: , p_prior_code => poa_dbi_util_pkg.no_priors);
745:

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

740:
741: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
742: , p_col_name => 'price_negotiated_' || l_cur_suffix
743: , p_alias_name => 'act_value'
744: , p_prior_code => poa_dbi_util_pkg.no_priors);
745:
746: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
747:
748: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl

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

742: , p_col_name => 'price_negotiated_' || l_cur_suffix
743: , p_alias_name => 'act_value'
744: , p_prior_code => poa_dbi_util_pkg.no_priors);
745:
746: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
747:
748: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl
749: , p_func_area => 'SRM'
750: , p_version => '6.0'