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
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 |
|
LOV |