Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_WS_LINE_PERIOD_V |
SELECT WL.WORKSHEET_ID
, SUM( DECODE( NVL (WAL.POSITION_LINE_ID
, 0)
, 0
, WAL.ACCOUNT_LINE_ID
, 0 ) ) ACCOUNT_LINE_ID
, SUM( DECODE( NVL (WAL.POSITION_LINE_ID
, 0)
, 0
, 0
, 1 ) ) POSITION_ACCOUNT_FLAG
, WAL.ACCOUNT_TYPE
, WAL.CODE_COMBINATION_ID
, WAL.TEMPLATE_ID
, WAL.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, SP.PRIORITY
, WAL.BUDGET_GROUP_ID
, WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE
, SUM(WAL.ANNUAL_FTE ) ANNUAL_FTE
, WAL.CURRENCY_CODE
, WAL.SALARY_ACCOUNT_LINE
, SUM(WAL.YTD_AMOUNT) YTD
, SUM(WAL.PERIOD1_AMOUNT) PERIOD1_AMOUNT
, SUM(WAL.PERIOD2_AMOUNT) PERIOD2_AMOUNT
, SUM(WAL.PERIOD3_AMOUNT) PERIOD3_AMOUNT
, SUM(WAL.PERIOD4_AMOUNT) PERIOD4_AMOUNT
, SUM(WAL.PERIOD5_AMOUNT) PERIOD5_AMOUNT
, SUM(WAL.PERIOD6_AMOUNT) PERIOD6_AMOUNT
, SUM(WAL.PERIOD7_AMOUNT) PERIOD7_AMOUNT
, SUM(WAL.PERIOD8_AMOUNT) PERIOD8_AMOUNT
, SUM(WAL.PERIOD9_AMOUNT) PERIOD9_AMOUNT
, SUM(WAL.PERIOD10_AMOUNT) PERIOD10_AMOUNT
, SUM(WAL.PERIOD11_AMOUNT) PERIOD11_AMOUNT
, SUM(WAL.PERIOD12_AMOUNT) PERIOD12_AMOUNT
, 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_LINES WL
, PSB_WS_ACCOUNT_LINES WAL
, PSB_SERVICE_PACKAGES SP
, GL_CODE_COMBINATIONS CC
WHERE WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID
AND WL.VIEW_LINE_FLAG = 'Y'
AND WAL.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WAL.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND ( ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST = 0
AND WAL.END_STAGE_SEQ IS NULL) OR ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST BETWEEN WAL.START_STAGE_SEQ
AND NVL(WAL.END_STAGE_SEQ
, 9.99E125) ) ) GROUP BY WL.WORKSHEET_ID
, WAL.BUDGET_GROUP_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE
, SP.SHORT_NAME
, SP.PRIORITY
, WAL.ACCOUNT_TYPE
, WAL.TEMPLATE_ID
, WAL.CURRENCY_CODE
, WAL.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