ENG Engineering Change Order Types

select t.type_name change_order_type,          
       t.description,
       l.meaning item_access_meaning,
       t.disable_date
from eng_change_order_types_vl t,
     mfg_lookups l
where l.lookup_type = 'ECG_BOM_COMP_SEL'
and   l.lookup_code = t.assembly_type 
and t.change_mgmt_type_code = 'CHANGE_ORDER'
order by t.change_order_type