Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT DIMMAP.ROWID
, DIMMAP.DIMENSION_ID
, DIMMAP.SEQUENCE
, DIMMAP.MAX_DESC_SIZE
, FLT.FILTER_ID
, FLT.NAME
, DIMMAP.ACCOUNT_TYPE
, DIMMAP.APPLICATION_COLUMN_NAME
, DIMMAP.ID_FLEX_CODE
, DIMMAP.ID_FLEX_NUM
, DIMMAP.ACCOUNT_SEGMENT_NAME
, DIMMAP.POSITION_SEGMENT_NAME
, DIMMAP.POSITION_ATTRIBUTE_NAME
, DIMMAP.SEGMENT_VALUE_LENGTH
, DIMMAP.POSITION_DIMENSION_TYPE
, DIMMAP.ATTRIBUTE_ID
, DIMMAP.LAST_UPDATE_DATE
, DIMMAP.LAST_UPDATED_BY
, DIMMAP.LAST_UPDATE_LOGIN
, DIMMAP.CREATED_BY
, DIMMAP.CREATION_DATE
, DIMMAP.CONTEXT
, DIMMAP.ATTRIBUTE1
, DIMMAP.ATTRIBUTE2
, DIMMAP.ATTRIBUTE3
, DIMMAP.ATTRIBUTE4
, DIMMAP.ATTRIBUTE5
, DIMMAP.ATTRIBUTE6
, DIMMAP.ATTRIBUTE7
, DIMMAP.ATTRIBUTE8
, DIMMAP.ATTRIBUTE9
, DIMMAP.ATTRIBUTE10
FROM PSB_DSS_DIMENSION_MAPPINGS DIMMAP
, PSB_DSS_FILTERS FLT
WHERE DIMMAP.FILTER_ID = FLT.FILTER_ID (+)