Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_WS_SUMMARY_V |
SELECT WS.ROWID
, BG.BUDGET_GROUP_ID
, DECODE (BG.ROOT_BUDGET_GROUP
, 'Y'
, BG.BUDGET_GROUP_ID
, BG.ROOT_BUDGET_GROUP_ID)
, BG.NAME
, BG.SHORT_NAME
, WS.WORKSHEET_ID
, WS.NAME
, PSB_WS_OPS_PVT.GET_WS_DESCRIPTION(WS.WORKSHEET_ID
, BG.NAME)
, DE.DATA_EXTRACT_ID
, DE.DATA_EXTRACT_NAME
, DE.BUSINESS_GROUP_ID
, WS.WORKSHEET_TYPE
, WS.GLOBAL_WORKSHEET_FLAG
, WS.GLOBAL_WORKSHEET_OPTION
, NVL(WS.GLOBAL_WORKSHEET_ID
, WS.WORKSHEET_ID)
, NVL(GWS.NAME
, WS.NAME)
, NVL(GWS.BUDGET_CALENDAR_ID
, WS.BUDGET_CALENDAR_ID)
, WS.BUDGET_CALENDAR_ID
, DECODE (BG.ROOT_BUDGET_GROUP
, 'Y'
, BG.SET_OF_BOOKS_ID
, BG.ROOT_SET_OF_BOOKS_ID)
, DECODE (BG.ROOT_BUDGET_GROUP
, 'Y'
, BG.SOB_NAME
, BG.ROOT_SOB_NAME)
, DECODE(BG.ROOT_BUDGET_GROUP
, 'Y'
, BG.CHART_OF_ACCOUNTS_ID
, BG.ROOT_CHART_OF_ACCOUNTS_ID)
, DECODE(BG.ROOT_BUDGET_GROUP
, 'Y'
, BG.CURRENCY_CODE
, BG.ROOT_CURRENCY_CODE)
, WS.STAGE_SET_ID
, WS.CURRENT_STAGE_SEQ
, SUBSTR(BS.NAME
, 1
, 30)
, WS.FREEZE_FLAG
, WS.BUDGET_BY_POSITION
, WS.LOCAL_COPY_FLAG
, WS.COPY_OF_WORKSHEET_ID
, WS.DATE_SUBMITTED
, WS.SUBMITTED_BY
, SUBSTR(SFND.USER_NAME
, 1
, 30)
, SUBSTR(CFND.USER_NAME
, 1
, 30)
, 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
FROM PSB_WORKSHEETS WS
, PSB_WORKSHEETS GWS
, PSB_BUDGET_GROUPS_V BG
, PSB_DATA_EXTRACTS DE
, PSB_BUDGET_STAGES BS
, FND_USER SFND
, FND_USER CFND
WHERE WS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND WS.CREATED_BY = CFND.USER_ID(+)
AND WS.SUBMITTED_BY = SFND.USER_ID(+)
AND WS.DATA_EXTRACT_ID = DE.DATA_EXTRACT_ID (+)
AND WS.GLOBAL_WORKSHEET_ID = GWS.WORKSHEET_ID (+)
AND WS.STAGE_SET_ID = BS.BUDGET_STAGE_SET_ID
AND WS.CURRENT_STAGE_SEQ = BS.SEQUENCE_NUMBER