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.

[Home] [Help]

View: PSBFV_WS_FTE_LINES

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

View Text

SELECT POS.NAME
, SP.SHORT_NAME
, BP.NAME
, WFL.ANNUAL_FTE
, WFL.PERIOD1_FTE
, WFL.PERIOD2_FTE
, WFL.PERIOD3_FTE
, WFL.PERIOD4_FTE
, WFL.PERIOD5_FTE
, WFL.PERIOD6_FTE
, WFL.PERIOD7_FTE
, WFL.PERIOD8_FTE
, WFL.PERIOD9_FTE
, WFL.PERIOD10_FTE
, WFL.PERIOD11_FTE
, WFL.PERIOD12_FTE
, WFL.START_STAGE_SEQ
, WFL.CURRENT_STAGE_SEQ
, WFL.END_STAGE_SEQ
, WFL.POSITION_LINE_ID
, WFL.SERVICE_PACKAGE_ID
, WFL.BUDGET_YEAR_ID
, WFL.FTE_LINE_ID
, WFL.LAST_UPDATE_DATE
, WFL.LAST_UPDATED_BY
, WFL.CREATED_BY
, WFL.CREATION_DATE
FROM PSB_WS_FTE_LINES WFL
, PSB_WS_POSITION_LINES WPL
, PSB_POSITIONS POS
, PSB_BUDGET_PERIODS BP
, PSB_SERVICE_PACKAGES SP
WHERE WFL.POSITION_LINE_ID = WPL.POSITION_LINE_ID
AND WPL.POSITION_ID = POS.POSITION_ID
AND BP.BUDGET_PERIOD_ID = WFL.BUDGET_YEAR_ID
AND SP.SERVICE_PACKAGE_ID = WFL.SERVICE_PACKAGE_ID WITH READ ONLY

Columns

Name
POSITION_NAME
SERVICE_PACKAGE_NAME
BUDGET_YEAR_NAME
ANNUAL_FTE
PERIOD1_FTE
PERIOD2_FTE
PERIOD3_FTE
PERIOD4_FTE
PERIOD5_FTE
PERIOD6_FTE
PERIOD7_FTE
PERIOD8_FTE
PERIOD9_FTE
PERIOD10_FTE
PERIOD11_FTE
PERIOD12_FTE
START_STAGE_SEQ
CURRENT_STAGE_SEQ
END_STAGE_SEQ
POSITION_LINE_ID
SERVICE_PACKAGE_ID
BUDGET_YEAR_ID
FTE_LINE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE