VIEW: APPS.HR_CALENDAR_ENTITY_KEYS_V

Source

View Text - Preformatted

SELECT DISTINCT ENTITY.PERSON_ID , ENTITY.FULL_NAME , ENTITY.EMPLOYEE_NUMBER , ENTITY.BUSINESS_GROUP_ID , 'PERSON' FROM PER_ALL_PEOPLE_F ENTITY UNION ALL SELECT DISTINCT ENTITY.ASSIGNMENT_ID, ENTITY.ASSIGNMENT_NUMBER, TO_CHAR(NULL), ENTITY.BUSINESS_GROUP_ID, 'ASSIGNMENT' FROM PER_ASSIGNMENTS_F ENTITY UNION ALL SELECT DISTINCT ENTITY.JOB_ID , JBT.NAME, TO_CHAR(NULL) , ENTITY.BUSINESS_GROUP_ID , 'JOB' FROM PER_JOBS_TL JBT , PER_JOBS ENTITY WHERE JBT.JOB_ID = ENTITY.JOB_ID AND JBT.LANGUAGE = userenv('LANG') UNION ALL SELECT DISTINCT ENTITY.LOCATION_ID, ENTITY.LOCATION_CODE, TO_CHAR(NULL), TO_NUMBER(NULL), 'LOCATION' FROM HR_LOCATIONS ENTITY UNION ALL SELECT DISTINCT ENTITY.POSITION_ID, hr_general.decode_position_latest_name(entity.position_id), TO_CHAR(NULL), ENTITY.BUSINESS_GROUP_ID, 'POSITION' FROM HR_POSITIONS_F ENTITY where effective_end_date = to_date('31124712','ddmmyyyy') UNION ALL SELECT ENTITY.BUSINESS_GROUP_ID, ENTITY.NAME, TO_CHAR(NULL), ENTITY.BUSINESS_GROUP_ID, 'ORGANIZATION' FROM PER_BUSINESS_GROUPS_PERF ENTITY

View Text - HTML Formatted

SELECT DISTINCT ENTITY.PERSON_ID
, ENTITY.FULL_NAME
, ENTITY.EMPLOYEE_NUMBER
, ENTITY.BUSINESS_GROUP_ID
, 'PERSON'
FROM PER_ALL_PEOPLE_F ENTITY UNION ALL SELECT DISTINCT ENTITY.ASSIGNMENT_ID
, ENTITY.ASSIGNMENT_NUMBER
, TO_CHAR(NULL)
, ENTITY.BUSINESS_GROUP_ID
, 'ASSIGNMENT'
FROM PER_ASSIGNMENTS_F ENTITY UNION ALL SELECT DISTINCT ENTITY.JOB_ID
, JBT.NAME
, TO_CHAR(NULL)
, ENTITY.BUSINESS_GROUP_ID
, 'JOB'
FROM PER_JOBS_TL JBT
, PER_JOBS ENTITY
WHERE JBT.JOB_ID = ENTITY.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG') UNION ALL SELECT DISTINCT ENTITY.LOCATION_ID
, ENTITY.LOCATION_CODE
, TO_CHAR(NULL)
, TO_NUMBER(NULL)
, 'LOCATION'
FROM HR_LOCATIONS ENTITY UNION ALL SELECT DISTINCT ENTITY.POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(ENTITY.POSITION_ID)
, TO_CHAR(NULL)
, ENTITY.BUSINESS_GROUP_ID
, 'POSITION'
FROM HR_POSITIONS_F ENTITY
WHERE EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY') UNION ALL SELECT ENTITY.BUSINESS_GROUP_ID
, ENTITY.NAME
, TO_CHAR(NULL)
, ENTITY.BUSINESS_GROUP_ID
, 'ORGANIZATION'
FROM PER_BUSINESS_GROUPS_PERF ENTITY