Product: | RG - Application Report Generator |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.RG_DSS_HIERARCHIES_V |
SELECT HRC.ROWID ROW_ID
, HRC.HIERARCHY_ID
, HRC.NAME
, HRC.ID_FLEX_CODE
, HRC.ID_FLEX_NUM
, HRC.DIMENSION_ID
, DIM.NAME DIMENSION_NAME
, HRC.DESCRIPTION
, HRC.LAST_UPDATE_DATE
, HRC.LAST_UPDATED_BY
, HRC.LAST_UPDATE_LOGIN
, HRC.CREATION_DATE
, HRC.CREATED_BY
, HRC.CONTEXT
, HRC.ATTRIBUTE1
, HRC.ATTRIBUTE2
, HRC.ATTRIBUTE3
, HRC.ATTRIBUTE4
, HRC.ATTRIBUTE5
, HRC.ATTRIBUTE6
, HRC.ATTRIBUTE7
, HRC.ATTRIBUTE8
, HRC.ATTRIBUTE9
, HRC.ATTRIBUTE10
, HRC.ATTRIBUTE11
, HRC.ATTRIBUTE12
, HRC.ATTRIBUTE13
, HRC.ATTRIBUTE14
, HRC.ATTRIBUTE15
FROM RG_DSS_HIERARCHIES HRC
, RG_DSS_DIMENSIONS DIM
WHERE HRC.DIMENSION_ID = DIM.DIMENSION_ID