View: HR_PATTERN_CONSTRUCTIONS_V

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

View Text

SELECT CONS.PATTERN_CONSTRUCTION_ID
, CONS.PATTERN_ID
, CONS.COMPONENT_PATTERN_ID
, CONS.PATTERN_BIT_ID
, CONS.AVAILABILITY
, CONS.SEQUENCE_NO
, PATS.PATTERN_NAME
, PBIT.PATTERN_BIT_CODE
, LOOK.MEANING
, CONS.OBJECT_VERSION_NUMBER
FROM HR_PATTERN_CONSTRUCTIONS CONS
, HR_PATTERNS PATS
, HR_PATTERN_BITS PBIT
, HR_LOOKUPS LOOK
WHERE CONS.COMPONENT_PATTERN_ID = PATS.PATTERN_ID(+)
AND CONS.PATTERN_BIT_ID = PBIT.PATTERN_BIT_ID(+)
AND CONS.AVAILABILITY = LOOK.LOOKUP_CODE (+)
AND ( (LOOK.LOOKUP_CODE IS NOT NULL
AND (((LOOK.LOOKUP_TYPE = 'AVAILABILITY' )
AND CONS.PATTERN_ID NOT IN (SELECT HPP.PATTERN_ID
FROM HR_PATTERN_PURPOSES HPP
WHERE HPP.PATTERN_PURPOSE = 'WORK')) OR (LOOK.LOOKUP_TYPE = 'WORK'
AND CONS.PATTERN_ID IN (SELECT HPP.PATTERN_ID
FROM HR_PATTERN_PURPOSES HPP
WHERE HPP.PATTERN_PURPOSE = 'WORK'))) OR (LOOK.LOOKUP_CODE IS NULL)))

Columns