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

VIEW: APPS.PA_TODATE_BASE_ORIG_BUDGET_V

Object Details
Object Name: PA_TODATE_BASE_ORIG_BUDGET_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_TODATE_BASE_ORIG_BUDGET_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
RESOURCE_ACCUMULATED_FLAG VARCHAR2 (1) Yes Flag that indicates if the budget version has been accumulated
BASE_RAW_COST NUMBER

BASE_BURDENED_COST NUMBER

BASE_REVENUE NUMBER

BASE_QUANTITY NUMBER

BASE_LABOR_QUANTITY NUMBER

ORIG_RAW_COST NUMBER

ORIG_BURDENED_COST NUMBER

ORIG_REVENUE NUMBER

ORIG_QUANTITY NUMBER

ORIG_LABOR_QUANTITY NUMBER

RAW_COST_PTD_BASE NUMBER

Raw cost of current budget line - for the pa period
BURDENED_COST_PTD_BASE NUMBER

Burdened cost of current budget line - for the pa period
REVENUE_PTD_BASE NUMBER

Revenue of current budget line - for the pa period
QUANTITY_PTD_BASE NUMBER

Quantity of current budget line - for the pa period
LABOR_QUANTITY_PTD_BASE NUMBER

Labor Quantity of current budget line - for the pa period
RAW_COST_PP_BASE NUMBER

Raw cost of current budget line - for the previous period
BURDENED_COST_PP_BASE NUMBER

Burdened cost of current budget line - for the previous period
REVENUE_PP_BASE NUMBER

Revenue of current budget line - for the previous period
QUANTITY_PP_BASE NUMBER

Quantity of current budget line - for the previous period
LABOR_QUANTITY_PP_BASE NUMBER

Labor Quantity of current budget line - for the previous period
RAW_COST_YTD_BASE NUMBER

Raw cost of current budget line - for the current year
BURDENED_COST_YTD_BASE NUMBER

Burdened cost of current budget line - for the current year
REVENUE_YTD_BASE NUMBER

Revenue of current budget line - for the current year
QUANTITY_YTD_BASE NUMBER

Quantity of current budget line - for the current year
LABOR_QUANTITY_YTD_BASE NUMBER

Labor Quantity of current budget line - for the current year
RAW_COST_ITD_BASE NUMBER

Raw cost of current budget line - since inception
BURDENED_COST_ITD_BASE NUMBER

Burdened cost of current budget line - since inception
REVENUE_ITD_BASE NUMBER

Revenue of current budget line - since inception
QUANTITY_ITD_BASE NUMBER

Quantity of current budget line - since inception
LABOR_QUANTITY_ITD_BASE NUMBER

Labor Quantity of current budget line - since inception
RAW_COST_PTD_ORIG NUMBER

Raw cost of original budget line - for the pa period
BURDENED_COST_PTD_ORIG NUMBER

Burdened cost of original budget line - for the pa period
REVENUE_PTD_ORIG NUMBER

Revenue of original budget line - for the pa period
QUANTITY_PTD_ORIG NUMBER

Quantity of original budget line - for the pa period
LABOR_QUANTITY_PTD_ORIG NUMBER

Labor Quantity of original budget line - for the pa period
RAW_COST_PP_ORIG NUMBER

Raw cost of original budget line - for the previous period
BURDENED_COST_PP_ORIG NUMBER

Burdened cost of original budget line - for the previous period
REVENUE_PP_ORIG NUMBER

Revenue of original budget line - for the previous period
QUANTITY_PP_ORIG NUMBER

Quantity of original budget line - for the previous period
LABOR_QUANTITY_PP_ORIG NUMBER

Labor Quantity of original budget line - for the previous period
RAW_COST_YTD_ORIG NUMBER

Raw cost of original budget line - for the current year
BURDENED_COST_YTD_ORIG NUMBER

Burdened cost of original budget line - for the current year
REVENUE_YTD_ORIG NUMBER

Revenue of original budget line - for the current year
QUANTITY_YTD_ORIG NUMBER

Quantity of original budget line - for the current year
LABOR_QUANTITY_YTD_ORIG NUMBER

Labor Quantity of original budget line - for the current year
RAW_COST_ITD_ORIG NUMBER

Raw cost of original budget line - since inception
BURDENED_COST_ITD_ORIG NUMBER

Burdened cost of original budget line - since inception
REVENUE_ITD_ORIG NUMBER

Revenue of original budget line - since inception
QUANTITY_ITD_ORIG NUMBER

Quantity of original budget line - since inception
LABOR_QUANTITY_ITD_ORIG NUMBER

Labor Quantity of original budget line - since inception
UNIT_OF_MEASURE_BASE VARCHAR2 (30)
The unit of measure of the budget in the pa period. This is the unit of measure of the resource
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
FIN_PLAN_TYPE_ID NUMBER (15)
The identifier of the financial plan type
VERSION_TYPE VARCHAR2 (30)
The planning type of the financial plan
APPROVED_COST_PLAN_TYPE_FLAG VARCHAR2 (1)
Indicates whether this plan type is used as an approved cost budget
APPROVED_REV_PLAN_TYPE_FLAG VARCHAR2 (1)
Indicates whether this plan type is used as an approved revenue budget
TRACK_AS_LABOR_FLAG VARCHAR2 (1)
Flag that indicates if the resource is a labor item. This is a denormalized column
RESOURCE_CLASS_CODE VARCHAR2 (30)
Indicates the resource class code. This is a denormalized column
PRIMARY_COST_FORECAST_FLAG VARCHAR2 (1)
Indicates whether this plan type is used as an primary cost forecast
PRIMARY_REV_FORECAST_FLAG VARCHAR2 (1)
Indicates whether this plan type is used as an primary revenue forecast
Query Text

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
,      RESOURCE_ACCUMULATED_FLAG
,      BASE_RAW_COST
,      BASE_BURDENED_COST
,      BASE_REVENUE
,      BASE_QUANTITY
,      BASE_LABOR_QUANTITY
,      ORIG_RAW_COST
,      ORIG_BURDENED_COST
,      ORIG_REVENUE
,      ORIG_QUANTITY
,      ORIG_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
,      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_BASE
,      UNIT_OF_MEASURE_ORIG
,      FIN_PLAN_TYPE_ID
,      VERSION_TYPE
,      APPROVED_COST_PLAN_TYPE_FLAG
,      APPROVED_REV_PLAN_TYPE_FLAG
,      TRACK_AS_LABOR_FLAG
,      RESOURCE_CLASS_CODE
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
FROM APPS.PA_TODATE_BASE_ORIG_BUDGET_V;

Dependencies

[top of page]

APPS.PA_TODATE_BASE_ORIG_BUDGET_V references the following:

SchemaAPPS
PL/SQL PackagePA_ACCUM_UTILS - show dependent code
SynonymPA_BUDGET_LINES
SynonymPA_BUDGET_VERSIONS
SynonymPA_RESOURCE_ASSIGNMENTS
SynonymPA_RESOURCE_LIST_MEMBERS
APPS.PA_TODATE_BASE_ORIG_BUDGET_V is referenced by following:

SchemaAPPS
Package BodyPA_MAINT_PROJECT_BUDGETS - show dependent code