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_EXP_PVT dependencies on OKI_DBI_UTIL_PVT

Line 61: oki_dbi_util_pvt.process_parameters ( p_param => p_param

57: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
58: l_comparison_type := 'Y';
59:
60:
61: oki_dbi_util_pvt.process_parameters ( p_param => p_param
62: , p_view_by => l_view_by
63: , p_view_by_col_name => l_view_by_col
64: , p_comparison_type => l_comparison_type
65: , p_xtd => l_xtd

Line 129: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

125: , p_use_grpid => 'N'
126: , p_paren_count => 7);
127:
128: x_custom_sql := l_query;
129: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
130:
131: END get_expirations_sql;
132:
133:

Line 168: oki_dbi_util_pvt.process_parameters ( p_param => p_param

164: l_comparison_type := 'Y';
165:
166:
167:
168: oki_dbi_util_pvt.process_parameters ( p_param => p_param
169: , p_view_by => l_view_by
170: , p_view_by_col_name => l_view_by_col
171: , p_comparison_type => l_comparison_type
172: , p_xtd => l_xtd

Line 233: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

229: , p_use_grpid => 'N'
230: , p_paren_count => 7);
231:
232: x_custom_sql := l_query;
233: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
234:
235: END get_period_expiring_sql;
236:
237: /*

Line 289: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM_EN_71', '6.0');

285:
286: */
287:
288:
289: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM_EN_71', '6.0');
290:
291: -- Drill Across URL when view by is Salesrep and Product
292: l_Xg_url := '''pFunctionName=OKI_DBI_SCM_EXP_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&OKI_STATUS+EXP_TYPE=1''';
293: l_Xo_url := '''pFunctionName=OKI_DBI_SCM_EXP_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&OKI_STATUS+EXP_TYPE=2''';

Line 392: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X','oset15.p_X','NP') || ' X_chg '||

388: ' , oset15.c_X c_X '||
389: ' , oset15.p_X p_X '||
390: ' , oset15.c_X_tot c_X_tot '||
391: ' , oset15.p_X_tot p_X_tot '||
392: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X','oset15.p_X','NP') || ' X_chg '||
393: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
394: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_X','oset15.c_X_tot') || ' c_X_per '||
395: ' , oset15.c_Xg c_Xg '||
396: ' , oset15.c_Xg_tot c_Xg_tot '||

Line 393: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||

389: ' , oset15.p_X p_X '||
390: ' , oset15.c_X_tot c_X_tot '||
391: ' , oset15.p_X_tot p_X_tot '||
392: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X','oset15.p_X','NP') || ' X_chg '||
393: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
394: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_X','oset15.c_X_tot') || ' c_X_per '||
395: ' , oset15.c_Xg c_Xg '||
396: ' , oset15.c_Xg_tot c_Xg_tot '||
397: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xg','oset15.c_X') || ' c_Xg_per '||

Line 490: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM_EN_71', '6.0');

486: l_url_select VARCHAR2(32767);
487: BEGIN
488:
489:
490: l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM_EN_71', '6.0');
491:
492: -- Drill Across URL when view by is Salesrep and Product
493: l_Xg_url := '''pFunctionName=OKI_DBI_SCM_PEX_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&OKI_STATUS+EXP_TYPE=1''';
494: l_Xo_url := '''pFunctionName=OKI_DBI_SCM_PEX_DTL_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&OKI_STATUS+EXP_TYPE=2''';

Line 570: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X','oset15.p_X','NP') || ' X_chg '||

566: ' , oset15.c_X c_X '||
567: ' , oset15.p_X p_X '||
568: ' , oset15.c_X_tot c_X_tot '||
569: ' , oset15.p_X_tot p_X_tot '||
570: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X','oset15.p_X','NP') || ' X_chg '||
571: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
572: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_X','oset15.c_X_tot') || ' c_X_per '||
573: ' , oset15.c_Xg c_Xg '||
574: ' , oset15.c_Xg_tot c_Xg_tot '||

Line 571: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||

567: ' , oset15.p_X p_X '||
568: ' , oset15.c_X_tot c_X_tot '||
569: ' , oset15.p_X_tot p_X_tot '||
570: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X','oset15.p_X','NP') || ' X_chg '||
571: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
572: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_X','oset15.c_X_tot') || ' c_X_per '||
573: ' , oset15.c_Xg c_Xg '||
574: ' , oset15.c_Xg_tot c_Xg_tot '||
575: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xg','oset15.c_X') || ' c_Xg_per '||

Line 717: oki_dbi_util_pvt.process_parameters ( p_param => p_param

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

Line 749: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl

745: l_group_by := ' GROUP BY fact.chr_id, fact.customer_party_id, fact.resource_id,fact.date_signed';
746:
747: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
748:
749: OKI_DBI_UTIL_PVT.join_rpt_where (p_join_tbl => l_join_tbl
750: , p_func_area => 'SRM'
751: , p_version => '6.0'
752: , p_role => NULL
753: , p_mv_set => 'SRM_CDTL_RPT');

Line 759: l_exp_type := NVL(OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+EXP_TYPE'),'''All''');

755: l_filter_where := ' ( ABS(oki_measure_2) ) <> 0 ';
756: l_additional_mv := ' ) fact
757: , OKI_SCM_OCR_MV k
758: WHERE fact.chr_id = k.chr_id) ';
759: l_exp_type := NVL(OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+EXP_TYPE'),'''All''');
760:
761: if l_exp_type = '''All''' then
762: l_exp_type_filter:=' AND exp_renewal_flag <> 0';
763: else

Line 786: OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);

782: , p_group_by => l_group_by
783: , p_from_clause => 'from '||l_mv ||' fact ');
784: x_custom_sql := l_query;
785:
786: OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);
787:
788: /* l_columns := ', sum(price_negotiated_' || l_cur_suffix || ' + ubt_amt_' || l_cur_suffix ||
789: ' + supp_credit_' || l_cur_suffix || ' + credit_amt_' || l_cur_suffix || ' ) affected_value,
790: sum(sum(price_negotiated_' || l_cur_suffix || ' + ubt_amt_' || l_cur_suffix ||

Line 813: -- OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);

809: -- l_query := get_exp_detail_sel_clause (l_cur_suffix, l_period_type, l_exp_type ) || l_columns
810: -- ||l_where_clause || l_rpt_specific_where ||l_group_by ||l_filter_where||l_additional_where;
811:
812: -- x_custom_sql := l_query;
813: -- OKI_DBI_UTIL_PVT.get_custom_status_binds (x_custom_output);
814:
815: END get_expirations_detail_sql;
816:
817: FUNCTION get_exp_detail_sel_clause (

Line 915: oki_dbi_util_pvt.process_parameters ( p_param => p_param

911:
912: l_comparison_type := 'Y';
913: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
914: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
915: oki_dbi_util_pvt.process_parameters ( p_param => p_param
916: , p_view_by => l_view_by
917: , p_view_by_col_name => l_view_by_col
918: , p_comparison_type => l_comparison_type
919: , p_xtd => l_xtd

Line 935: l_exp_type := OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+EXP_TYPE');

931: , p_role => NULL
932: , p_mv_set => 'SRM_CDTL_RPT'
933: , p_rg_where => 'Y');
934:
935: l_exp_type := OKI_DBI_UTIL_PVT.get_param_id(p_param,'OKI_STATUS+EXP_TYPE');
936:
937: SELECT DECODE (l_exp_type, '''1''', 2, '''2''', 1,'''3''', 4,'''4''', 8) INTO l_exp_renewal_flag FROM DUAL;
938:
939:

Line 965: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl

961:
962: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
963:
964:
965: oki_dbi_util_pvt.join_rpt_where (p_join_tbl => l_join_tbl
966: , p_func_area => 'SRM'
967: , p_version => '6.0'
968: , p_role => NULL
969: , p_mv_set => 'SRM_CDTL_RPT');

Line 986: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

982: , p_from_clause => ' from '||l_mv ||' fact ');
983: x_custom_sql := l_query;
984:
985:
986: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
987:
988: END get_prd_exp_cont_dtl_sql;
989:
990: /*Added by Arun for Perido Expiring Contracts Detail*/

Line 1079: oki_dbi_util_pvt.process_parameters ( p_param => p_param

1075: l_comparison_type := 'Y';
1076: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
1077: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
1078:
1079: oki_dbi_util_pvt.process_parameters ( p_param => p_param
1080: , p_view_by => l_view_by
1081: , p_view_by_col_name => l_view_by_col
1082: , p_comparison_type => l_comparison_type
1083: , p_xtd => l_xtd

Line 1126: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'XTD','N')

1122:
1123: l_query :=
1124: get_expdist_sel_clause
1125: || ' from ( select 1 '
1126: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'XTD','N')
1127: || oki_dbi_util_pvt.get_xtd_where(l_mv, 'N', 'XTD')
1128: || l_where_clause
1129: || ') oset05) oset10) oset15) oset20) oset '
1130: || ' , fnd_lookups l

Line 1127: || oki_dbi_util_pvt.get_xtd_where(l_mv, 'N', 'XTD')

1123: l_query :=
1124: get_expdist_sel_clause
1125: || ' from ( select 1 '
1126: || oki_dbi_util_pvt.get_nested_cols(l_col_tbl,'XTD','N')
1127: || oki_dbi_util_pvt.get_xtd_where(l_mv, 'N', 'XTD')
1128: || l_where_clause
1129: || ') oset05) oset10) oset15) oset20) oset '
1130: || ' , fnd_lookups l
1131: WHERE l.lookup_type = ''OKI_EXP_TYPE''

Line 1136: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);

1132: ORDER BY lookup_code ';
1133:
1134:
1135: x_custom_sql := l_query;
1136: oki_dbi_util_pvt.get_custom_status_binds (x_custom_output);
1137:
1138: END get_exp_dist_sql;
1139:
1140: /*********************************************************************

Line 1195: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xg_per_tot','oset20.p_Xg_per_tot','P') || ' Xg_perchg_tot '||

1191: ' , oset20.c_Xo_per_tot c_Xo_per_tot '||
1192: ' , oset20.c_Xc_per_tot c_Xc_per_tot '||
1193: ' , oset20.c_Xd_per_tot c_Xd_per_tot '||
1194: ' , oset20.X_per_tot X_per_tot '||
1195: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xg_per_tot','oset20.p_Xg_per_tot','P') || ' Xg_perchg_tot '||
1196: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xo_per_tot','oset20.p_Xo_per_tot','P') || ' Xo_perchg_tot '||
1197: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xc_per_tot','oset20.p_Xc_per_tot','P') || ' Xc_perchg_tot '||
1198: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xd_per_tot','oset20.p_Xd_per_tot','P') || ' Xd_perchg_tot '||
1199: ' from '||

Line 1196: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xo_per_tot','oset20.p_Xo_per_tot','P') || ' Xo_perchg_tot '||

1192: ' , oset20.c_Xc_per_tot c_Xc_per_tot '||
1193: ' , oset20.c_Xd_per_tot c_Xd_per_tot '||
1194: ' , oset20.X_per_tot X_per_tot '||
1195: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xg_per_tot','oset20.p_Xg_per_tot','P') || ' Xg_perchg_tot '||
1196: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xo_per_tot','oset20.p_Xo_per_tot','P') || ' Xo_perchg_tot '||
1197: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xc_per_tot','oset20.p_Xc_per_tot','P') || ' Xc_perchg_tot '||
1198: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xd_per_tot','oset20.p_Xd_per_tot','P') || ' Xd_perchg_tot '||
1199: ' from '||
1200: ' (select '||

Line 1197: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xc_per_tot','oset20.p_Xc_per_tot','P') || ' Xc_perchg_tot '||

1193: ' , oset20.c_Xd_per_tot c_Xd_per_tot '||
1194: ' , oset20.X_per_tot X_per_tot '||
1195: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xg_per_tot','oset20.p_Xg_per_tot','P') || ' Xg_perchg_tot '||
1196: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xo_per_tot','oset20.p_Xo_per_tot','P') || ' Xo_perchg_tot '||
1197: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xc_per_tot','oset20.p_Xc_per_tot','P') || ' Xc_perchg_tot '||
1198: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xd_per_tot','oset20.p_Xd_per_tot','P') || ' Xd_perchg_tot '||
1199: ' from '||
1200: ' (select '||
1201: ' oset15.c_Xg_tot '||

Line 1198: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xd_per_tot','oset20.p_Xd_per_tot','P') || ' Xd_perchg_tot '||

1194: ' , oset20.X_per_tot X_per_tot '||
1195: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xg_per_tot','oset20.p_Xg_per_tot','P') || ' Xg_perchg_tot '||
1196: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xo_per_tot','oset20.p_Xo_per_tot','P') || ' Xo_perchg_tot '||
1197: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xc_per_tot','oset20.p_Xc_per_tot','P') || ' Xc_perchg_tot '||
1198: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset20.c_Xd_per_tot','oset20.p_Xd_per_tot','P') || ' Xd_perchg_tot '||
1199: ' from '||
1200: ' (select '||
1201: ' oset15.c_Xg_tot '||
1202: ' , oset15.c_Xo_tot '||

Line 1206: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||

1202: ' , oset15.c_Xo_tot '||
1203: ' , oset15.c_Xc_tot '||
1204: ' , oset15.c_Xd_tot '||
1205: ' , oset15.c_X_tot '||
1206: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
1207: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xg_tot','oset15.p_Xg_tot','NP') || ' Xg_chg_tot '||
1208: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xo_tot','oset15.p_Xo_tot','NP') || ' Xo_chg_tot '||
1209: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xc_tot','oset15.p_Xc_tot','NP') || ' Xc_chg_tot '||
1210: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xd_tot','oset15.p_Xd_tot','NP') || ' Xd_chg_tot '||

Line 1207: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xg_tot','oset15.p_Xg_tot','NP') || ' Xg_chg_tot '||

1203: ' , oset15.c_Xc_tot '||
1204: ' , oset15.c_Xd_tot '||
1205: ' , oset15.c_X_tot '||
1206: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
1207: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xg_tot','oset15.p_Xg_tot','NP') || ' Xg_chg_tot '||
1208: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xo_tot','oset15.p_Xo_tot','NP') || ' Xo_chg_tot '||
1209: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xc_tot','oset15.p_Xc_tot','NP') || ' Xc_chg_tot '||
1210: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xd_tot','oset15.p_Xd_tot','NP') || ' Xd_chg_tot '||
1211: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xg_tot','oset15.c_X_tot') || ' c_Xg_per_tot '||

Line 1208: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xo_tot','oset15.p_Xo_tot','NP') || ' Xo_chg_tot '||

1204: ' , oset15.c_Xd_tot '||
1205: ' , oset15.c_X_tot '||
1206: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
1207: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xg_tot','oset15.p_Xg_tot','NP') || ' Xg_chg_tot '||
1208: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xo_tot','oset15.p_Xo_tot','NP') || ' Xo_chg_tot '||
1209: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xc_tot','oset15.p_Xc_tot','NP') || ' Xc_chg_tot '||
1210: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xd_tot','oset15.p_Xd_tot','NP') || ' Xd_chg_tot '||
1211: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xg_tot','oset15.c_X_tot') || ' c_Xg_per_tot '||
1212: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xo_tot','oset15.c_X_tot') || ' c_Xo_per_tot '||

Line 1209: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xc_tot','oset15.p_Xc_tot','NP') || ' Xc_chg_tot '||

1205: ' , oset15.c_X_tot '||
1206: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
1207: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xg_tot','oset15.p_Xg_tot','NP') || ' Xg_chg_tot '||
1208: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xo_tot','oset15.p_Xo_tot','NP') || ' Xo_chg_tot '||
1209: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xc_tot','oset15.p_Xc_tot','NP') || ' Xc_chg_tot '||
1210: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xd_tot','oset15.p_Xd_tot','NP') || ' Xd_chg_tot '||
1211: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xg_tot','oset15.c_X_tot') || ' c_Xg_per_tot '||
1212: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xo_tot','oset15.c_X_tot') || ' c_Xo_per_tot '||
1213: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xc_tot','oset15.c_X_tot') || ' c_Xc_per_tot '||

Line 1210: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xd_tot','oset15.p_Xd_tot','NP') || ' Xd_chg_tot '||

1206: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_X_tot','oset15.p_X_tot','NP') || ' X_chg_tot '||
1207: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xg_tot','oset15.p_Xg_tot','NP') || ' Xg_chg_tot '||
1208: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xo_tot','oset15.p_Xo_tot','NP') || ' Xo_chg_tot '||
1209: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xc_tot','oset15.p_Xc_tot','NP') || ' Xc_chg_tot '||
1210: ' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Xd_tot','oset15.p_Xd_tot','NP') || ' Xd_chg_tot '||
1211: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xg_tot','oset15.c_X_tot') || ' c_Xg_per_tot '||
1212: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xo_tot','oset15.c_X_tot') || ' c_Xo_per_tot '||
1213: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xc_tot','oset15.c_X_tot') || ' c_Xc_per_tot '||
1214: ' ,'||POA_DBI_UTIL_PKG.rate_clause('oset15.c_Xd_tot','oset15.c_X_tot') || ' c_Xd_per_tot '||