Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CLD.ROWID
, CLD.GLOBAL_WORKSHEET_ID
, CLD.LOCAL_WORKSHEET_ID
, WS.NAME
, BG.SHORT_NAME
, BC.NAME
, CLD.LAST_UPDATE_DATE
, CLD.LAST_UPDATED_BY
, CLD.LAST_UPDATE_LOGIN
, CLD.CREATED_BY
, CLD.CREATION_DATE
, CLD.ATTRIBUTE1
, CLD.ATTRIBUTE2
, CLD.ATTRIBUTE3
, CLD.ATTRIBUTE4
, CLD.ATTRIBUTE5
, CLD.ATTRIBUTE6
, CLD.ATTRIBUTE7
, CLD.ATTRIBUTE8
, CLD.ATTRIBUTE9
, CLD.ATTRIBUTE10
, CLD.CONTEXT
FROM PSB_WS_CONSOLIDATION_DETAILS CLD
, PSB_WORKSHEETS WS
, PSB_BUDGET_GROUPS BG
, PSB_BUDGET_CALENDARS BC
WHERE CLD.LOCAL_WORKSHEET_ID = WS.WORKSHEET_ID
AND WS.GLOBAL_WORKSHEET_FLAG = 'Y'
AND WS.WS_CREATION_COMPLETE = 'Y'
AND WS.BUDGET_GROUP_ID = BG.BUDGET_GROUP_ID
AND WS.BUDGET_CALENDAR_ID = BC.BUDGET_CALENDAR_ID