Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT DIM.ROWID
, DIM.DIMENSION_ID
, DIM.NAME
, DIM.TYPE
, DIM.DIMENSION_LEVEL
, PER.NAME
, GL.NAME
, DE.DATA_EXTRACT_NAME
, DIM.BUSINESS_GROUP_ID
, DIM.SET_OF_BOOKS_ID
, DIM.DATA_EXTRACT_ID
, DIM.DESCRIPTION
, DIM.OBJECT_NAME
, DIM.OBJECT_PREFIX
, DIM.VALUE_PREFIX
, DIM.ROW_LABEL
, DIM.ROW_LABEL_LENGTH
, DIM.COLUMN_LABEL
, DIM.COLUMN_LABEL_LENGTH
, DIM.SELECTOR_LABEL
, DIM.FREEZE_FLAG
, DIM.LAST_UPDATE_DATE
, DIM.LAST_UPDATED_BY
, DIM.LAST_UPDATE_LOGIN
, DIM.CREATION_DATE
, DIM.CREATED_BY
, DIM.CONTEXT
, DIM.ATTRIBUTE1
, DIM.ATTRIBUTE2
, DIM.ATTRIBUTE3
, DIM.ATTRIBUTE4
, DIM.ATTRIBUTE5
, DIM.ATTRIBUTE6
, DIM.ATTRIBUTE7
, DIM.ATTRIBUTE8
, DIM.ATTRIBUTE9
, DIM.ATTRIBUTE10
FROM PSB_DSS_DIMENSIONS DIM
, PER_BUSINESS_GROUPS PER
, GL_SETS_OF_BOOKS GL
, PSB_DATA_EXTRACTS DE
WHERE PER.BUSINESS_GROUP_ID(+) = DIM.BUSINESS_GROUP_ID
AND GL.SET_OF_BOOKS_ID(+) = DIM.SET_OF_BOOKS_ID
AND DE.DATA_EXTRACT_ID(+) = DIM.DATA_EXTRACT_ID