FND Design Data [Home] [Help]

View: HR_COMPONENTLESS_PATTERNS_V

Product: PER - Human Resources
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.HR_COMPONENTLESS_PATTERNS_V
View Text

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

Columns

Name
PATTERN_NAME
PATTERN_ID