ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B2691147B3D51D1CE0530100007F1682 PER Security Profile Y select psp.security_profile_name value, null description from per_security_profiles psp order by value US EEE75CEB4A266AD8E05362FB09051F8BY 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 AR ECC الموارد البشرية, Human Resources Assignment Timeline 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 JA ECC 人事管理, Human Resources Assignment Timeline 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 KO ECC HR, Human Resources Assignment Timeline 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 RU ECC Персонал, Human Resources Assignment Timeline 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 S ECC Personaladministration, Human Resources Assignment Timeline 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 TR ECC İnsan Kaynakları, Human Resources Assignment Timeline 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 US ECC Human Resources, Human Resources Assignment Timeline 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 ZHS ECC 人力资源, Human Resources Assignment Timeline 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 Enterprise Command Center 1 10 2=2 x.security_profile_id in (select psp.security_profile_id from per_security_profiles psp where psp.security_profile_name=:security_profile) LOV PER Security Profile B2691147B3D51D1CE0530100007F1682 Y select psp.security_profile_name value, null description from per_security_profiles psp order by value select nvl(fnd_profile.value('PER_SECURITY_PROFILE_ID'),fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL')) from dual US Security Profile