ECC iProcurement, iProcurement Catalog, SQL24

Description
Columns: Ecc Spec Id, Ecc Last Update Date, Duns, Us Nigp, Unspsc Commodity, Chap, Preferred Supplier Icon, Eco Friendly Supplier Icon, Green Supplier Icon, Off Contract Item Icon ...
Imported from ECC
select * from (  select * from ICX_CAT_ECC_0_VL WHERE LANGUAGE in ( 'US')  )
              PIVOT ( count(1) as IS_TRANSLATION_AVAILABLE    FOR LANGUAGE IN ('US' "US"))