ECC Human Resources, Human Resources, SQL1

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
Run ECC Human Resources, Human Resources, SQL1 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT ECC_SPEC_ID ,  
        PERSON_ID
               ,PERSON
               ,IMAGE
               ,BUSINESS_GROUP_ID
               ,PEOPLE_EFFECTIVE_START_DATE
               ,PEOPLE_EFFECTIVE_END_DATE
               ,FIRST_NAME
               ,LAST_NAME
               ,MIDDLE_NAME
               ,KNOWN_AS
               ,FULL_NAME
               ,EMAIL_ADDRESS
               ,MARITAL_STATUS
               ,NATIONALITY
               ,PERSON_TYPE
               ,CURRENTLY_EMPLOYEE
               ,CURRENTLY_APPLICANT
               ,CURRENTLY_CONTINGENT_WORKER
               ,DATE_OF_BIRTH
               ,AGE
               ,BIRTH_ANNIVERSARY
               ,GENDER
               ,WORK_EXPERIENCE
               ,BLOOD_GROUP
               ,JOINING_DATE
               ,RELIEVING_DATE
               ,TENURE
               ,WORK_ANNIVERSARY
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,PEO_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_PEOPLE_V pep_v   where language in ('US')  ) PIVOT (max(MARITAL_STATUS) as MARITAL_STATUS, max(NATIONALITY) as NATIONALITY, max(GENDER) as GENDER, max(PERSON_TYPE) as PERSON_TYPE 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