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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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