[Home] [Help]
| Product: | PSB - Public Sector Budgeting |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT FDI.ROWID
, FDI.FIN_DATA_ITEM_ID
, FDI.NAME
, FDI.FDI_LEVEL
, FDI.OBJECT_NAME
, FDI.COLUMN_LABEL
, FDI.ROW_LABEL
, FDI.SET_OF_BOOKS_ID
, GL.NAME
, FDI.BUSINESS_GROUP_ID
, PER.NAME
, FDI.BALANCE_TYPE
, LK.MEANING
, FDI.CURRENCY_CODE
, FDI.FREEZE_FLAG
, FDI.LAST_UPDATE_DATE
, FDI.LAST_UPDATED_BY
, FDI.LAST_UPDATE_LOGIN
, FDI.CREATED_BY
, FDI.CREATION_DATE
, FDI.DESCRIPTION
, FDI.CONTEXT
, FDI.ATTRIBUTE1
, FDI.ATTRIBUTE2
, FDI.ATTRIBUTE3
, FDI.ATTRIBUTE4
, FDI.ATTRIBUTE5
, FDI.ATTRIBUTE6
, FDI.ATTRIBUTE7
, FDI.ATTRIBUTE8
, FDI.ATTRIBUTE9
, FDI.ATTRIBUTE10
FROM PSB_DSS_FIN_DATA_ITEMS FDI
, GL_SETS_OF_BOOKS GL
, PER_BUSINESS_GROUPS PER
, FND_LOOKUPS LK
WHERE FDI.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID(+)
AND FDI.BUSINESS_GROUP_ID = PER.BUSINESS_GROUP_ID(+)
AND 'PSB_BALANCE_TYPE' = LK.LOOKUP_TYPE(+)
AND FDI.BALANCE_TYPE = LK.LOOKUP_CODE(+)