View: PSB_WS_LINE_YEAR_XL_V

Product:	PSB - Public Sector Budgeting
Description:
Implementation/DBA Data:	APPS.PSB_WS_LINE_YEAR_XL_V

View Text

SELECT WL.WORKSHEET_ID
, WAL.CODE_COMBINATION_ID
, WAL.ACCOUNT_TYPE
, WAL.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, SP.PRIORITY
, WAL.TEMPLATE_ID
, WAL.CURRENCY_CODE
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC1(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC2(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC3(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC4(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC5(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC6(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC7(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC8(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC9(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC10(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC11(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC12(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.YTD_AMOUNT
, 'F'
, WAL.ANNUAL_FTE
, 0))
FROM PSB_WS_LINES WL
, PSB_WS_ACCOUNT_LINES WAL
, PSB_SERVICE_PACKAGES SP
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 ( ( 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.CODE_COMBINATION_ID
, WAL.ACCOUNT_TYPE
, WAL.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, SP.PRIORITY
, WAL.TEMPLATE_ID
, WAL.CURRENCY_CODE

Columns