Product: | PSB - Public Sector Budgeting (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT WA.WORKSHEET_ID
, WA.ELEMENT_SET_ID
, WA.POSITION_LINE_ID
, WA.BUDGET_GROUP_ID
, WA.CODE_COMBINATION_ID
, WA.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, WA.TEMPLATE_ID
, WA.CURRENCY_CODE
, WA.STAGE_SET_ID
, WA.ACCOUNT_TYPE
, WA.SALARY_ACCOUNT_LINE
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
FROM PSB_WS_POSITION_ACCOUNTS_V WA
, GL_CODE_COMBINATIONS CC
, PSB_SERVICE_PACKAGES SP
WHERE WA.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WA.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID