Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT HIER.ROWID
, HIER.HIERARCHY_ID
, HIER.NAME
, HIER.DIMENSION_ID
, DIM.NAME
, HIER.DESCRIPTION
, HIER.LAST_UPDATE_DATE
, HIER.LAST_UPDATED_BY
, HIER.LAST_UPDATE_LOGIN
, HIER.CREATION_DATE
, HIER.CREATED_BY
, HIER.CONTEXT
, HIER.ATTRIBUTE1
, HIER.ATTRIBUTE2
, HIER.ATTRIBUTE3
, HIER.ATTRIBUTE4
, HIER.ATTRIBUTE5
, HIER.ATTRIBUTE6
, HIER.ATTRIBUTE7
, HIER.ATTRIBUTE8
, HIER.ATTRIBUTE9
, HIER.ATTRIBUTE10
FROM PSB_DSS_HIERARCHIES HIER
, PSB_DSS_DIMENSIONS DIM
WHERE HIER.DIMENSION_ID = DIM.DIMENSION_ID