PER_POSITION_BUDGETS_VL

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
POSITION_BUDGET_ID BUDGET_PERIOD_START_DATE BUDGET_PERIOD_END_DATE NAME CODE BUSINESS_UNIT_ID DEPARTMENT_ID LOCATION_ID ALLOCATED_HEADCOUNT ALLOCATED_FTE ALLOCATED_AMOUNT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT PPB.POSITION_BUDGET_ID, PPB.BUDGET_PERIOD_START_DATE, PPB.BUDGET_PERIOD_END_DATE, PPBTL.NAME, PPB.CODE, PPB.BUSINESS_UNIT_ID, PPB.DEPARTMENT_ID, PPB.LOCATION_ID, PPB.ALLOCATED_HEADCOUNT, PPB.ALLOCATED_FTE, PPB.ALLOCATED_AMOUNT, PPB.OBJECT_VERSION_NUMBER, PPB.CREATED_BY, PPB.CREATION_DATE, PPB.LAST_UPDATED_BY, PPB.LAST_UPDATE_DATE, PPB.LAST_UPDATE_LOGIN FROM PER_POSITION_BUDGETS PPB, PER_POSITION_BUDGETS_TL PPBTL WHERE PPB.POSITION_BUDGET_ID = PPBTL.POSITION_BUDGET_ID AND PPBTL.LANGUAGE = SYS_CONTEXT('USERENV', 'LANG')