ECC Human Resources, Human Resources, SQL6

Description
Columns: Ecc Spec Id, Person Id, Review Date, Logged User Id, Security Profile Id, Per Last Update Date, Us Performance Rating ...
Imported from ECC
select * from (SELECT ECC_SPEC_ID
    ,PERSON_ID
               ,PERFORMANCE_RATING
               ,REVIEW_DATE
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,PER_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_PERFORMANCE_V where language in ('US')) PIVOT (max(PERFORMANCE_RATING) as PERFORMANCE_RATING for LANGUAGE in ('US' "US"))