View: PSBFV_POSITION_FTE

Product:	PSB - Public Sector Budgeting
Description:	Provides Details about Position Fte from Position Control tables.
Implementation/DBA Data:	APPS.PSBFV_POSITION_FTE

View Text

SELECT POSITION_FTE_LINE_ID
, PPF.POSITION_ID
, '_KF:PSB:BPS:PKFV:_CO'
, PPF.BUDGET_REVISION_ID
, BR.JUSTIFICATION
, PPF.BASE_LINE_VERSION
, START_DATE
, END_DATE
, FTE
FROM PSB_POSITION_FTE PPF
, PSB_BUDGET_REVISIONS BR
, PSB_POSITIONS POS
, PSB_POSITION_DEFINITIONS_KFV PKFV
WHERE PPF.POSITION_ID = POS.POSITION_ID
AND POS.POSITION_DEFINITION_ID = PKFV.POSITION_DEFINITION_ID
AND PPF.BUDGET_REVISION_ID = BR.BUDGET_REVISION_ID(+) WITH READ ONLY

Columns