Ошибка в sql запросе

sel ect
	productProduct.default_code "Код номенклатуры",
	promTable.def_code "Код комплектующего",
    productProduct.desc_product_name "Номенклатура",
	coalesce(round(productProduct.lst_price * 1.2, 3), 0) "Цена",
	coalesce(promTable.value, 0) "Себестоимость комплектующего"
from 
	product_product productProduct
left join 
	product_template productTemplate
on
	productTemplate.id = productProduct.product_tmpl_id
left join
	product_category productCategory
on
	productCategory.id = productTemplate.categ_id
left join
	product_category prCategory
on
	prCategory.id = productCategory.parent_id
--------комплектующие
left join(sel ect 
	prod.default_code "default_code",
	prod.id "prod_id",
	mbl.product_id "p_id",
	product.default_code "def_code",
	prop.prid "prid",
	prop.value "value"
from 
	mrp_bom_line mbl 
inner join
	product_product pp 
on
	mbl.product_id = pp.id 
inner join 
	mrp_bom mb 
on
	mb.id = mbl.bom_id 
inner join 
	product_product prod 
on
	mb.product_id = prod.id
inner join 
	product_product product 
on 
	mbl.product_id = product.id
left join  
	(select
	to_number(split_part(ip.res_id, ',', 2), 'L9G999g999.99') "prid",
	ip.value_float "value"
fr om 
	ir_property ip
inner join (select
	to_number(split_part(ip.res_id, ',', 2), 'L9G999g999.99') "prod_id",
	max(ip.write_date) "write_date" 
fr om 
	ir_property ip
group by 
	to_number(split_part(ip.res_id, ',', 2), 'L9G999g999.99')) tempTable 
on 
	ip.write_date = tempTable.write_date
and 
	to_number(split_part(ip.res_id, ',', 2), 'L9G999g999.99') = tempTable.prod_id) prop 
on  
	mbl.product_id = prop.prid
) promTable
on
	productProduct.id = promTable.prod_id

coalesce(promTable.value, 0) "Себестоимость комплектующего"