View: HR_PATTERN_PURPOSES_V

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

View Text

SELECT PATP.PATTERN_PURPOSE_ID
, PATP.PATTERN_ID
, PATP.PATTERN_PURPOSE
, LOOK.MEANING
, PATP.OBJECT_VERSION_NUMBER
FROM HR_PATTERN_PURPOSES PATP
, HR_LOOKUPS LOOK
WHERE PATP.PATTERN_PURPOSE = LOOK.LOOKUP_CODE (+)
AND ((LOOK.LOOKUP_CODE IS NOT NULL
AND LOOK.LOOKUP_TYPE = 'PATTERN_PURPOSE') OR (LOOK.LOOKUP_CODE IS NULL))

Columns