ECC iProcurement, iProcurement Catalog, SQL18

Description
Columns: Ecc Spec Id, Ecc Last Update Date, Height, Horsepower Rating, Impeller Material, Inlet Size, Length, Maximum Flow Rate, Maximum Pressure, Outlet Size ...
Imported from ECC
select * from (  select * from ICX_CAT_ECC_100285_VL WHERE LANGUAGE in ( 'US')  )
              PIVOT ( count(1) as IS_TRANSLATION_AVAILABLE    FOR LANGUAGE IN ('US' "US"))