ECC Product Information Management, Item Cross Reference, SQL1

Description
Columns: Ecc Spec Id, Inventory Item Id, Organization Id, Item, Org Code, Cross Reference Type, Cross Reference Value, Us Description ...
Imported from ECC
SELECT *
  FROM (
    SELECT
      ECC_SPEC_ID,
      INVENTORY_ITEM_ID,
      ORGANIZATION_ID,
      ITEM,
      ORG_CODE,
      DESCRIPTION,
      CROSS_REFERENCE_TYPE,
      CROSS_REFERENCE_VALUE,
      LANGUAGE
    FROM
      MTL_ITEM_ECC_CROSS_REF_V where language in ('US'))PIVOT (
      MAX(DESCRIPTION) AS DESCRIPTION
      for LANGUAGE in ('US' "US"))