VIEW: APPS.PSB_WS_SUMMARY_V

Source

View Text - Preformatted

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 ,WS.DESCRIPTION ,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

View Text - HTML Formatted

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
, WS.DESCRIPTION
, 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