ENG Engineering Change Order Types

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Engineering Change Order Types Report
Application: Engineering
Source: Engineering Change Order Types Report (XML)
Short Name: ENGRECOT_XML
DB package: ENG_ENGRECOT_XMLP_PKG
Run ENG Engineering Change Order Types and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™