View: PSB_WS_FOLDER_V

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

View Text

SELECT WS.BUDGET_GROUP_ID
, BG.SHORT_NAME
, WS.WORKSHEET_ID
, WS.NAME
, WS.WORKSHEET_TYPE
, WS.BUDGET_BY_POSITION
, WS.CURRENT_STAGE_SEQ
, SUBSTR(BS.NAME
, 1
, 30)
, WS.STAGE_SET_ID
, WS.DATA_EXTRACT_ID
, DE.DATA_EXTRACT_NAME
, WS.GLOBAL_WORKSHEET_ID
, GWS.NAME
, WS.GLOBAL_WORKSHEET_OPTION
, WS.GLOBAL_WORKSHEET_FLAG
, WS.LOCAL_COPY_FLAG
, WS.FREEZE_FLAG
, DECODE(WS.SUBMITTED_BY
, NULL
, 'N'
, 'Y')
, SUBSTR(SFU.USER_NAME
, 1
, 30)
, WS.SUBMITTED_BY
, WS.DATE_SUBMITTED
, WS.CREATED_BY
, WS.CREATION_DATE
, NVL(WS.FEDERAL_WS_FLAG
, GWS.FEDERAL_WS_FLAG)
FROM PSB_BUDGET_GROUPS BG
, PSB_WORKSHEETS WS
, PSB_WORKSHEETS GWS
, PSB_DATA_EXTRACTS DE
, FND_USER SFU
, PSB_BUDGET_STAGES BS
WHERE BG.BUDGET_GROUP_ID = WS.BUDGET_GROUP_ID
AND WS.SUBMITTED_BY = SFU.USER_ID(+)
AND ( WS.GLOBAL_WORKSHEET_FLAG = 'N' OR (WS.GLOBAL_WORKSHEET_FLAG = 'Y'
AND WS.WS_CREATION_COMPLETE ='Y' ) )
AND WS.STAGE_SET_ID = BS.BUDGET_STAGE_SET_ID
AND WS.CURRENT_STAGE_SEQ = BS.SEQUENCE_NUMBER
AND WS.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID(+)
AND WS.GLOBAL_WORKSHEET_ID = GWS.WORKSHEET_ID(+)

Columns