VIEW: APPS.RG_SRS_DSS_HIERARCHIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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