[Home] [Help] [Dependency Information]
Object Name: | PA_TODATE_BASE_BUDGET_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_TODATE_BASE_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_BASE | NUMBER | |||
BURDENED_COST_PTD_BASE | NUMBER | |||
REVENUE_PTD_BASE | NUMBER | |||
QUANTITY_PTD_BASE | NUMBER | |||
LABOR_QUANTITY_PTD_BASE | NUMBER | |||
RAW_COST_PP_BASE | NUMBER | |||
BURDENED_COST_PP_BASE | NUMBER | |||
REVENUE_PP_BASE | NUMBER | |||
QUANTITY_PP_BASE | NUMBER | |||
LABOR_QUANTITY_PP_BASE | NUMBER | |||
RAW_COST_YTD_BASE | NUMBER | |||
BURDENED_COST_YTD_BASE | NUMBER | |||
REVENUE_YTD_BASE | NUMBER | |||
QUANTITY_YTD_BASE | NUMBER | |||
LABOR_QUANTITY_YTD_BASE | NUMBER | |||
RAW_COST_ITD_BASE | NUMBER | |||
BURDENED_COST_ITD_BASE | NUMBER | |||
REVENUE_ITD_BASE | NUMBER | |||
QUANTITY_ITD_BASE | NUMBER | |||
LABOR_QUANTITY_ITD_BASE | NUMBER | |||
UNIT_OF_MEASURE_BASE | VARCHAR2 | (30) | The unit of measure of the budget in the pa period |
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_BASE
, BURDENED_COST_PTD_BASE
, REVENUE_PTD_BASE
, QUANTITY_PTD_BASE
, LABOR_QUANTITY_PTD_BASE
, RAW_COST_PP_BASE
, BURDENED_COST_PP_BASE
, REVENUE_PP_BASE
, QUANTITY_PP_BASE
, LABOR_QUANTITY_PP_BASE
, RAW_COST_YTD_BASE
, BURDENED_COST_YTD_BASE
, REVENUE_YTD_BASE
, QUANTITY_YTD_BASE
, LABOR_QUANTITY_YTD_BASE
, RAW_COST_ITD_BASE
, BURDENED_COST_ITD_BASE
, REVENUE_ITD_BASE
, QUANTITY_ITD_BASE
, LABOR_QUANTITY_ITD_BASE
, UNIT_OF_MEASURE_BASE
FROM APPS.PA_TODATE_BASE_BUDGET_V;
APPS.PA_TODATE_BASE_BUDGET_V is not referenced by any database object
|
|
|