ECC iProcurement, iProcurement Catalog, SQL1

Description
Columns: Ecc Spec Id, Thumbnail Image, Supplier, Supplier Site, Supplier Part Num, Supplier Part Auxid, Internal Item Num, Manufacturer, Manufacturer Part Num, Purchasing Category ...
Imported from ECC
SELECT * FROM  ( SELECT   ECC_SPEC_ID,
              THUMBNAIL_IMAGE          ,
              SHOPPING_CATEGORY        ,
              SUPPLIER                 ,
              SUPPLIER_SITE            ,
              SUPPLIER_PART_NUM        ,
              SUPPLIER_PART_AUXID      ,
              INTERNAL_ITEM_NUM        ,
              SOURCE                   ,
              MANUFACTURER             ,
              MANUFACTURER_PART_NUM    ,
              PURCHASING_CATEGORY      ,
              DESCRIPTION              ,
              ITEM_REVISION            ,
              UNIT_OF_MEASURE          ,
              PRICE                    ,
              CURRENCY                 ,
              FUNCTIONAL_PRICE         ,
              FUNCTIONAL_CURRENCY      ,
              AVAILABILITY             ,
              LEAD_TIME                ,
              UNSPSC                   ,
              ALIAS                    ,
              COMMENTS                 ,
              LONG_DESCRIPTION         ,
              ATTACHMENT_URL           ,
              SUPPLIER_URL             ,
              MANUFACTURER_URL         ,
              ORG_ID                   ,
              LANGUAGE                 ,
              ITEM_SOURCE_TEXT         ,
              CONTENT_TYPE_FILTER      ,
              RTrim(SubStrB(dbms_lob.substr(ATTACHMENT, 4000, 1),1,4000)) ATTACHMENT  ,
              ZONE_ID                  ,
              DISPLAY_PRICE            ,
              CONTENT_ID               ,
              CONTENT_URL              ,
              KEYWORDS                 ,
              CONTENT_TYPE             ,
              HIDE_SMARTFORM_ATTRS     ,
              HIDE_INFOCONTENT_ATTRS   ,
              PRICE_BREAK              ,
              HIDE_PRICE_BREAK         ,
              ITEM_RATING_FILTER       ,
              SUPPLIER_RATING_FILTER   ,
              HIDE_ADDTOCART           ,
              PUNCHOUT_MORE_DETAILS    ,
              OPEN_DESCRIPTION_IN_NEW_TAB ,
              ITEM_RATING              ,
              SUPPLIER_RATING          ,
              HIDE_CONTENT_TYPE        ,
              CONTENT_TYPE_RESULTS     ,
              SHOPPING_CATEGORY_1,
              SHOPPING_CATEGORY_2,
              SHOPPING_CATEGORY_3,
              ZONESB,
              ZONESP,
              ZONESI,
              PREFERRED_SUPPLIER_ICON,
              ECO_FRIENDLY_SUPPLIER_ICON,
              GREEN_SUPPLIER_ICON,
              OFF_CONTRACT_ITEM_ICON,
              OVER_PRICED_ICON
              FROM ICX_CAT_ECC_ITEMS_V WHERE LANGUAGE in ( 'US')  )
              PIVOT (
                MAX(SHOPPING_CATEGORY) AS SHOPPING_CATEGORY,
                MAX(DESCRIPTION) AS DESCRIPTION,
                MAX(UNIT_OF_MEASURE) AS UNIT_OF_MEASURE,
                MAX(COMMENTS) AS COMMENTS,
                MAX(LONG_DESCRIPTION) AS LONG_DESCRIPTION,
                MAX(ITEM_SOURCE_TEXT) AS ITEM_SOURCE_TEXT,
                MAX(CONTENT_TYPE_FILTER) AS CONTENT_TYPE_FILTER,
                MAX(DISPLAY_PRICE) AS DISPLAY_PRICE,
                MAX(PRICE_BREAK) AS PRICE_BREAK,
                MAX(ITEM_RATING_FILTER) AS ITEM_RATING_FILTER,
                MAX(SUPPLIER_RATING_FILTER) AS SUPPLIER_RATING_FILTER,
                MAX(PUNCHOUT_MORE_DETAILS) AS PUNCHOUT_MORE_DETAILS,
                MAX(CONTENT_TYPE_RESULTS) AS CONTENT_TYPE_RESULTS,
                MAX(SHOPPING_CATEGORY_1) AS SHOPPING_CATEGORY_1,
                MAX(SHOPPING_CATEGORY_2) AS SHOPPING_CATEGORY_2,
                MAX(SHOPPING_CATEGORY_3) AS SHOPPING_CATEGORY_3,
                MAX(KEYWORDS) AS KEYWORDS,
                MAX(SOURCE) AS SOURCE,
                COUNT(1) AS IS_TRANSLATION_AVAILABLE
                FOR LANGUAGE IN ('US' "US"))