[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Period Renewal Summary Select clause
*/
FUNCTION get_table_sel_clause (
p_view_by_dim IN VARCHAR2
, p_view_by_col IN VARCHAR2)
RETURN VARCHAR2
IS
l_sel_clause VARCHAR2 (32767);
l_viewby_select VARCHAR2(32767);
l_url_select VARCHAR2(32767);
l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(p_view_by_dim, 'SRM', '6.0');
l_viewby_select := l_viewby_select ||
',OKI_DYNAMIC_URL_1
,OKI_DYNAMIC_URL_2
,' ||l_prodcat_url || '
,oki_measure_1
,oki_measure_2
,oki_measure_3
,oki_measure_4
,oki_measure_5
,oki_measure_6
,oki_measure_7
,oki_measure_8
,oki_measure_11
,oki_measure_12
,oki_measure_13
,oki_measure_14
,oki_measure_15
,oki_measure_16
,oki_measure_17
,oki_measure_18
,oki_measure_23
,oki_measure_26
,oki_calc_item1
,oki_calc_item2
,oki_calc_item3
,oki_calc_item4
,oki_calc_item5
,oki_calc_item6
,oki_calc_item7
,oki_calc_item8
,oki_calc_item11
,oki_calc_item12
,oki_calc_item13
,oki_calc_item14
,oki_calc_item15
,oki_calc_item16
,oki_calc_item17
,oki_calc_item18
FROM (
SELECT
rank() over (&ORDER_BY_CLAUSE nulls last , '||p_view_by_col||') - 1 rnk
,'||p_view_by_col||'
,OKI_DYNAMIC_URL_1
,OKI_DYNAMIC_URL_2
,oki_measure_1
,oki_measure_2
,oki_measure_3
,oki_measure_4
,oki_measure_5
,oki_measure_6
,oki_measure_7
,oki_measure_8
,oki_measure_11
,oki_measure_12
,oki_measure_13
,oki_measure_14
,oki_measure_15
,oki_measure_16
,oki_measure_17
,sum(oki_measure_8) over() oki_measure_18
,oki_measure_23
,oki_measure_26
,oki_calc_item1
,oki_calc_item2
,oki_calc_item3
,oki_calc_item4
,oki_calc_item5
,oki_calc_item6
,oki_calc_item7
,oki_calc_item8
,oki_calc_item11
,oki_calc_item12
,oki_calc_item13
,oki_calc_item14
,oki_calc_item15
,oki_calc_item16
,oki_calc_item17
,oki_calc_item18
FROM ( ';
l_url_select :=
'SELECT decode(resource_id,-999,''pFunctionName=OKI_DBI_SRM_PRNWL_SUM_RPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&VIEW_BY=ORGANIZATION+JTF_ORG_SALES_GROUP'','''') OKI_DYNAMIC_URL_1 '||
' , decode(resource_id,-999,'''',decode(rg_id,-1,'''','||l_bookings_url||')) OKI_DYNAMIC_URL_2 ';
l_url_select :=
'SELECT '''' OKI_DYNAMIC_URL_1 '||
' , '||l_bookings_url||' OKI_DYNAMIC_URL_2 ';
l_url_select :=
'SELECT '''' OKI_DYNAMIC_URL_1 '||
' , '''' OKI_DYNAMIC_URL_2 ';
l_sel_clause := l_viewby_select || l_url_select ||
' ,'|| p_view_by_col ||
' , oset20.c_Rnw oki_measure_1 '||
' , oset20.c_Bkg oki_measure_2 '||
' , oset20.c_rnwl_rate oki_measure_3 '||
' , oset20.rnwl_rate_chg oki_measure_4 '||
' , oset20.Can oki_measure_5 '||
' , oset20.C_Upl oki_measure_6 '||
' , oset20.Upl_chg oki_measure_7 '||
' ,'||POA_DBI_UTIL_PKG.rate_clause('oset20.c_Rnw','oset20.C_Rnw_tot') || ' oki_measure_8 '||
' , oset20.C_Rnw_tot oki_measure_11 '||
' , oset20.C_Bkg_tot oki_measure_12 '||
' , oset20.C_rnwl_rate_tot oki_measure_13 '||
' , oset20.rnwl_rate_chg_tot oki_measure_14 '||
' , oset20.Can_tot oki_measure_15 '||
' , oset20.C_Upl_tot oki_measure_16 '||
' , oset20.Upl_chg_tot oki_measure_17 '||
' , oset20.p_rnwl_rate oki_measure_23 '||
' , oset20.P_Upl oki_measure_26 '||
' , oset20.c_Rnw oki_calc_item1 '||
' , oset20.c_Rnw_tot oki_calc_item11 '||
' , oset20.P_Rnw oki_calc_item2 '||
' , oset20.P_Rnw_tot oki_calc_item12 '||
' , oset20.C_Bkg oki_calc_item3 '||
' , oset20.C_Bkg_tot oki_calc_item13 '||
' , oset20.P_Bkg oki_calc_item4 '||
' , oset20.P_Bkg_tot oki_calc_item14 '||
' , oset20.C_rnwl_rate oki_calc_item5 '||
' , oset20.C_rnwl_rate_tot oki_calc_item15 '||
' , oset20.P_rnwl_rate oki_calc_item6 '||
' , oset20.P_rnwl_rate_tot oki_calc_item16 '||
' , oset20.C_Upl oki_calc_item7 '||
' , oset20.C_Upl_tot oki_calc_item17 '||
' , oset20.P_Upl oki_calc_item8 '||
' , oset20.P_Upl_tot oki_calc_item18 '||
' from '||
' ( select '||
' '|| p_view_by_col ||
' , oset15.c_Scr c_Rnw '||
' , oset15.p_Scr p_Rnw '||
' , oset15.c_ScGpGr c_Bkg '||
' , oset15.p_ScGpGr p_Bkg '||
' , oset15.c_rnwl_Rate c_rnwl_rate '||
' , oset15.p_rnwl_Rate p_rnwl_rate '||
' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_rnwl_Rate','oset15.p_rnwl_Rate','P') || ' rnwl_rate_chg '||
' , oset15.CScr Can '||
' , oset15.c_Upl c_Upl '||
' , oset15.p_Upl P_Upl '||
' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Upl','oset15.p_Upl','NP') || ' Upl_chg '||
' , oset15.c_Scr_tot C_Rnw_tot '||
' , oset15.p_Scr_tot P_Rnw_tot '||
' , oset15.c_ScGpGr_tot C_Bkg_tot '||
' , oset15.p_ScGpGr_tot P_Bkg_tot '||
' , oset15.c_rnwl_Rate_tot C_rnwl_rate_tot '||
' , oset15.p_rnwl_Rate_tot P_rnwl_rate_tot '||
' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_rnwl_Rate_tot','oset15.p_rnwl_Rate_tot','P') || ' rnwl_rate_chg_tot '||
' , oset15.CScr_tot Can_tot '||
' , oset15.c_Upl_tot C_Upl_tot '||
' , oset15.p_Upl_tot P_Upl_tot '||
' ,'||OKI_DBI_UTIL_PVT.change_clause('oset15.c_Upl_tot','oset15.p_Upl_tot','NP') || ' Upl_chg_tot '||
' from '||
' (select '||
p_view_by_col ||
' , oset13.c_Scr '||
' , oset13.p_Scr '||
' , oset13.c_ScGpGr '||
' , oset13.c_ScGpGo '||
' , oset13.p_ScGpGr '||
' , oset13.p_ScGpGo '||
' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr','oset13.c_Scr') || 'c_rnwl_Rate '||
' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr','oset13.p_Scr') || 'p_rnwl_Rate '||
' , oset13.CScr '||
' , oset13.c_Scr_tot '||
' , oset13.p_Scr_tot '||
' , oset13.c_ScGpGr_tot '||
' , oset13.c_ScGpGo_tot '||
' , oset13.p_ScGpGr_tot '||
' , oset13.p_ScGpGo_tot '||
' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.c_ScGpGr_tot','oset13.c_Scr_tot') || ' c_rnwl_Rate_tot '||
' ,'||POA_DBI_UTIL_PKG.rate_clause('oset13.p_ScGpGr_tot','oset13.p_Scr_tot') || ' p_rnwl_Rate_tot '||
' , oset13.CScr_tot '||
' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr','oset13.c_ScGpGo') ||' c_Upl '||
' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr','oset13.p_ScGpGo') ||' p_Upl '||
' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.c_ScGpGr_tot','oset13.c_ScGpGo_tot') ||' c_Upl_tot '||
' ,'|| OKI_DBI_UTIL_PVT.subtract_measures('oset13.p_ScGpGr_tot','oset13.p_ScGpGo_tot') ||' p_Upl_tot '||
' from '||
' (select '||
-- For use in where condition to join to the dimension table
p_view_by_col ||
' , oset10.c_Scr c_Scr '||
' , oset10.p_Scr p_Scr '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr','oset10.c_ScGr') ||' c_ScGpGr '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo','oset10.c_ScGo') ||' c_ScGpGo '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr','oset10.p_ScGr') ||' p_ScGpGr '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo','oset10.p_ScGo') ||' p_ScGpGo '||
' , oset10.c_CScr CScr '||
' , oset10.c_Scr_tot c_Scr_tot '||
' , oset10.p_Scr_tot p_Scr_tot '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpr_tot','oset10.c_ScGr_tot') ||' c_ScGpGr_tot '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.c_ScGpo_tot','oset10.c_ScGo_tot') ||' c_ScGpGo_tot '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpr_tot','oset10.p_ScGr_tot') ||' p_ScGpGr_tot '||
' ,'|| OKI_DBI_UTIL_PVT.add_measures('oset10.p_ScGpo_tot','oset10.p_ScGo_tot') ||' p_ScGpGo_tot '||
' , oset10.c_CScr_tot CScr_tot '||
' from '||
' ( select '||
' oset05.'||p_view_by_col ||
' , nvl(oset05.c_Scr,0) c_Scr '||
' , nvl(oset05.c_CScr,0) c_CScr '||
' , nvl(oset05.c_ScGpr,0) c_ScGpr '||
' , nvl(oset05.c_ScGpo,0) c_ScGpo '||
' , nvl(oset05.c_ScGr,0) c_ScGr '||
' , nvl(oset05.c_ScGo,0) c_ScGo '||
' , nvl(oset05.p_Scr,0) p_Scr '||
' , nvl(oset05.p_CScr,0) p_CScr '||
' , nvl(oset05.p_ScGpr,0) p_ScGpr '||
' , nvl(oset05.p_ScGpo,0) p_ScGpo '||
' , nvl(oset05.p_ScGr,0) p_ScGr '||
' , nvl(oset05.p_ScGo,0) p_ScGo '||
' , nvl(oset05.c_Scr_total,0) c_Scr_tot '||
' , nvl(oset05.c_CScr_total,0) c_CScr_tot '||
' , nvl(oset05.c_ScGpr_total,0) c_ScGpr_tot '||
' , nvl(oset05.c_ScGpo_total,0) c_ScGpo_tot '||
' , nvl(oset05.c_ScGr_total,0) c_ScGr_tot '||
' , nvl(oset05.c_ScGo_total,0) c_ScGo_tot '||
' , nvl(oset05.p_Scr_total,0) p_Scr_tot '||
' , nvl(oset05.p_CScr_total,0) p_CScr_tot '||
' , nvl(oset05.p_ScGpr_total,0) p_ScGpr_tot '||
' , nvl(oset05.p_ScGpo_total,0) p_ScGpo_tot '||
' , nvl(oset05.p_ScGr_total,0) p_ScGr_tot '||
' , nvl(oset05.p_ScGo_total,0) p_ScGo_tot ';
'SELECT
complete_k_number oki_attribute_1
, cust.value oki_attribute_2
, DECODE(fact.resource_id,-1,&UNASSIGNED,rsex.resource_name) oki_attribute_3
, to_char(date_signed) OKI_DATE_1
, to_char(start_date) OKI_DATE_2
, to_char(end_date) OKI_DATE_3
, oki_measure_1
, OKI_MEASURE_2
, oki_measure_11
, OKI_MEASURE_12
, fact.chr_id OKI_ATTRIBUTE_5
FROM
(
SELECT * FROM
((
SELECT
fact.*
, k.complete_k_number
, k.start_date start_date
, k.end_date end_date
, NVL(k.price_nego_' ||p_cur_suffix ||',0) OKI_MEASURE_2
, NVL(SUM(k.price_nego_' ||p_cur_suffix ||') over (),0) OKI_MEASURE_12
FROM
(
SELECT rank() over (ORDER BY OKI_MEASURE_1 DESC nulls last) - 1 rnk
, chr_id
, customer_party_id
, resource_id
, oki_measure_1
, oki_measure_11
, date_signed
FROM
(
SELECT oset5.chr_id
, oset5.customer_party_id
, oset5.resource_id
, nvl(oset5.affected_value,0) OKI_MEASURE_1
, nvl(oset5.affected_value_total,0) OKI_MEASURE_11
, oset5.date_signed
FROM
(
SELECT fact.chr_id, fact.customer_party_id , fact.resource_id,fact.date_signed';
* the user selects in the report
* x_custom_sql -->the final SQL query that is generated
* x_custom_output -->contains the bind variables
*/
/*******************************************************************************
* FUNCTION get_bkngs_by_cust_sql () returns the select clause containing
the measures for the report
********************************************************************************/
/*
FUNCTION get_bkngs_by_cust_sel_clause
RETURN VARCHAR2
IS
l_query VARCHAR2(10000);
* the user selects in the report
* x_custom_sql -->the final SQL query that is generated
* x_custom_output -->contains the bind variables
*/
PROCEDURE get_bkngs_by_cust_sql (
p_param IN bis_pmv_page_parameter_tbl
, x_custom_sql OUT NOCOPY VARCHAR2
, x_custom_output OUT NOCOPY bis_query_attributes_tbl)
IS
l_query VARCHAR2 (32767);
* FUNCTION get_bkngs_by_cust_sql () returns the select clause containing
the measures for the report
********************************************************************************/
/*
FUNCTION get_bkngs_by_cust_sel_clause
RETURN VARCHAR2
IS
l_query VARCHAR2(10000);
l_viewby_select VARCHAR2(10000);
l_url_select VARCHAR2(20000);
l_viewby_select := oki_dbi_util_pvt.get_viewby_select_clause(l_view_by, 'SRM', '6.0');
l_viewby_select := l_viewby_select ||
', OKI_DYNAMIC_URL_1 ,'|| l_prodcat_url || ' ,oki_measure_1 ,oki_measure_2 ,oki_measure_3 ,oki_measure_4
,oki_measure_5 ,oki_measure_6 , oki_measure_6 oki_calc_item4,oki_measure_7,oki_measure_8, oki_measure_9 ,
oki_measure_9 oki_calc_item5, oki_measure_11 ,oki_measure_12 ,oki_measure_13 ,oki_measure_14 ,
oki_measure_15,oki_measure_16 ,oki_measure_17, oki_measure_18, oki_measure_19
FROM (SELECT rank() over (&ORDER_BY_CLAUSE nulls last , '||l_view_by_col||') - 1 rnk ,'||l_view_by_col||'
,OKI_DYNAMIC_URL_1 ,oki_measure_1 ,oki_measure_2 ,oki_measure_3 ,oki_measure_4 ,oki_measure_5 ,oki_measure_6
,oki_measure_7,oki_measure_8,oki_measure_9 ,oki_measure_11 ,oki_measure_12 ,oki_measure_13 ,oki_measure_14
,oki_measure_15 ,oki_measure_16,oki_measure_17,oki_measure_18, oki_measure_19 FROM ( ';
l_url_select :=
'SELECT DECODE(resource_id,-999, ''pFunctionName=OKI_DBI_SRM_PRNWL_RATE_DRPT&VIEW_BY_NAME=VIEW_BY_ID&pParamIds=Y&VIEW_BY=ORGANIZATION+JTF_ORG_SALES_GROUP'', '''') OKI_DYNAMIC_URL_1 ';
l_url_select :=
'SELECT NULL OKI_DYNAMIC_URL_1 ';
l_query := l_viewby_select || l_url_select || ' ,'||
l_view_by_col || ',' ||'
oset10.booked_val OKI_MEASURE_1,
oset10.start_val OKI_MEASURE_2,
oset10.val_rate OKI_MEASURE_3,
oset10.booked_lcount OKI_MEASURE_4,
oset10.start_lcount OKI_MEASURE_5,
oset10.lcount_rate OKI_MEASURE_6,
oset10.booked_hcount OKI_MEASURE_7,
oset10.start_hcount OKI_MEASURE_8,
oset10.hcount_rate OKI_MEASURE_9,
oset10.booked_val_tot OKI_MEASURE_11,
oset10.start_val_tot OKI_MEASURE_12,
oset10.val_rate_tot OKI_MEASURE_13,
oset10.booked_lcount_tot OKI_MEASURE_14,
oset10.start_lcount_tot OKI_MEASURE_15,
oset10.lcount_rate_tot OKI_MEASURE_16,
oset10.booked_hcount_tot OKI_MEASURE_17,
oset10.start_hcount_tot OKI_MEASURE_18,
oset10.hcount_rate_tot OKI_MEASURE_19
FROM
(
SELECT '|| l_view_by_col || ',
oset05.booked_val booked_val,
oset05.starting_val start_val,
oset05.booked_val/decode(oset05.starting_val,0,NULL,oset05.starting_val)*100 val_rate,
oset05.booked_lcount booked_lcount,
oset05.starting_lcount start_lcount,
oset05.booked_lcount /decode( oset05.starting_lcount,0,NULL,oset05.starting_lcount)*100 lcount_rate,
oset05.booked_hcount booked_hcount,
oset05.starting_hcount start_hcount,
oset05.booked_hcount /decode( oset05.starting_hcount,0,NULL,oset05.starting_hcount)*100 hcount_rate,
oset05.booked_val_tot booked_val_tot,
oset05.starting_val_tot start_val_tot,
oset05.booked_val_tot/decode(oset05.starting_val_tot,0,NULL,oset05.starting_val_tot)*100 val_rate_tot,
oset05.booked_lcount_tot booked_lcount_tot,
oset05.starting_lcount_tot start_lcount_tot,
oset05.booked_lcount_tot /decode( oset05.starting_lcount_tot,0,NULL,oset05.starting_lcount_tot)*100 lcount_rate_tot,
oset05.booked_hcount_tot booked_hcount_tot,
oset05.starting_hcount_tot start_hcount_tot,
oset05.booked_hcount_tot /decode( oset05.starting_hcount_tot,0,NULL,oset05.starting_hcount_tot)*100 hcount_rate_tot
FROM
(SELECT '|| l_viewby_col_special ||l_view_by_col ||',
NVL(SUM(fact.price_nego_'||l_cur_suffix||'),0) starting_val,
NVL(COUNT(distinct(fact.chr_id)),0) starting_hcount,
NVL(COUNT(distinct(fact.cle_id)),0) starting_lcount,
NVL(SUM(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.price_nego_'||l_cur_suffix||' else null end),0) booked_val,
NVL(COUNT(distinct(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.chr_id else null end)),0) booked_hcount,
NVL(COUNT(distinct(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.cle_id else null end)),0) booked_lcount ,
NVL(SUM(SUM(fact.price_nego_'||l_cur_suffix||')) over (),0) starting_val_tot,
NVL(SUM(COUNT(distinct(fact.chr_id))) over (),0) starting_hcount_tot,
NVL(SUM(COUNT(distinct(fact.cle_id))) over (),0) starting_lcount_tot,
NVL(SUM(SUM(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.price_nego_'||l_cur_suffix||' else null end)) over (),0) booked_val_tot,
NVL(SUM(COUNT(distinct(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.chr_id else null end))) over(),0) booked_hcount_tot,
NVL(SUM(COUNT(distinct(case when date_signed <= &BIS_CURRENT_ASOF_DATE then fact.cle_id else null end))) over(),0) booked_lcount_tot '||
l_FROM_WHERE || l_VIEWBY_RANK_ORDER ;
'SELECT cal_NAME AS VIEWBY
, nvl(uset.c_s_r_amt_xed,0) OKI_MEASURE_1
, nvl(uset.p_s_r_amt_xed,0) OKI_MEASURE_2
, nvl(uset.c_s_gpr_amt_xed,0) + nvl(uset.c_g_scr_amt_xtd,0) OKI_MEASURE_3
, nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0) OKI_MEASURE_4
,( (nvl(uset.c_s_gpr_amt_xed,0) + nvl(uset.c_g_scr_amt_xtd,0))
/decode(uset.c_s_r_amt_xed,0,NULL,uset.c_s_r_amt_xed))*100 OKI_MEASURE_5
,(((nvl(uset.c_s_gpr_amt_xed,0) + nvl(uset.c_g_scr_amt_xtd,0))
/decode(uset.c_s_r_amt_xed,0,NULL,uset.c_s_r_amt_xed)*100) -
((nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0))
/decode(uset.p_s_r_amt_xed,0,NULL,uset.p_s_r_amt_xed)*100)) OKI_MEASURE_6
,((nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0))
/decode(uset.p_s_r_amt_xed,0,NULL,uset.p_s_r_amt_xed))*100 OKI_MEASURE_9
,nvl(uset.c_s_gpr_amt_xed,0) + nvl(uset.c_g_scr_amt_xtd,0) -
(nvl(uset.c_s_gpo_amt_xed,0)+nvl(uset.c_g_sco_amt_xtd,0)) OKI_MEASURE_7
,nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0) -
(nvl(uset.p_s_gpo_amt_xed,0)+nvl(uset.p_g_sco_amt_xtd,0)) OKI_MEASURE_10
, ((nvl(uset.c_s_gpr_amt_xed,0) + nvl(uset.c_g_scr_amt_xtd,0) -
(nvl(uset.c_s_gpo_amt_xed,0) + nvl(uset.c_g_sco_amt_xtd,0)) )
- (nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0) -
(nvl(uset.p_s_gpo_amt_xed,0) + nvl(uset.p_g_sco_amt_xtd,0))
)
) / abs(decode(
(nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0) -
(nvl(uset.p_s_gpo_amt_xed,0) + nvl(uset.p_g_sco_amt_xtd,0))
),0,NULL
,(nvl(uset.p_s_gpr_amt_xed,0) + nvl(uset.p_g_scr_amt_xtd,0) -
(nvl(uset.p_s_gpo_amt_xed,0) + nvl(uset.p_g_sco_amt_xtd,0))
)
)
) *100 OKI_MEASURE_8 ';