[Home] [Help]
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
Name |
POSITION_FTE_LINE_ID |
POSITION_ID |
"_KF:POSITION_NAME" |
BUDGET_REVISION_ID |
BUDGET_REVISION_JUSTIFICATION |
BASE_LINE_VERSION |
START_DATE |
END_DATE |
FTE |