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

Line 45: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

41:
42: l_period_type VARCHAR2(10);
43: l_nested_pattern NUMBER;
44: l_cur_suffix VARCHAR2(2);
45: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
46: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
47: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
48: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
49:

Line 46: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

42: l_period_type VARCHAR2(10);
43: l_nested_pattern NUMBER;
44: l_cur_suffix VARCHAR2(2);
45: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
46: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
47: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
48: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
49:
50: l_where_clause1 VARCHAR2(2000);

Line 47: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

43: l_nested_pattern NUMBER;
44: l_cur_suffix VARCHAR2(2);
45: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
46: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
47: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
48: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
49:
50: l_where_clause1 VARCHAR2(2000);
51: l_where_clause2 VARCHAR2(2000);

Line 48: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

44: l_cur_suffix VARCHAR2(2);
45: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
46: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
47: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
48: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
49:
50: l_where_clause1 VARCHAR2(2000);
51: l_where_clause2 VARCHAR2(2000);
52: l_filter_where VARCHAR2(240);

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

86: l_to_date_xtd := 'XTD';
87: l_comparison_type := 'Y';
88: l_to_date_ytd := 'YTD';
89: l_to_date_itd := 'ITD';
90: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
91: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
92: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
93: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
94: l_ytd_sel_clause := '';

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

87: l_comparison_type := 'Y';
88: l_to_date_ytd := 'YTD';
89: l_to_date_itd := 'ITD';
90: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
91: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
92: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
93: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
94: l_ytd_sel_clause := '';
95:

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

88: l_to_date_ytd := 'YTD';
89: l_to_date_itd := 'ITD';
90: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
91: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
92: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
93: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
94: l_ytd_sel_clause := '';
95:
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param

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

89: l_to_date_itd := 'ITD';
90: l_join_tbl := POA_DBI_UTIL_PKG.Poa_Dbi_Join_Tbl ();
91: l_col_tbl1 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
92: l_col_tbl2 := POA_DBI_UTIL_PKG.Poa_Dbi_Col_Tbl ();
93: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
94: l_ytd_sel_clause := '';
95:
96: OKI_DBI_UTIL_PVT.Process_Parameters (p_param => p_param
97: , p_view_by => l_view_by

Line 120: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

116: -- Populate col table with regular columns
117:
118: -- Period Renewal node
119:
120: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
121: , p_col_name => 's_r_amt_' || l_cur_suffix
122: , p_alias_name => 'Scr'
123: , p_to_date_type => l_to_date_xed);
124:

Line 127: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

123: , p_to_date_type => l_to_date_xed);
124:
125:
126:
127: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
128: , p_col_name => 'c_scr_amt_' || l_cur_suffix
129: , p_alias_name => 'CScr'
130: , p_to_date_type => l_to_date_xed);
131:

Line 133: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

129: , p_alias_name => 'CScr'
130: , p_to_date_type => l_to_date_xed);
131:
132:
133: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
134: , p_col_name => 's_gpr_amt_'||l_period_type||'_' || l_cur_suffix
135: , p_alias_name => 'ScGpr'
136: , p_to_date_type => l_to_date_xed);
137:

Line 140: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

136: , p_to_date_type => l_to_date_xed);
137:
138:
139:
140: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
141: , p_col_name => 's_gpo_amt_'||l_period_type||'_' || l_cur_suffix
142: , p_alias_name => 'ScGpo'
143: , p_to_date_type => l_to_date_xed);
144:

Line 169: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

165: , p_mv_set => 'SRM_SG_71'
166:
167: , p_rg_where => 'Y');
168:
169: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
170: , p_col_name => 'g_scr_amt_'||l_period_type||'_' || l_cur_suffix
171: , p_alias_name => 'ScGr'
172: , p_to_date_type => l_to_date_xtd);
173:

Line 175: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

171: , p_alias_name => 'ScGr'
172: , p_to_date_type => l_to_date_xtd);
173:
174:
175: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
176: , p_col_name => 'g_sco_amt_'||l_period_type||'_' || l_cur_suffix
177: , p_alias_name => 'ScGo'
178: , p_to_date_type => l_to_date_xtd);
179:

Line 409: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset20.c_Rnw','oset20.C_Rnw_tot') || ' oki_measure_8 '||

405: ' , oset20.C_Upl oki_measure_6 '||
406:
407: ' , oset20.Upl_chg oki_measure_7 '||
408:
409: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset20.c_Rnw','oset20.C_Rnw_tot') || ' oki_measure_8 '||
410:
411:
412: ' , oset20.C_Rnw_tot oki_measure_11 '||
413:

