Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT WS.ROWID
, WS.WORKSHEET_ID
, WS.BUDGET_GROUP_ID
, BG.SHORT_NAME
, WS.BUDGET_CALENDAR_ID
, BC.NAME
, WS.WORKSHEET_TYPE
, WS.NAME
, WS.DESCRIPTION
, WS.FREEZE_FLAG
, WS.STAGE_SET_ID
, WS.CURRENT_STAGE_SEQ
, WS.GLOBAL_WORKSHEET_FLAG
, WS.GLOBAL_WORKSHEET_ID
, WS.GLOBAL_WORKSHEET_OPTION
, WS.LOCAL_COPY_FLAG
, WS.COPY_OF_WORKSHEET_ID
, WS.ROUNDING_FACTOR
, WS.BUDGET_BY_POSITION
, WS.USE_REVISED_ELEMENT_RATES
, WS.NUM_PROPOSED_YEARS
, WS.NUM_YEARS_TO_ALLOCATE
, WS.GL_CUTOFF_PERIOD
, WS.BUDGET_VERSION_ID
, WS.GL_BUDGET_SET_ID
, GLS.GL_BUDGET_SET_NAME
, WS.INCLUDE_STAT_BALANCE
, WS.INCLUDE_TRANSLATED_BALANCE
, WS.INCLUDE_ADJUSTMENT_PERIODS
, WS.DATE_SUBMITTED
, WS.SUBMITTED_BY
, WS.DATA_EXTRACT_ID
, DE.DATA_EXTRACT_NAME
, WS1.DATA_EXTRACT_ID
, WS.PARAMETER_SET_ID
, PPSV.NAME
, WS1.PARAMETER_SET_ID
, WS.CONSTRAINT_SET_ID
, PCSV.NAME
, WS1.CONSTRAINT_SET_ID
, WS.ALLOCRULE_SET_ID
, PASV.NAME
, WS1.ALLOCRULE_SET_ID
, WS.WS_CREATION_COMPLETE
, WS.CREATE_NON_POS_LINE_ITEMS
, WS.APPLY_ELEMENT_PARAMETERS
, WS.APPLY_POSITION_PARAMETERS
, WS.CREATE_POSITIONS
, WS.CREATE_SUMMARY_TOTALS
, WS.APPLY_CONSTRAINTS
, WS.FLEX_MAPPING_SET_ID
, FMS.NAME
, WS.INCLUDE_GL_COMMIT_BALANCE
, WS.INCLUDE_GL_OBLIG_BALANCE
, WS.INCLUDE_GL_OTHER_BALANCE
, WS.INCLUDE_CBC_COMMIT_BALANCE
, WS.INCLUDE_CBC_OBLIG_BALANCE
, WS.INCLUDE_CBC_BUDGET_BALANCE
, WS.LAST_UPDATE_DATE
, WS.LAST_UPDATED_BY
, WS.LAST_UPDATE_LOGIN
, WS.CREATED_BY
, WS.CREATION_DATE
, WS.ATTRIBUTE1
, WS.ATTRIBUTE2
, WS.ATTRIBUTE3
, WS.ATTRIBUTE4
, WS.ATTRIBUTE5
, WS.ATTRIBUTE6
, WS.ATTRIBUTE7
, WS.ATTRIBUTE8
, WS.ATTRIBUTE9
, WS.ATTRIBUTE10
, WS.CONTEXT
, NVL(WS.FEDERAL_WS_FLAG
, WS1.FEDERAL_WS_FLAG)
FROM PSB_WORKSHEETS WS
, PSB_WORKSHEETS WS1
, PSB_BUDGET_GROUPS BG
, PSB_BUDGET_CALENDARS BC
, PSB_DATA_EXTRACTS DE
, PSB_PARAMETER_SETS_V PPSV
, PSB_CONSTRAINT_SETS_V PCSV
, PSB_ALLOCRULE_SETS_V PASV
, PSB_BUDGET_STAGE_SETS BSS
, PSB_GL_BUDGET_SETS GLS
, PSB_FLEX_MAPPING_SETS FMS
WHERE WS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND WS.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID
AND WS.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID(+)
AND WS.PARAMETER_SET_ID = PPSV.PARAMETER_SET_ID(+)
AND WS.CONSTRAINT_SET_ID = PCSV.CONSTRAINT_SET_ID(+)
AND WS.ALLOCRULE_SET_ID = PASV.ALLOCRULE_SET_ID(+)
AND WS.STAGE_SET_ID = BSS.BUDGET_STAGE_SET_ID(+)
AND WS.GLOBAL_WORKSHEET_ID = WS1.WORKSHEET_ID (+)
AND WS.GL_BUDGET_SET_ID = GLS.GL_BUDGET_SET_ID (+)
AND WS.FLEX_MAPPING_SET_ID = FMS.FLEX_MAPPING_SET_ID(+)