[Home] [Help] [Dependency Information]
Object Name: | HRFV_MANPOWER_BUDGETS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_MANPOWER_BUDGETS |
Subobject Name: | |
Status: | VALID |
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.
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) |
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;
APPS.HRFV_MANPOWER_BUDGETS is not referenced by any database object
|
|
|