VIEW: APPS.PSB_WS_FOLDER_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)