ECC Human Resources, Human Resources People Hierarchy

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: per-hierarchy
Query Procedure: PER_ECC_HIERARCHY_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run ECC Human Resources, Human Resources People Hierarchy and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT ECC_SPEC_ID
                ,PERSON_ID
                ,IMAGE
               ,FIRST_NAME
               ,LAST_NAME
               ,MIDDLE_NAME
               ,KNOWN_AS
               ,FULL_NAME
               ,EMAIL_ADDRESS
               ,ASSIGNMENT_ID
               ,PRIMARY_FLAG
               ,ASSIGNMENT_STATUS
               ,ASSIGNMENT_TYPE
               ,REMOTE_WORKER
               ,ORGANIZATION
               ,PEOPLE_GROUP
               ,JOB
               ,POSITION
               ,GRADE
               ,LOCATION
               ,COUNTRY
               ,SUPERVISOR
               ,SUPERVISOR_ID
               ,RECORD_LAST_UPDATE_DATE
               ,LANGUAGE
               ,PHONE
               ,REPORTEE_COUNT
FROM PER_ECC_PEOPLE_HIERARCHY_V where language in ('US')) PIVOT (max(COUNTRY) as COUNTRY
                                                  , 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