SELECT PAT.PATTERN_NAME PATTERN_NAME , PAT.PATTERN_ID PATTERN_ID FROM HR_PATTERN_CONSTRUCTIONS CON, HR_PATTERNS PAT WHERE PAT.PATTERN_ID = CON.COMPONENT_PATTERN_ID (+) AND CON.COMPONENT_PATTERN_ID IS NULL
View Text - HTML Formatted
SELECT PAT.PATTERN_NAME PATTERN_NAME , PAT.PATTERN_ID PATTERN_ID FROM HR_PATTERN_CONSTRUCTIONS CON , HR_PATTERNS PAT WHERE PAT.PATTERN_ID = CON.COMPONENT_PATTERN_ID (+) AND CON.COMPONENT_PATTERN_ID IS NULL