[Home] [Help]
View: PSBFV_ACCOUNT_SETS
| Product: | PSB - Public Sector Budgeting (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT SETS.NAME
, DECODE(SETS.GLOBAL_OR_LOCAL_TYPE
, 'G'
, 'Y'
, 'N')
, SOB.NAME
, SETS.ACCOUNT_POSITION_SET_ID
, SETS.SET_OF_BOOKS_ID
, SETS.LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY
, SETS.CREATED_BY
, SETS.CREATION_DATE
FROM PSB_ACCOUNT_POSITION_SETS SETS
, GL_SETS_OF_BOOKS SOB
WHERE ACCOUNT_OR_POSITION_TYPE = 'A'
AND SOB.SET_OF_BOOKS_ID = SETS.SET_OF_BOOKS_ID WITH READ ONLY
Columns
| Name |
| ACCOUNT_SET_NAME |
| ACCOUNT_SET_SHAREABLE_FLAG |
| SET_OF_BOOKS_NAME |
| ACCOUNT_SET_ID |
| SET_OF_BOOKS_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |