ENG Engineering Change Order Types

Description

Categories
BI Publisher
Application
Engineering
Source
Engineering Change Order Types Report (XML)
Short Name
ENGRECOT_XML
DB package
ENG_ENGRECOT_XMLP_PKG
Imported from BI Publisher
Engineering Change Order Types Report

SQL 11 lines

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