Line 539: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr','oset13.c_Scr') || 'c_rnwl_Rate '||

535:
536:
537: ' , oset13.p_ScGpGo '||
538:
539: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr','oset13.c_Scr') || 'c_rnwl_Rate '||
540:
541: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr','oset13.p_Scr') || 'p_rnwl_Rate '||
542:
543: ' , oset13.CScr '||

Line 541: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr','oset13.p_Scr') || 'p_rnwl_Rate '||

537: ' , oset13.p_ScGpGo '||
538:
539: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr','oset13.c_Scr') || 'c_rnwl_Rate '||
540:
541: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr','oset13.p_Scr') || 'p_rnwl_Rate '||
542:
543: ' , oset13.CScr '||
544:
545: ' , oset13.c_Scr_tot '||

Line 558: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr_tot','oset13.c_Scr_tot') || ' c_rnwl_Rate_tot '||

554: ' , oset13.p_ScGpGr_tot '||
555:
556: ' , oset13.p_ScGpGo_tot '||
557:
558: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr_tot','oset13.c_Scr_tot') || ' c_rnwl_Rate_tot '||
559:
560: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr_tot','oset13.p_Scr_tot') || ' p_rnwl_Rate_tot '||
561:
562: ' , oset13.CScr_tot '||

Line 560: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr_tot','oset13.p_Scr_tot') || ' p_rnwl_Rate_tot '||

556: ' , oset13.p_ScGpGo_tot '||
557:
558: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr_tot','oset13.c_Scr_tot') || ' c_rnwl_Rate_tot '||
559:
560: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr_tot','oset13.p_Scr_tot') || ' p_rnwl_Rate_tot '||
561:
562: ' , oset13.CScr_tot '||
563:
564:

Line 700: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

696: l_curr_suffix VARCHAR2 (2);
697: l_where_clause VARCHAR2 (2000);
698: l_mv VARCHAR2 (2000);
699: l_additional_mv VARCHAR2 (2000);
700: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
701: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
702: l_to_date_xed VARCHAR2 (3) ;
703: l_to_date_xtd VARCHAR2 (3);
704:

Line 701: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

697: l_where_clause VARCHAR2 (2000);
698: l_mv VARCHAR2 (2000);
699: l_additional_mv VARCHAR2 (2000);
700: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
701: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
702: l_to_date_xed VARCHAR2 (3) ;
703: l_to_date_xtd VARCHAR2 (3);
704:
705: l_rpt_specific_where VARCHAR2 (1000);

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

712:
713: l_to_date_xed := 'XED';
714: l_to_date_xtd := 'XTD';
715: l_comparison_type := 'Y';
716: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
717: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
718:
719: oki_dbi_util_pvt.process_parameters ( p_param => p_param
720: , p_view_by => l_view_by

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

713: l_to_date_xed := 'XED';
714: l_to_date_xtd := 'XTD';
715: l_comparison_type := 'Y';
716: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
717: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
718:
719: oki_dbi_util_pvt.process_parameters ( p_param => p_param
720: , p_view_by => l_view_by
721: , p_view_by_col_name => l_view_by_col

Line 747: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

743: AND fact.date_signed <= &BIS_CURRENT_ASOF_DATE';
744:
745: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id,fact.date_signed';
746:
747: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
748: , p_col_name => 'price_negotiated_' || l_curr_suffix
749: , p_alias_name => 'affected_value'
750: , p_prior_code => poa_dbi_util_pkg.no_priors);
751:

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

746:
747: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
748: , p_col_name => 'price_negotiated_' || l_curr_suffix
749: , p_alias_name => 'affected_value'
750: , p_prior_code => poa_dbi_util_pkg.no_priors);
751:
752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
753:
754: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl

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

748: , p_col_name => 'price_negotiated_' || l_curr_suffix
749: , p_alias_name => 'affected_value'
750: , p_prior_code => poa_dbi_util_pkg.no_priors);
751:
752: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
753:
754: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl
755: , p_func_area => 'SRM'
756: , p_version => '6.0'

Line 940: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

936: l_cur_suffix VARCHAR2 (22);
937: l_where_clause VARCHAR2 (20000);
938:
939: l_mv VARCHAR2 (2000);
940: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
941: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
942: l_to_date_xed VARCHAR2 (3);
943: l_to_date_xtd VARCHAR2 (3);
944: l_view_by_table VARCHAR2(10000);

Line 941: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

937: l_where_clause VARCHAR2 (20000);
938:
939: l_mv VARCHAR2 (2000);
940: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
941: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
942: l_to_date_xed VARCHAR2 (3);
943: l_to_date_xtd VARCHAR2 (3);
944: l_view_by_table VARCHAR2(10000);
945:

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

