View: PSBFV_ACCOUNT_SET_LISTS

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSBFV_ACCOUNT_SET_LISTS

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