ENG Engineering Change Order Types

Description
Categories: BI Publisher, Manufacturing
Application: Engineering
Source: Engineering Change Order Types Report (XML)
Short Name: ENGRECOT_XML
DB package: ENG_ENGRECOT_XMLP_PKG
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
Parameter Name SQL text Validation
Organization_id
 
Number