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.

[Home] [Help]

View: HR_CALENDAR_EXCEPTIONS_V

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

View Text

SELECT PATEX.EXCEPTION_ID
, EXUS.EXCEPTION_USAGE_ID
, PATEX.PATTERN_ID
, EXUS.CALENDAR_ID
, PATEX.EXCEPTION_CATEGORY
, PATEX.EXCEPTION_START_TIME
, PATEX.EXCEPTION_END_TIME
, PATEX.EXCEPTION_NAME
, PAT.PATTERN_NAME
, LOOK.MEANING
, EXUS.EXCEPTION_REASON
, EXUS.OBJECT_VERSION_NUMBER
, PATEX.OBJECT_VERSION_NUMBER
FROM HR_PATTERN_EXCEPTIONS PATEX
, HR_EXCEPTION_USAGES EXUS
, HR_PATTERNS PAT
, HR_LOOKUPS LOOK
WHERE PATEX.EXCEPTION_ID = EXUS.EXCEPTION_ID
AND PAT.PATTERN_ID = PATEX.PATTERN_ID
AND PATEX.EXCEPTION_CATEGORY = LOOK.LOOKUP_CODE (+)
AND ((LOOK.LOOKUP_CODE IS NOT NULL
AND LOOK.LOOKUP_TYPE = 'EXCEPTION_CATEGORY') OR (LOOK.LOOKUP_CODE IS NULL))

Columns

Name
EXCEPTION_ID
EXCEPTION_USAGE_ID
PATTERN_ID
CALENDAR_ID
EXCEPTION_CATEGORY
EXCEPTION_START_TIME
EXCEPTION_END_TIME
EXCEPTION_NAME
PATTERN_NAME
EXCEPTION_CATEGORY_MEANING
EXCEPTION_REASON
EX_USAGE_OBJECT_VERSION_NUMBER
PAT_EX_OBJECT_VERSION_NUMBER