[Home] [Help]
View: PSB_WS_FTE_LINES_V
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT WFL.POSITION_LINE_ID
, WFL.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC1
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC2
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC3
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC4
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC5
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC6
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC7
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC8
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC9
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC10
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC11
, WFL.ANNUAL_FTE
, 0))
, SUM(DECODE(WFL.BUDGET_YEAR_ID
, PSB_WS_ELEMENT_SETUP.GET_WS_ELEMENT_YEARC12
, WFL.ANNUAL_FTE
, 0))
FROM PSB_WS_FTE_LINES WFL
, PSB_BUDGET_PERIODS A
, PSB_BUDGET_YEAR_TYPES B
, PSB_SERVICE_PACKAGES SP
WHERE WFL.BUDGET_YEAR_ID = A.BUDGET_PERIOD_ID
AND A.BUDGET_YEAR_TYPE_ID = B.BUDGET_YEAR_TYPE_ID
AND WFL.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND B.YEAR_CATEGORY_TYPE IN ('CY'
, 'PP')
AND ( ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST = 0
AND WFL.END_STAGE_SEQ IS NULL) OR ( PSB_WS_MATRIX.GET_WS_LINE_YEAR_ST BETWEEN WFL.START_STAGE_SEQ
AND NVL(WFL.END_STAGE_SEQ
, 9.99E125) ) ) GROUP BY WFL.POSITION_LINE_ID
, WFL.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
Columns
Name |
POSITION_LINE_ID |
SERVICE_PACKAGE_ID |
SERVICE_PACKAGE_NAME |
COLUMN1 |
COLUMN2 |
COLUMN3 |
COLUMN4 |
COLUMN5 |
COLUMN6 |
COLUMN7 |
COLUMN8 |
COLUMN9 |
COLUMN10 |
COLUMN11 |
COLUMN12 |