FND Design Data [Home] [Help]

View: RG_SRS_DSS_HIERARCHIES_V

Product: RG - Application Report Generator
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.RG_SRS_DSS_HIERARCHIES_V
View Text

SELECT MEANING NAME
, -1 HIERARCHY_ID
, 'GL#' ID_FLEX_CODE
, -100 ID_FLEX_NUM
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL' UNION SELECT NAME
, HIERARCHY_ID
, ID_FLEX_CODE
, ID_FLEX_NUM
FROM RG_DSS_HIERARCHIES

Columns

Name
NAME
HIERARCHY_ID
ID_FLEX_CODE
ID_FLEX_NUM