957:
958: l_to_date_xed := 'XED';
959: l_to_date_xtd := 'XTD';
960: l_comparison_type := 'Y';
961: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
962: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
963:
964:
965: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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

958: l_to_date_xed := 'XED';
959: l_to_date_xtd := 'XTD';
960: l_comparison_type := 'Y';
961: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
962: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
963:
964:
965: oki_dbi_util_pvt.process_parameters ( p_param => p_param
966:

Line 1169: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

1165: l_dim_bmap NUMBER;
1166: l_cur_suffix VARCHAR2 (2);
1167: l_custom_sql VARCHAR2 (10000);
1168:
1169: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1170: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1171: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1172:
1173: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 1170: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

1166: l_cur_suffix VARCHAR2 (2);
1167: l_custom_sql VARCHAR2 (10000);
1168:
1169: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1170: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1171: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1172:
1173: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
1174:

Line 1171: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

1167: l_custom_sql VARCHAR2 (10000);
1168:
1169: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1170: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1171: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1172:
1173: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
1174:
1175: l_period_code varchar2(1);

Line 1173: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

1169: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
1170: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
1171: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
1172:
1173: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
1174:
1175: l_period_code varchar2(1);
1176: l_where_clause1 VARCHAR2 (2000);
1177: l_where_clause2 VARCHAR2 (2000);

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

1191: l_comparison_type := 'Y';
1192: /* DEBUG
1193: OKI_DBIDEBUG_PVT.check_portal_param('OKI_DBI_SRG',p_param);
1194: */
1195: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1196: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1197:
1198: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1199:

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

1192: /* DEBUG
1193: OKI_DBIDEBUG_PVT.check_portal_param('OKI_DBI_SRG',p_param);
1194: */
1195: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1196: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1197:
1198: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1199:
1200: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

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

1194: */
1195: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1196: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1197:
1198: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1199:
1200: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
1201:
1202: oki_dbi_util_pvt.process_parameters (p_param => p_param

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

1196: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1197:
1198: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1199:
1200: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
1201:
1202: oki_dbi_util_pvt.process_parameters (p_param => p_param
1203: , p_view_by => l_view_by
1204: , p_view_by_col_name => l_view_by_col

Line 1221: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

1217: , p_version => '6.0'
1218: , p_role => NULL
1219: , p_mv_set => 'SRM_ST_71'
1220: , p_rg_where => 'Y');
1221: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
1222: , p_col_name => 's_r_amt_' || l_cur_suffix
1223: , p_alias_name => 's_r_amt_xed'
1224: , p_grand_total => 'N'
1225: , p_to_date_type => 'XED');

Line 1226: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

1222: , p_col_name => 's_r_amt_' || l_cur_suffix
1223: , p_alias_name => 's_r_amt_xed'
1224: , p_grand_total => 'N'
1225: , p_to_date_type => 'XED');
1226: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
1227: , p_col_name => 's_gpr_amt_' || l_period_code || '_' || l_cur_suffix
1228: , p_alias_name => 's_gpr_amt_xed'
1229:
1230: , p_grand_total => 'N'

Line 1232: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

1228: , p_alias_name => 's_gpr_amt_xed'
1229:
1230: , p_grand_total => 'N'
1231: , p_to_date_type => 'XED');
1232: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
1233: , p_col_name => 's_gpo_amt_'|| l_period_code || '_' || l_cur_suffix
1234: , p_alias_name => 's_gpo_amt_xed'
1235: , p_grand_total => 'N'
1236: , p_to_date_type => 'XED');

Line 1259: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

1255: , p_mv_set => 'SRM_SG_71'
1256: , p_rg_where => 'Y');
1257:
1258:
1259: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
1260: , p_col_name => 'g_scr_amt_' || l_period_code || '_' || l_cur_suffix
1261: , p_alias_name => 'g_scr_amt_xtd'
1262: , p_grand_total => 'N'
1263: , p_to_date_type => 'XTD');

Line 1264: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

1260: , p_col_name => 'g_scr_amt_' || l_period_code || '_' || l_cur_suffix
1261: , p_alias_name => 'g_scr_amt_xtd'
1262: , p_grand_total => 'N'
1263: , p_to_date_type => 'XTD');
1264: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
1265: , p_col_name => 'g_sco_amt_' || l_period_code || '_' || l_cur_suffix
1266: , p_alias_name => 'g_sco_amt_xtd'
1267: , p_grand_total => 'N'
1268: , p_to_date_type => 'XTD');