VIEW: APPS.PSBFV_WS_FTE_LINES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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