ECC Human Resources, Human Resources, SQL2

Description
Columns: Ecc Spec Id, Person Id, User Id, Asg Effective Start Date, Asg Effective End Date, Assignment Id, Asg Primary Flag, Assignment Category, Assignment Status, Assignment Type ...
Imported from ECC
select * from (SELECT ECC_SPEC_ID
                ,PERSON_ID
                ,USER_ID
               ,ASG_EFFECTIVE_START_DATE
               ,ASG_EFFECTIVE_END_DATE
               ,ASSIGNMENT_ID
               ,ASG_PRIMARY_FLAG
               ,EMPLOYEE_CATEGORY
               ,EMPLOYMENT_CATEGORY
               ,ASSIGNMENT_CATEGORY
               ,ASSIGNMENT_STATUS
               ,ASSIGNMENT_TYPE
               ,REMOTE_WORKER
               ,PROBATION_PERIOD
               ,BARGAINING_UNIT
               ,ORGANIZATION
               ,PEOPLE_GROUP
               ,JOB
               ,POSITION
               ,GRADE
               ,PAYROLL
               ,LOCATION
               ,GRADE_CHANGE
               ,JOB_CHANGE
               ,POSITION_CHANGE
               ,LOCATION_CHANGE
               ,ORGANIZATION_CHANGE
    ,SALARY_CHANGE
    ,COUNTRY
               ,SUPERVISOR
               ,SUPERVISOR_ID
               ,SUPERVISOR_USER_ID
               ,SALARY_BASIS
               ,REGULATORY_REGION
               ,DERIVED_LOCATION
               ,COORDINATES
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,ASG_LAST_UPDATE_DATE
               ,IS_MANAGER
,LANGUAGE
FROM PER_ECC_ASSIGNMENT_V where language in ('US')) PIVOT (max(EMPLOYEE_CATEGORY) as EMPLOYEE_CATEGORY, max(EMPLOYMENT_CATEGORY) as EMPLOYMENT_CATEGORY,
  max(BARGAINING_UNIT) as BARGAINING_UNIT, max(COUNTRY) as COUNTRY, max(PROBATION_PERIOD) as PROBATION_PERIOD
                                                  , max(ORGANIZATION) as ORGANIZATION
                                                  , max(JOB) as JOB
                                                  , max(POSITION) as POSITION
                                                  , max(LOCATION) as LOCATION
                                                  , max(GRADE) as GRADE for LANGUAGE in ('US' "US"))