Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT FDISET.ROWID
, FDISET.FIN_DATA_SET_ID
, FDISET.NAME
, FDISET.SET_OF_BOOKS_ID
, GL.NAME
, FDISET.BUSINESS_GROUP_ID
, PER.NAME
, FDISET.FREEZE_FLAG
, FDISET.DESCRIPTION
, FDISET.LAST_UPDATE_DATE
, FDISET.LAST_UPDATED_BY
, FDISET.LAST_UPDATE_LOGIN
, FDISET.CREATED_BY
, FDISET.CREATION_DATE
, FDISET.CONTEXT
, FDISET.ATTRIBUTE1
, FDISET.ATTRIBUTE2
, FDISET.ATTRIBUTE3
, FDISET.ATTRIBUTE4
, FDISET.ATTRIBUTE5
, FDISET.ATTRIBUTE6
, FDISET.ATTRIBUTE7
, FDISET.ATTRIBUTE8
, FDISET.ATTRIBUTE9
, FDISET.ATTRIBUTE10
FROM PSB_DSS_FIN_DATA_SETS FDISET
, GL_SETS_OF_BOOKS GL
, PER_BUSINESS_GROUPS PER
WHERE FDISET.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID(+)
AND FDISET.BUSINESS_GROUP_ID = PER.BUSINESS_GROUP_ID(+)