Hi @KanishkaLK ,

TECHNICAL_OBJECT_REFERENCE view contains the records and KEY_REF field has the mappings to the functional object.

API : TECHNICAL_OBJECT_REFERENCE_API

Regards,

Thanks, @EntNadeeL. That’s where it begins, but it is only a small part of the answer :)

That view/table is the “header” that connects the list of attributes to the object. The actual values lie in another view/table. You can have a look at the values with this example query:

SELECT * FROM technical_specification WHERE value_text IS NOT NULL AND rownum < 30;

I don’t want to go into more detail. With some SQL tool, you can browse around the different table that has a name that starts with “TECHNICAL” to get an understanding of how it all fits together. It’s actually a quite big data model with around 10 different “views” involved.

Hi @KanishkaLK,

I agree with @Mathias Dahl on the fact that Technical Classes are actually a quite big data model.
You might be able to re-use the below query with a few modifications,

SELECT NVL(tst.value_text, tst.value_no) value
FROM   &AO.technical_object_reference  tor,
       &AO.technical_specification_tab tst,
       &AO.technical_attrib_both       tab
WHERE  tor.technical_spec_no = tst.technical_spec_no
AND    tor.technical_class   = tab.technical_class
AND    tst.attribute         = tab.attribute
AND    tab.description       = 'Valve Body Model'   --Recommended to use tab.attribute instead of tab.description
AND    tor.lu_name           = 'EquipmentObject'
AND    tor.key_ref           = (SELECT &AO.Client_SYS.Get_Key_Reference_From_Objkey(lu_name_ => tor.lu_name,
                                                                                    objkey_  => Equipment_Object_API.Get_Objkey(contract_ => '&SITE',
                                                                                                                                mch_code_ => '&OBJECT_ID')
                                       ) key_ref
                                FROM   sys.dual)
;

Hope this helps 

Cheers !
Dhananjaya.

Thank you for sharing your valuable knowledge @EntNadeeL , @Mathias Dahl and @dhlelk