select plu.SZ_ITEM_REF_NO as "Plu_code", (select DESCRIPTIONS.sz_short_descr from descriptions where n0_descr_no = plu.n0_descr_no and n0_lkup_data_set=1 and
descriptions.N0_LANGUAGE_CODE=39 and descriptions.N0_AREA_CODE=310 and descriptions.N0_DESCR_APPL_ID=1) as "Plu_descr",
cast(PLU.n2_item_price as varchar(20)) as "Plu_price" from PLU where PLU.N0_REF_TYPE = 1 AND PLU.n0_lkup_data_set = 1 AND PLU.sz_item_ref_no= 'IIII'