VIEW: APPS.HR_PATTERN_CONSTRUCTIONS_V

Source

View Text - Preformatted

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)))

View Text - HTML Formatted

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)))