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
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 |