ECC Product Information Management, Item Category Sets, SQL1

Description
Columns: Ecc Spec Id, Inventory Item Id, Organization Id, Org Code, Cat Name, Us Category Set Name ...
Imported from ECC
SELECT *
  FROM (
    SELECT
      ECC_Spec_Id,
      inventory_item_id,
      organization_id,
      ORG_CODE,
      category_set_name,
      category_name,
      language
        FROM
            mtl_item_ecc_categories_v  where language in ('US')
)
 PIVOT (MAX(category_set_name) as category_set_name
 FOR language IN('US' "US"))