View: HR_CALENDAR_USAGES_V

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

View Text

SELECT CAU.CALENDAR_ID
, CAU.CALENDAR_USAGE_ID
, CAU.PRIMARY_KEY_VALUE
, CAU.PURPOSE_USAGE_ID
, CAU.START_DATE
, TO_DATE(TO_CHAR(CAU.START_DATE
, 'DD-MON-YYYY')
, 'DD-MON-YYYY')
, TO_CHAR(CAU.START_DATE
, 'HH24:MI')
, CAU.END_DATE
, TO_DATE(TO_CHAR(CAU.END_DATE
, 'DD-MON-YYYY')
, 'DD-MON-YYYY')
, TO_CHAR(CAU.END_DATE
, 'HH24:MI')
, CAU.OBJECT_VERSION_NUMBER
, CAU.CREATED_BY
, CAU.CREATION_DATE
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
, PPU.ENTITY_NAME
, ENT.MEANING
, PPU.PATTERN_PURPOSE
, PURPOSE.MEANING
, ENTITY.FULL_NAME
FROM HR_PATTERN_PURPOSE_USAGES PPU
, HR_CALENDAR_USAGES CAU
, PER_ALL_PEOPLE_F ENTITY
, HR_LOOKUPS ENT
, HR_LOOKUPS PURPOSE
, FND_SESSIONS
WHERE /* -- --
WHERE THE TABLES JOIN SUCCESSFULLY --*/ PPU.PURPOSE_USAGE_ID = CAU.PURPOSE_USAGE_ID
AND (PPU.ENTITY_NAME = ENT.LOOKUP_CODE
AND ENT.LOOKUP_TYPE = 'SCHEDULABLE_ENTITY')
AND (PPU.PATTERN_PURPOSE = PURPOSE.LOOKUP_CODE
AND PURPOSE.LOOKUP_TYPE = 'PATTERN_PURPOSE') /* -- --
AND THE PRIMARY KEY MATCHES ONE PERSON ROW --*/
AND PPU.ENTITY_NAME = 'PERSON'
AND ENTITY.PERSON_ID = CAU.PRIMARY_KEY_VALUE
AND FND_SESSIONS.SESSION_ID = USERENV('SESSIONID')
AND FND_SESSIONS.EFFECTIVE_DATE BETWEEN ENTITY.EFFECTIVE_START_DATE
AND ENTITY.EFFECTIVE_END_DATE UNION ALL SELECT /* -- -- GET CALENDAR USAGES FOR THE ASSIGNMENT ENTITY -- -- ALL COLUMNS OF THE BASE TABLE -*/ CAU.CALENDAR_ID
, CAU.CALENDAR_USAGE_ID
, CAU.PRIMARY_KEY_VALUE
, CAU.PURPOSE_USAGE_ID
, CAU.START_DATE
, TRUNC(CAU.START_DATE)
, TO_CHAR(CAU.START_DATE
, 'HH24:MI')
, CAU.END_DATE
, TRUNC(CAU.END_DATE)
, TO_CHAR(CAU.END_DATE
, 'HH24:MI')
, CAU.OBJECT_VERSION_NUMBER
, CAU.CREATED_BY
, CAU.CREATION_DATE
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
, PPU.ENTITY_NAME
, ENT.MEANING
, PPU.PATTERN_PURPOSE
, PURPOSE.MEANING
, ENTITY.ASSIGNMENT_NUMBER
FROM HR_PATTERN_PURPOSE_USAGES PPU
, HR_CALENDAR_USAGES CAU
, PER_ASSIGNMENTS_F ENTITY
, HR_LOOKUPS ENT
, HR_LOOKUPS PURPOSE
, FND_SESSIONS
WHERE /* -- --
WHERE THE TABLES JOIN SUCCESSFULLY --*/ PPU.PURPOSE_USAGE_ID = CAU.PURPOSE_USAGE_ID
AND (PPU.ENTITY_NAME = ENT.LOOKUP_CODE
AND ENT.LOOKUP_TYPE = 'SCHEDULABLE_ENTITY')
AND (PPU.PATTERN_PURPOSE = PURPOSE.LOOKUP_CODE
AND PURPOSE.LOOKUP_TYPE = 'PATTERN_PURPOSE') /* -- --
AND THE PRIMARY KEY MATCHES ONE ASSIGNMENT ROW --*/
AND PPU.ENTITY_NAME = 'ASSIGNMENT'
AND ENTITY.ASSIGNMENT_ID = CAU.PRIMARY_KEY_VALUE
AND FND_SESSIONS.SESSION_ID = USERENV('SESSIONID')
AND FND_SESSIONS.EFFECTIVE_DATE BETWEEN ENTITY.EFFECTIVE_START_DATE
AND ENTITY.EFFECTIVE_END_DATE UNION ALL SELECT /* -- -- GET CALENDAR USAGES FOR THE JOB ENTITY -- -- ALL COLUMNS OF THE BASE TABLE --*/ CAU.CALENDAR_ID
, CAU.CALENDAR_USAGE_ID
, CAU.PRIMARY_KEY_VALUE
, CAU.PURPOSE_USAGE_ID
, CAU.START_DATE
, TRUNC(CAU.START_DATE)
, TO_CHAR(CAU.START_DATE
, 'HH24:MI')
, CAU.END_DATE
, TRUNC(CAU.END_DATE)
, TO_CHAR(CAU.END_DATE
, 'HH24:MI')
, CAU.OBJECT_VERSION_NUMBER
, CAU.CREATED_BY
, CAU.CREATION_DATE
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
, PPU.ENTITY_NAME
, ENT.MEANING
, PPU.PATTERN_PURPOSE
, PURPOSE.MEANING
, JBT.NAME
FROM HR_PATTERN_PURPOSE_USAGES PPU
, HR_CALENDAR_USAGES CAU
, PER_JOBS_TL JBT
, HR_LOOKUPS ENT
, HR_LOOKUPS PURPOSE
WHERE /* -- --
WHERE THE TABLES JOIN SUCCESSFULLY --*/ PPU.PURPOSE_USAGE_ID = CAU.PURPOSE_USAGE_ID
AND (PPU.ENTITY_NAME = ENT.LOOKUP_CODE
AND ENT.LOOKUP_TYPE = 'SCHEDULABLE_ENTITY')
AND (PPU.PATTERN_PURPOSE = PURPOSE.LOOKUP_CODE
AND PURPOSE.LOOKUP_TYPE = 'PATTERN_PURPOSE') /* -- --
AND THE PRIMARY KEY IS FOR A JOB --*/
AND PPU.ENTITY_NAME = 'JOB'
AND JBT.JOB_ID = CAU.PRIMARY_KEY_VALUE
AND JBT.LANGUAGE = USERENV('LANG') UNION ALL SELECT /* -- -- GET CALENDAR USAGES FOR THE LOCATION ENTITY -- -- ALL COLUMNS OF THE BASE TABLE --*/ CAU.CALENDAR_ID
, CAU.CALENDAR_USAGE_ID
, CAU.PRIMARY_KEY_VALUE
, CAU.PURPOSE_USAGE_ID
, CAU.START_DATE
, TRUNC(CAU.START_DATE)
, TO_CHAR(CAU.START_DATE
, 'HH24:MI')
, CAU.END_DATE
, TRUNC(CAU.END_DATE)
, TO_CHAR(CAU.END_DATE
, 'HH24:MI')
, CAU.OBJECT_VERSION_NUMBER
, CAU.CREATED_BY
, CAU.CREATION_DATE
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
, PPU.ENTITY_NAME
, ENT.MEANING
, PPU.PATTERN_PURPOSE
, PURPOSE.MEANING
, ENTITY.LOCATION_CODE
FROM HR_PATTERN_PURPOSE_USAGES PPU
, HR_CALENDAR_USAGES CAU
, HR_LOCATIONS ENTITY
, HR_LOOKUPS ENT
, HR_LOOKUPS PURPOSE
WHERE /* -- --
WHERE THE TABLES JOIN SUCCESSFULLY --*/ PPU.PURPOSE_USAGE_ID = CAU.PURPOSE_USAGE_ID
AND (PPU.ENTITY_NAME = ENT.LOOKUP_CODE
AND ENT.LOOKUP_TYPE = 'SCHEDULABLE_ENTITY')
AND (PPU.PATTERN_PURPOSE = PURPOSE.LOOKUP_CODE
AND PURPOSE.LOOKUP_TYPE = 'PATTERN_PURPOSE') /* -- --
AND THE PRIMARY KEY IS FOR A LOCATION --*/
AND PPU.ENTITY_NAME = 'LOCATION'
AND ENTITY.LOCATION_ID = CAU.PRIMARY_KEY_VALUE UNION ALL SELECT /* -- -- GET CALENDAR USAGES FOR THE POSITION ENTITY -- -- ALL COLUMNS OF THE BASE TABLE --*/ CAU.CALENDAR_ID
, CAU.CALENDAR_USAGE_ID
, CAU.PRIMARY_KEY_VALUE
, CAU.PURPOSE_USAGE_ID
, CAU.START_DATE
, TRUNC(CAU.START_DATE)
, TO_CHAR(CAU.START_DATE
, 'HH24:MI')
, CAU.END_DATE
, TRUNC(CAU.END_DATE)
, TO_CHAR(CAU.END_DATE
, 'HH24:MI')
, CAU.OBJECT_VERSION_NUMBER
, CAU.CREATED_BY
, CAU.CREATION_DATE
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
, PPU.ENTITY_NAME
, ENT.MEANING
, PPU.PATTERN_PURPOSE
, PURPOSE.MEANING
, ENTITY.NAME
FROM HR_PATTERN_PURPOSE_USAGES PPU
, HR_CALENDAR_USAGES CAU
, HR_POSITIONS_F ENTITY
, HR_LOOKUPS ENT
, HR_LOOKUPS PURPOSE
WHERE /* -- --
WHERE THE TABLES JOIN SUCCESSFULLY --*/ PPU.PURPOSE_USAGE_ID = CAU.PURPOSE_USAGE_ID
AND (PPU.ENTITY_NAME = ENT.LOOKUP_CODE
AND ENT.LOOKUP_TYPE = 'SCHEDULABLE_ENTITY')
AND (PPU.PATTERN_PURPOSE = PURPOSE.LOOKUP_CODE
AND PURPOSE.LOOKUP_TYPE = 'PATTERN_PURPOSE') /* -- --
AND THE PRIMARY KEY IS FOR A POSITION --*/
AND PPU.ENTITY_NAME = 'POSITION'
AND ENTITY.POSITION_ID = CAU.PRIMARY_KEY_VALUE
AND ENTITY.EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY') UNION ALL SELECT /* -- -- GET CALENDAR USAGES FOR THE ORGANIZATION -- -- ALL COLUMNS OF THE BASE TABLE --*/ CAU.CALENDAR_ID
, CAU.CALENDAR_USAGE_ID
, CAU.PRIMARY_KEY_VALUE
, CAU.PURPOSE_USAGE_ID
, CAU.START_DATE
, TRUNC(CAU.START_DATE)
, TO_CHAR(CAU.START_DATE
, 'HH24:MI')
, CAU.END_DATE
, TRUNC(CAU.END_DATE)
, TO_CHAR(CAU.END_DATE
, 'HH24:MI')
, CAU.OBJECT_VERSION_NUMBER
, CAU.CREATED_BY
, CAU.CREATION_DATE
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
, PPU.ENTITY_NAME
, ENT.MEANING
, PPU.PATTERN_PURPOSE
, PURPOSE.MEANING
, ENTITY.NAME
FROM HR_PATTERN_PURPOSE_USAGES PPU
, HR_CALENDAR_USAGES CAU
, HR_ORGANIZATION_UNITS ENTITY
, HR_LOOKUPS ENT
, HR_LOOKUPS PURPOSE
WHERE /* -- --
WHERE THE TABLES JOIN SUCCESSFULLY --*/ PPU.PURPOSE_USAGE_ID = CAU.PURPOSE_USAGE_ID
AND (PPU.ENTITY_NAME = ENT.LOOKUP_CODE
AND ENT.LOOKUP_TYPE = 'SCHEDULABLE_ENTITY')
AND (PPU.PATTERN_PURPOSE = PURPOSE.LOOKUP_CODE
AND PURPOSE.LOOKUP_TYPE = 'PATTERN_PURPOSE') /* -- --
AND THE PRIMARY KEY IS FOR A BUSINESS GROUP --*/
AND PPU.ENTITY_NAME = 'ORGANIZATION'
AND ENTITY.ORGANIZATION_ID = CAU.PRIMARY_KEY_VALUE
AND ENTITY.ORGANIZATION_ID = ENTITY.BUSINESS_GROUP_ID

Columns