Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT FLT.ROWID
, FLT.FILTER_ID
, FLT.NAME
, FLT.TYPE
, FLT.APPLICATION_COLUMN_NAME
, FLT.ID_FLEX_CODE
, FLT.ID_FLEX_NUM
, FLT.ACCOUNT_SEGMENT_NAME
, FLT.POSITION_SEGMENT_NAME
, FLT.POSITION_ATTRIBUTE_NAME
, FLT.POSITION_DIMENSION_TYPE
, PER.NAME
, GL.NAME
, DE.DATA_EXTRACT_NAME
, FLT.BUSINESS_GROUP_ID
, FLT.SET_OF_BOOKS_ID
, FLT.DATA_EXTRACT_ID
, FLT.DESCRIPTION
, FLT.LAST_UPDATE_DATE
, FLT.LAST_UPDATED_BY
, FLT.LAST_UPDATE_LOGIN
, FLT.CREATION_DATE
, FLT.CREATED_BY
, FLT.CONTEXT
, FLT.ATTRIBUTE1
, FLT.ATTRIBUTE2
, FLT.ATTRIBUTE3
, FLT.ATTRIBUTE4
, FLT.ATTRIBUTE5
, FLT.ATTRIBUTE6
, FLT.ATTRIBUTE7
, FLT.ATTRIBUTE8
, FLT.ATTRIBUTE9
, FLT.ATTRIBUTE10
FROM PSB_DSS_FILTERS FLT
, PER_BUSINESS_GROUPS PER
, GL_SETS_OF_BOOKS GL
, PSB_DATA_EXTRACTS DE
WHERE PER.BUSINESS_GROUP_ID(+) = FLT.BUSINESS_GROUP_ID
AND GL.SET_OF_BOOKS_ID(+) = FLT.SET_OF_BOOKS_ID
AND DE.DATA_EXTRACT_ID(+) = FLT.DATA_EXTRACT_ID