ECC Human Resources, Human Resources People Hierarchy

➜ Back to Library
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
Download
Related Blitz Reports
GL Account Analysis (Distributions) ECC Procurement, Purchase Orders ECC Sourcing, Negotiations, SQL2 ECC Human Resources, Human Resources Assignment Timeline ECC Human Resources, Human Resources, SQL1 ECC Sourcing, Negotiations, SQL1 ECC Discrete Manufacturing, Resources ECC Procurement, Requisitions ECC Human Resources, Human Resources, SQL2
Blitz Report™

Blitz Report™ provides multiple benefits: