295: (select pk1_value from eng_change_subjects ecs where ecs.entity_name='PROCESS' and ecs.change_id=eec.change_id) as process_id,
296: decode(status_code, 0, 0, 11, 0, 1) as open
297: from eng_engineering_changes eec
298: where change_order_type_id in (select change_order_type_id
299: from eng_change_order_types
300: where type_classification='HEADER'
301: and change_mgmt_type_code='AMW_PROC_CERT_ISSUES')) open_issues,
302: amw_audit_units_v aauv,
303: amw_certification_vl acv