ECC Human Resources, Human Resources, SQL2

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: PER
Query Procedure: PER_ECC_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
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"))
) x
where
2=2
Parameter Name SQL text Validation
Security Profile
x.security_profile_id in (select psp.security_profile_id from per_security_profiles psp where psp.security_profile_name=:security_profile)
LOV