[Home] [Help] [Dependency Information]
Object Name: | PA_TODATE_ORIG_BUDGET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TODATE_ORIG_BUDGET_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project for which the budget is entered |
TASK_ID | NUMBER | (15) | Yes | The identifier of the task for which the budget is entered |
BUDGET_TYPE_CODE | VARCHAR2 | (30) | The type of budget | |
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Yes | The identifier of the resource list member used for the budget |
RESOURCE_ALIAS | VARCHAR2 | (80) | ||
RESOURCE_LIST_ID | NUMBER | (15) | Yes | The identifier of the resource list used for the budget |
RESOURCE_ID | NUMBER | (15) | Yes | The identifier of the resource used for the budget |
START_DATE | DATE | Yes | Start date of the budget line | |
END_DATE | DATE | Yes | End date of the budget line | |
RESOURCE_ACCUMULATED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if the budget version has been accumulated |
RAW_COST | NUMBER | |||
BURDENED_COST | NUMBER | |||
REVENUE | NUMBER | |||
QUANTITY | NUMBER | |||
LABOR_QUANTITY | NUMBER | |||
RAW_COST_PTD_ORIG | NUMBER | |||
BURDENED_COST_PTD_ORIG | NUMBER | |||
REVENUE_PTD_ORIG | NUMBER | |||
QUANTITY_PTD_ORIG | NUMBER | |||
LABOR_QUANTITY_PTD_ORIG | NUMBER | |||
RAW_COST_PP_ORIG | NUMBER | |||
BURDENED_COST_PP_ORIG | NUMBER | |||
REVENUE_PP_ORIG | NUMBER | |||
QUANTITY_PP_ORIG | NUMBER | |||
LABOR_QUANTITY_PP_ORIG | NUMBER | |||
RAW_COST_YTD_ORIG | NUMBER | |||
BURDENED_COST_YTD_ORIG | NUMBER | |||
REVENUE_YTD_ORIG | NUMBER | |||
QUANTITY_YTD_ORIG | NUMBER | |||
LABOR_QUANTITY_YTD_ORIG | NUMBER | |||
RAW_COST_ITD_ORIG | NUMBER | |||
BURDENED_COST_ITD_ORIG | NUMBER | |||
REVENUE_ITD_ORIG | NUMBER | |||
QUANTITY_ITD_ORIG | NUMBER | |||
LABOR_QUANTITY_ITD_ORIG | NUMBER | |||
UNIT_OF_MEASURE_ORIG | VARCHAR2 | (30) | The unit of measure of the budget in the pa period. This is the unit of measure of the resource |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, RESOURCE_LIST_MEMBER_ID
, RESOURCE_ALIAS
, RESOURCE_LIST_ID
, RESOURCE_ID
, START_DATE
, END_DATE
, RESOURCE_ACCUMULATED_FLAG
, RAW_COST
, BURDENED_COST
, REVENUE
, QUANTITY
, LABOR_QUANTITY
, RAW_COST_PTD_ORIG
, BURDENED_COST_PTD_ORIG
, REVENUE_PTD_ORIG
, QUANTITY_PTD_ORIG
, LABOR_QUANTITY_PTD_ORIG
, RAW_COST_PP_ORIG
, BURDENED_COST_PP_ORIG
, REVENUE_PP_ORIG
, QUANTITY_PP_ORIG
, LABOR_QUANTITY_PP_ORIG
, RAW_COST_YTD_ORIG
, BURDENED_COST_YTD_ORIG
, REVENUE_YTD_ORIG
, QUANTITY_YTD_ORIG
, LABOR_QUANTITY_YTD_ORIG
, RAW_COST_ITD_ORIG
, BURDENED_COST_ITD_ORIG
, REVENUE_ITD_ORIG
, QUANTITY_ITD_ORIG
, LABOR_QUANTITY_ITD_ORIG
, UNIT_OF_MEASURE_ORIG
FROM APPS.PA_TODATE_ORIG_BUDGET_V;
APPS.PA_TODATE_ORIG_BUDGET_V is not referenced by any database object
|
|
|