ECC Human Resources, Human Resources Assignment Timeline
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: PER_ASSG_TIMELINE
Query Procedure: PER_ECC_TIMELINE_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Dataset Key: PER_ASSG_TIMELINE
Query Procedure: PER_ECC_TIMELINE_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 ,LOCATION_CHANGE_DATE ,ORGANIZATION_CHANGE_DATE ,GRADE_CHANGE_DATE ,POSITION_CHANGE_DATE ,JOB_CHANGE_DATE ,HIRE_DATE ,END_EMPLOYMENT_DATE ,FULL_NAME ,UNIQUE_ID FROM PER_ECC_ASSIGNMENTS_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 |
