[Home] [Help]
View: PSB_DSS_HIERARCHIES_V
Product: | PSB - Public Sector Budgeting |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
ROW_ID |
HIERARCHY_ID |
NAME |
DIMENSION_ID |
DIMENSION_NAME |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATION_DATE |
CREATED_BY |
CONTEXT |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |