eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HR_CALENDAR_USAGES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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