[Home] [Help]
View: PSBFV_ACCOUNT_SET_LISTS
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SOB.NAME
, ST.NAME
, '_KF:SQLGL:GL#:GCC'
, BP.ACCOUNT_POSITION_SET_ID
, BP.CODE_COMBINATION_ID
, BP.SET_OF_BOOKS_ID
, BP.LAST_UPDATE_DATE
, BP.LAST_UPDATED_BY
, BP.CREATED_BY
, BP.CREATION_DATE
FROM PSB_BUDGET_ACCOUNTS BP
, GL_SETS_OF_BOOKS SOB
, GL_CODE_COMBINATIONS GCC
, PSB_ACCOUNT_POSITION_SETS ST
WHERE BP.ACCOUNT_POSITION_SET_ID = ST.ACCOUNT_POSITION_SET_ID
AND BP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
AND BP.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY
Columns
Name |
SET_OF_BOOKS_NAME |
ACCOUNT_SET_NAME |
"_KF:GL_ACCOUNT" |
ACCOUNT_SET_ID |
CODE_COMBINATION_ID |
SET_OF_BOOKS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |