DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRFV_MANPOWER_BUDGETS

Object Details
Object Name: HRFV_MANPOWER_BUDGETS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HRFV_MANPOWER_BUDGETS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This view shows workforce budgets, past, present and future, planned and actual, defined for your enterprise. The actual values are derived as of the end of the budget period.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
BUDGET_NAME VARCHAR2 (30) Yes
BUDGET_MEASUREMENT_TYPE VARCHAR2 (4000)

BUDGET_MEASUREMENT_CODE VARCHAR2 (30)
BUDGET_FREQUENCY VARCHAR2 (30) Yes
BUDGET_VERSION_NUMBER VARCHAR2 (30) Yes
BUDGET_VERSION_START_DATE DATE
Yes
BUDGET_VERSION_END_DATE DATE


BUDGET_PERIOD_NAME VARCHAR2 (70) Yes
BUDGET_PERIOD_START_DATE DATE
Yes
BUDGET_PERIOD_END_DATE DATE
Yes
PLANNED_VALUE NUMBER (22)

ACTUAL_VALUE NUMBER


ORGANIZATION_NAME VARCHAR2 (240)

JOB_NAME VARCHAR2 (700)

POSITION_NAME VARCHAR2 (240)

GRADE_NAME VARCHAR2 (240)

_DF:BUDGETS CHAR (23)

_DF:BDGVER CHAR (32)

BUDGET_ID NUMBER (15) Yes
BUDGET_PERIOD_ID NUMBER (15) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
GRADE_ID NUMBER (15)

JOB_ID NUMBER (15)

ORGANIZATION_ID NUMBER (15)

POSITION_ID NUMBER (15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUSINESS_GROUP_NAME
,      BUDGET_NAME
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_MEASUREMENT_CODE
,      BUDGET_FREQUENCY
,      BUDGET_VERSION_NUMBER
,      BUDGET_VERSION_START_DATE
,      BUDGET_VERSION_END_DATE
,      BUDGET_PERIOD_NAME
,      BUDGET_PERIOD_START_DATE
,      BUDGET_PERIOD_END_DATE
,      PLANNED_VALUE
,      ACTUAL_VALUE
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      GRADE_NAME
,      _DF:BUDGETS
,      _DF:BDGVER
,      BUDGET_ID
,      BUDGET_PERIOD_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      JOB_ID
,      ORGANIZATION_ID
,      POSITION_ID
FROM APPS.HRFV_MANPOWER_BUDGETS;

Dependencies

[top of page]

APPS.HRFV_MANPOWER_BUDGETS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_ALL_POSITIONS_F_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_DISCOVERER - show dependent code
SynonymPAY_CALENDARS
SynonymPER_BUDGETS
SynonymPER_BUDGET_ELEMENTS
SynonymPER_BUDGET_VALUES
SynonymPER_BUDGET_VERSIONS
SynonymPER_GRADES_TL
SynonymPER_JOBS_TL
SynonymPER_TIME_PERIODS

APPS.HRFV_MANPOWER_BUDGETS is not referenced by any database object