VIEW: APPS.PSB_WORKSHEETS_V

Source

View Text - Preformatted

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) ,WS.INCLUDE_GL_FORWARD_BALANCE 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(+)

View Text - HTML Formatted

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)
, WS.INCLUDE_GL_FORWARD_BALANCE
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(+)