ECC Enterprise Asset Management, eAM: Stores Work Order, SQL1

Description
Columns: Ecc Spec Id, Ecc Last Update Date, Wip Entity Id, Wip Entity Name, Organization Id, Wo Organization Code, Wo Description, Wo System Status Id, Activity, Activity Id ...
Imported from ECC
SELECT * from (SELECT  ECC_SPEC_ID, ECC_LAST_UPDATE_DATE, WIP_ENTITY_ID, WIP_ENTITY_NAME, ORGANIZATION_ID,
				   WO_ORGANIZATION_CODE, WO_DESCRIPTION, LANGUAGE, WO_SYSTEM_STATUS_ID, WO_STATUS, ACTIVITY, ACTIVITY_ID, WORK_ORDER_TYPE_DISP,
				   WORK_ORDER_PRIORITY, ASSET_NUMBER, ASSET_ID, ASSET_DESCRIPTION, ASSET_GROUP, ASSET_GROUP_ID, ASSET_GROUP_DESCRIPTION,
				   WO_SCHEDULED_START_DATE, WO_SCHEDULED_COMPLETION_DATE, WO_DEPARTMENT, WO_SORT_ORDER, OPERATION_SEQ_NUM ,MATERIAL_NAME,
				   INVENTORY_ITEM_ID,UOM_CODE, MATERIAL_DESCRIPTION ,SUBINVENTORY_CODE ,REQUIRED_QUANTITY, ISSUED_QUANTITY,
				   ALLOCATED_QUANTITY,AVAILABLE_QUANTITY,OPEN_QUANTITY, MAT_SHORTAGE_QTY, MAT_ALLOCATED_QTY, MAT_UNPLANNED_QTY,
				   MATERIAL_SHORTAGE, MATERIAL_AVAILABILITY, UNPLANNED_MATERIAL, MATERIAL_ALLOCATED ,alert_type,alert_flag, alert_count,
				   ALERT_NAME, MATERIAL_SHORTAGE_FLAG, UNPLANNED_MATERIAL_USAGE_FLAG ,MATERIAL_ALLOCATED_FLAG,UPDATE_ASSET_LINK,
				   DEL_MAT_ALLOCAT_LINK,LOCATOR ,LOT_NUMBER, ITEM_CATEGORY,ASSET_BOM, UPDATE_LINK, COPY_ASSET_LINK, ALERT_DETAILS ,
				   MATERIALS_ISSUED,DELETE_FLAG, MATERIAL_OPEN  FROM EAM_ECC_STORES_WO_TEMP
                                        WHERE wo_system_status_id <> 7 )  PIVOT (max(MATERIAL_DESCRIPTION) as MATERIAL_DESCRIPTION ,
                                      max(WO_STATUS) as WO_STATUS,
			  	      max(WORK_ORDER_TYPE_DISP) as WORK_ORDER_TYPE_DISP,
                                      max(WORK_ORDER_PRIORITY) as WORK_ORDER_PRIORITY,
				      max(ALERT_TYPE) as ALERT_TYPE,
				      max(ALERT_NAME) as ALERT_NAME,
                                      max(ASSET_GROUP_DESCRIPTION) as ASSET_GROUP_DESCRIPTION
                                      for LANGUAGE in ('US' "US"))