eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PSB_WS_YEAR_AMOUNTS_V

Source

View Text - Preformatted


SELECT WL.WORKSHEET_ID , WAL.CODE_COMBINATION_ID ,WAL.SERVICE_PACKAGE_ID ,WAL.TEMPLATE_ID ,WAL.ACCOUNT_TYPE ,WAL.CURRENCY_CODE ,SUM( DECODE( NVL (WAL.POSITION_LINE_ID,0) ,0,0,1 ) ) POSITION_ACCOUNT_FLAG ,WAL.BUDGET_GROUP_ID ,SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC1(WAL.BUDGET_YEAR_ID,WAL.BALANCE_TYPE) , 'A',WAL.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 0)) ,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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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.ACCOUNT_LINE_ID, 'F',WAL.ACCOUNT_LINE_ID, 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 WHERE WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID AND WL.VIEW_LINE_FLAG = 'Y' 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.SERVICE_PACKAGE_ID, WAL.TEMPLATE_ID ,WAL.ACCOUNT_TYPE, WAL.CURRENCY_CODE , WAL.BUDGET_GROUP_ID

View Text - HTML Formatted

SELECT WL.WORKSHEET_ID
, WAL.CODE_COMBINATION_ID
, WAL.SERVICE_PACKAGE_ID
, WAL.TEMPLATE_ID
, WAL.ACCOUNT_TYPE
, WAL.CURRENCY_CODE
, SUM( DECODE( NVL (WAL.POSITION_LINE_ID
, 0)
, 0
, 0
, 1 ) ) POSITION_ACCOUNT_FLAG
, WAL.BUDGET_GROUP_ID
, SUM(DECODE(PSB_WS_MATRIX.GET_WS_LINE_YEARC1(WAL.BUDGET_YEAR_ID
, WAL.BALANCE_TYPE)
, 'A'
, WAL.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 0))
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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.ACCOUNT_LINE_ID
, 'F'
, WAL.ACCOUNT_LINE_ID
, 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
WHERE WL.ACCOUNT_LINE_ID = WAL.ACCOUNT_LINE_ID
AND WL.VIEW_LINE_FLAG = 'Y'
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.SERVICE_PACKAGE_ID
, WAL.TEMPLATE_ID
, WAL.ACCOUNT_TYPE
, WAL.CURRENCY_CODE
, WAL.BUDGET_GROUP_ID