ECC Product Information Management, Item Revisions, SQL1

Description
Columns: Ecc Spec Id, Inventory Item Id, Organization Id, Item, Org Code, Revision Reasons, Current Revision, Revision Label, Effectivity Date, Implementation Date ...
Imported from ECC
SELECT *
  FROM (
    SELECT
      ECC_SPEC_ID,
      INVENTORY_ITEM_ID,
      ORGANIZATION_ID,
      ITEM,
      ORG_CODE,
      DESCRIPTION,
      REVISION_REASONS,
      CURRENT_REVISION,
      REVISION_LABEL,
      EFFECTIVITY_DATE,
      IMPLEMENTATION_DATE,
      REVISIONS,
      LANGUAGE,
	  PENDING_CHANGE
    FROM
      MTL_ITEM_ECC_REVISIONS_V where language in ('US'))
      PIVOT (MAX(DESCRIPTION) AS DESCRIPTION
      for LANGUAGE in ('US' "US"))