View: HR_CALENDAR_ENTITY_KEYS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_CALENDAR_ENTITY_KEYS_V

View Text

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

Columns