This is the part of the MV_SPEC_ITEM_IDENTS view that fetches the weldolet idents:
union /* only for oletes input1 =DN input_2 =DN_VON input_3 =DN_BIS input_4=SCH1 input_5 =sch2 */
SELECT distinct
SI.SPEC_ITEM_ID
,SI.HEADER_ID
,mI.COMMODITY_ID
,mI.IDENT
,mI.IDENT_CODE
,mI.INPUT_1 input_1
,gd2.INPUT_1 input_2
,gd2.INPUT_1 input_3
,mI.INPUT_4 input_4
,mI.INPUT_5
,mI.OUTPUT_1
,mI.OUTPUT_2
,mI.OUTPUT_3
,mI.OUTPUT_4
,mI.OUTPUT_5
,mI.OUTPUT_6
,mI.OUTPUT_7
,mI.OUTPUT_8
,mI.OUTPUT_9
,mI.OUTPUT_10
,mI.OUTPUT_11
,mI.OUTPUT_12
,mI.OUTPUT_13
,mI.OUTPUT_14
,mI.OUTPUT_15
,si.short_code
from m_geom_details gd2 ,m_geom_details gd ,
mvp_idents mi,
m_spec_items si
where si.spec_item_id >0
and nvl(si.size1_gn_id,0) >0 /* Geometric Filter Table must be on
Spec-Item*/
and si.commodity_id =mi.commodity_id
and to_number(mi.input_1) between to_number(from_size1)
and to_number(to_size1)
and decode(to_char(si.from_size2,'0000000.9999'),null,'0',m_sort(mi.input_2))
between nvl(to_char(si.from_size2,'0000000.9999'),'0')
and nvl(to_char(si.to_size2,'0000000.9999'),'0')
and nvl(to_char(si.attr_num3),mi.input_5)=mi.input_5
and -- for Weldolets
gd.gn_id = si.size1_gn_id
and gd2.gn_id = si.size1_gn_id
and gd.input_1 = mi.input_1
and gd.input_2 = decode(mi.input_4,'0',gd.input_2 ,mi.input_4)
and m_sort(gd2.input_1) between m_sort(mi.input_2) and m_sort(mi.input_3)
and gd2.input_2 = decode(mi.input_5,'0',gd2.input_2 ,mi.input_5)