View: PSB_ACCOUNT_POSITION_SETS_V

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

View Text

SELECT SETS.ROWID
, SETS.ACCOUNT_POSITION_SET_ID
, SETS.NAME
, SETS.SET_OF_BOOKS_ID
, SETS.DATA_EXTRACT_ID
, SETS.GLOBAL_OR_LOCAL_TYPE
, SETS.ACCOUNT_OR_POSITION_TYPE
, SETS.ATTRIBUTE_SELECTION_TYPE
, SETS.BUSINESS_GROUP_ID
, SETS.BUDGET_GROUP_ID
, SETS.MAINTAIN_STATUS
, SETS.LAST_MAINTAINED_DATE
, SETS.MAX_CODE_COMBINATION_ID
, SETS.USE_IN_BUDGET_GROUP_FLAG
, SETS.LAST_UPDATE_DATE
, SETS.LAST_UPDATED_BY
, SETS.LAST_UPDATE_LOGIN
, SETS.CREATED_BY
, SETS.CREATION_DATE
, SOBS.NAME
, EXTRACTS.DATA_EXTRACT_NAME
, BG.SHORT_NAME
, FL.MEANING
FROM PSB_ACCOUNT_POSITION_SETS SETS
, GL_SETS_OF_BOOKS SOBS
, PSB_DATA_EXTRACTS EXTRACTS
, PSB_BUDGET_GROUPS BG
, FND_LOOKUPS FL
WHERE SETS.SET_OF_BOOKS_ID = SOBS.SET_OF_BOOKS_ID(+)
AND SETS.DATA_EXTRACT_ID = EXTRACTS.DATA_EXTRACT_ID(+)
AND SETS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID (+)
AND FL.LOOKUP_TYPE = 'PSB_ACCOUNT_OR_POSITION_TYPE'
AND FL.LOOKUP_CODE = SETS.ACCOUNT_OR_POSITION_TYPE

Columns