ECC Enterprise Asset Management, eAM: Stores Materials, SQL1

Description
Columns: Material Name, Organization Id, Inv Organization Code, Material Uom, Inventory Item Id, Cross Ref Id, Cross Reference, Cross Ref Type, Manufacturer Id, Manufacturer Name ...
Imported from ECC
SELECT * from EAM_ECC_STORES_MAT_TEMP  PIVOT (max(MATERIAL_DESCRIPTION) as MATERIAL_DESCRIPTION ,
                                      max(EAM_ITEM_TYPE) as EAM_ITEM_TYPE,
                                      max(CROSS_REF_DESC) as CROSS_REF_DESC
                                      for LANGUAGE in ('US' "US"))