View: PSBFV_BUDGET_WORKSHEETS

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

View Text

SELECT WS.NAME
, BG.NAME
, BC.NAME
, BS.NAME
, DE.DATA_EXTRACT_NAME
, PESP.NAME
, PESC.NAME
, PESA.NAME
, '_LA:WORKSHEET_TYPE:FND_LOOKUPS:PSB_WORKSHEET_TYPES:MEANING'
, WS.DESCRIPTION
, WS.CURRENT_STAGE_SEQ
, '_DF:PSB:PSB_WORKSHEETS:WS'
, WS.USE_REVISED_ELEMENT_RATES
, WS.BUDGET_BY_POSITION
, WS.INCLUDE_TRANSLATED_BALANCE
, WS.INCLUDE_ADJUSTMENT_PERIODS
, WS.INCLUDE_STAT_BALANCE
, WS.NUM_PROPOSED_YEARS
, WS.NUM_YEARS_TO_ALLOCATE
, WS.GL_CUTOFF_PERIOD
, WS.ROUNDING_FACTOR
, GLV.BUDGET_NAME
, GLS.GL_BUDGET_SET_NAME
, WS.DATE_SUBMITTED
, WS.SUBMITTED_BY
, WS.FREEZE_FLAG
, WS.WORKSHEET_ID
, WS.BUDGET_GROUP_ID
, WS.BUDGET_CALENDAR_ID
, WS.STAGE_SET_ID
, WS.GLOBAL_WORKSHEET_ID
, WS.BUDGET_VERSION_ID
, WS.GL_BUDGET_SET_ID
, WS.DATA_EXTRACT_ID
, WS.PARAMETER_SET_ID
, WS.CONSTRAINT_SET_ID
, WS.ALLOCRULE_SET_ID
, WS.LAST_UPDATE_DATE
, WS.LAST_UPDATED_BY
, WS.CREATED_BY
, WS.CREATION_DATE
FROM PSB_BUDGET_GROUPS BG
, PSB_WORKSHEETS WS
, PSB_BUDGET_CALENDARS BC
, PSB_BUDGET_STAGES BS
, PSB_DATA_EXTRACTS DE
, PSB_ENTITY_SET PESP
, PSB_ENTITY_SET PESC
, PSB_ENTITY_SET PESA
, GL_BUDGET_VERSIONS GLV
, PSB_GL_BUDGET_SETS GLS
WHERE WS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND WS.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID
AND WS.BUDGET_GROUP_ID IN ( SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUPS
WHERE BUDGET_GROUP_TYPE = 'R'
AND SYSDATE BETWEEN EFFECTIVE_START_DATE
AND NVL(EFFECTIVE_END_DATE
, SYSDATE) START WITH BUDGET_GROUP_ID IN (SELECT BUDGET_GROUP_ID
FROM PSB_BUDGET_GROUP_RESP
WHERE RESPONSIBILITY_ID = FND_GLOBAL.RESP_ID) CONNECT BY PRIOR BUDGET_GROUP_ID = PARENT_BUDGET_GROUP_ID )
AND WS.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID(+)
AND WS.STAGE_SET_ID = BS.BUDGET_STAGE_SET_ID
AND WS.CURRENT_STAGE_SEQ = BS.SEQUENCE_NUMBER
AND WS.PARAMETER_SET_ID = PESP.ENTITY_SET_ID(+)
AND WS.CONSTRAINT_SET_ID = PESC.ENTITY_SET_ID(+)
AND WS.ALLOCRULE_SET_ID = PESA.ENTITY_SET_ID(+)
AND WS.BUDGET_VERSION_ID = GLV.BUDGET_VERSION_ID(+)
AND WS.GL_BUDGET_SET_ID = GLS.GL_BUDGET_SET_ID (+) WITH READ ONLY

Columns