View: HR_PATTERN_EXCEPTIONS_V

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

View Text

SELECT PATEX.EXCEPTION_ID
, PATEX.PATTERN_ID
, PATEX.EXCEPTION_CATEGORY
, PATEX.EXCEPTION_START_TIME
, PATEX.EXCEPTION_END_TIME
, PATEX.EXCEPTION_NAME
, PAT.PATTERN_NAME
, LOOK.MEANING
, PATEX.OBJECT_VERSION_NUMBER
FROM HR_PATTERN_EXCEPTIONS PATEX
, HR_PATTERNS PAT
, HR_LOOKUPS LOOK
WHERE 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