ECC Enterprise Asset Management, eAM: Work Orders, SQL2

Description
Columns: Ecc Spec Id, Wo Rowid, Null, Wip Entity Id, Wip Entity Name, Organization Id, Org Code, Wo Description, Wo System Status Id, Wo Status ...
Imported from ECC
SELECT distinct wip_entity_id ecc_spec_id
       ,wo_rowid
       ,null
       ,wip_entity_id
       ,wip_entity_name
       ,organization_id
       ,organization_code
       ,wo_description
       ,wo_system_status_id
       ,wo_status
       ,wo_pending_flag
       ,work_order_type_disp
       ,wo_department
       ,firm_flag
       ,asset_group
       ,asset_group_description
       ,asset_number
       ,asset_description
       ,asset_id
       ,asset_category
       ,asset_criticality
       ,asset_area
       ,wip_accounting_class
       ,asset_organization_code
       ,asset_organization_id
       ,asset_type
       ,asset_type_id
       ,asset_owning_dept
       ,asset_maintainable
       ,asset_active_flag
       ,asset_activity
       ,activity_source_meaning
       ,activity_type_disp
       ,activity_cause_disp
       ,priority_disp
       ,wo_shutdown_type
       ,wo_shutdown_type_code
       ,wo_shutdown_start_date
       ,wo_shutdown_end_date
       ,shutdown_hours
       ,tagout_required
       ,warranty_status
       ,warranty_exp_date
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,wo_actual_start_date
       ,wo_actual_completion_date
       ,wo_scheduled_start_date
       ,wo_scheduled_completion_date
       ,wo_schedule_delay
       ,wo_schedule_delay_flag
       ,wo_month
       ,wo_year
       ,wo_quarter
       ,WO_SCHEDULE_START_HORIZON
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,null
       ,wo_duration
       ,wo_scheduled_duration
       ,wo_age
       ,wo_completed_on_time
       ,wo_completed_late
       ,wo_completed
       ,pm_schedule_id
       ,PM_WORK_ORDER_FLAG
       ,pm_schedule_name
       ,wo_scheduled
       ,maintenance_object_id
       ,failure_code
       ,failure_desc
       ,cause_code
       ,cause_desc
       ,resolution_code
       ,resolution_desc
       ,failure_date
       ,failure_comments
       ,last_updated_by
       ,project_name
       ,task_name
       ,total_material_cost
       ,total_labor_cost
       ,total_equipment_cost
       ,actual_total_cost
       ,estimated_total_cost
       ,estimated_total_cost_flag
       ,variance_total_cost
       ,wo_cost_overrun
       ,cost_overrun_flag
       ,top_10_high_cost_wo_flag
       ,language
       ,material_shortage_check_date
       ,material_shortage_flag
       ,material_shortage
       ,materials
       ,resources
       ,operational_log_flag
       ,checkin_status
       ,warranty_active
       ,unplanned_wo_flag
       ,released_wo_flag
       ,open_wo_flag
       ,alert_flag
       ,alert_count
       ,alert_type
       ,alert_name
       ,alert_details
       ,wr_request_number
       ,wr_request_priority
       ,currency
       ,is_map_enabled
       ,wo_completion_percentage
      FROM eam_ecc_work_orders_v  where open_wo_flag = 'N' and language in ('US')