ECC Product Information Management, Related Items, SQL1

Description
Columns: Ecc Spec Id, Inventory Item Id, Organization Id, Relationship Type Id, Org Code, Item, Related Item, Us Description, Us Relationship Types ...
Imported from ECC
SELECT *
  FROM ( SELECT
           ecc_spec_id,
           inventory_item_id,
           organization_id,
           relationship_type_id,
           org_code,
           item,
           description,
           relationship_types,
           related_item,
           language
       FROM
           mtl_item_ecc_rel_items_v  where language in ('US')
)
 PIVOT (MAX(description) AS DESCRIPTION,MAX(relationship_types) as RELATIONSHIP_TYPES
 FOR language IN('US' "US"))