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
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, SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
|
LOV |
