eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PA.PA_BUDGET_VERSIONS

Object Details

Object Name:	PA_BUDGET_VERSIONS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_BUDGET_VERSIONS
Subobject Name:
Status:	VALID

PA_BUDGET_VERSIONS stores the versions of project budgets. There are three categories of budget versions: Draft, Baselined, and Original. For a project and budget type, there is one and only one draft budget.
There can be many baselined budgets for a project and budget type. One baselined budget version is identified as the current budget and one as the original budget.
Project Forecasting based on project resource assignments,also uses the budgets model to store the forecast versions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_BUDGET_VERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
PA_BUDGET_VERSIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID BUDGET_TYPE_CODE BUDGET_STATUS_CODE VERSION_NUMBER FIN_PLAN_TYPE_ID VERSION_TYPE CI_ID
PA_BUDGET_VERSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENT_FLAG PROJECT_ID BUDGET_TYPE_CODE RESOURCE_ACCUMULATED_FLAG
PA_BUDGET_VERSIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENT_ORIGINAL_FLAG PROJECT_ID BUDGET_TYPE_CODE RESOURCE_ACCUMULATED_FLAG
PA_BUDGET_VERSIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID ADW_NOTIFY_FLAG
PA_BUDGET_VERSIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_STRUCTURE_VERSION_ID WP_VERSION_FLAG
PA_BUDGET_VERSIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CI_ID
PA_BUDGET_VERSIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_STATUS_CODE PJI_SUMMARIZED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the budget version
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project for which the budget is entered
BUDGET_TYPE_CODE	VARCHAR2	(30)		The type of budget
VERSION_NUMBER	NUMBER	(15)	Yes	The version number of the budget. For draft budget, the version number is always 1, for baselined budget this number is increased sequentially
BUDGET_STATUS_CODE	VARCHAR2	(30)	Yes	The status of a budget.
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
CURRENT_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the budget version is the current baselined budget
ORIGINAL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the budget version was an original budget at any time
CURRENT_ORIGINAL_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the budget version is the current original budget
RESOURCE_ACCUMULATED_FLAG	VARCHAR2	(1)	Yes	Flag that indicates whether the budget version is summarized by resource accumulation in the project summary amount
RESOURCE_LIST_ID	NUMBER	(15)	Yes	The identifier of the resource list used by the budget version
VERSION_NAME	VARCHAR2	(60)		The name of the budget version
BUDGET_ENTRY_METHOD_CODE	VARCHAR2	(30)		The method used to enter the budget version
BASELINED_BY_PERSON_ID	NUMBER	(15)		The identifier of the person who baselined the budget
BASELINED_DATE	DATE			The baselined date of the budget version
CHANGE_REASON_CODE	VARCHAR2	(30)		The reason to create this budget version
LABOR_QUANTITY	NUMBER			The number of labor hours budgeted for the project. This is a denormalized column which sums the quantities for all labor resources budgeted.
LABOR_UNIT_OF_MEASURE	VARCHAR2	(30)		The unit of measure of labor hours for the project. This is always set to Hours.
RAW_COST	NUMBER			The raw cost budget of the project. This is a denormalized column
BURDENED_COST	NUMBER			The burdened cost budget of the project. It is a denormalized column
REVENUE	NUMBER			The revenue budget of the project. This is a denormalized column
DESCRIPTION	VARCHAR2	(255)		The description of the budget version
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
FIRST_BUDGET_PERIOD	VARCHAR2	(30)		First period for which to display amounts in budget matrix window
PM_PRODUCT_CODE	VARCHAR2	(30)		The identifier of the external project management system from which the budget was imported.
PM_BUDGET_REFERENCE	VARCHAR2	(25)		The identifier of the budget in the external project management system from which the budget was imported
WF_STATUS_CODE	VARCHAR2	(30)		This column stores the workflow status code for Budget Approval workflows
ADW_NOTIFY_FLAG	VARCHAR2	(1)		The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack.
PRC_GENERATED_FLAG	VARCHAR2	(1)		For Future Use
PLAN_RUN_DATE	DATE			This column applies to Project Forecasting. Indicates the date on which a forecast plan was generated.
PLAN_PROCESSING_CODE	VARCHAR2	(30)		This column applies to Project Forecasting. Indicates the process status of forecast generation.
RECORD_VERSION_NUMBER	NUMBER			Internally generated number used for record locking
PERIOD_PROFILE_ID	NUMBER	(15)		The identifier of the period profile that is used for the plan version
FIN_PLAN_TYPE_ID	NUMBER	(15)		The identifier of financial plan type
PARENT_PLAN_VERSION_ID	NUMBER	(15)		The identifier of the parent plan version. Applicable only for Organization forecast versions belonging to Sub-organizations.
PROJECT_STRUCTURE_VERSION_ID	NUMBER	(15)		The identifier of the project structure version. Applicable only if the version is in the context of an organization project or workplan version.
TOTAL_BORROWED_REVENUE	NUMBER			The total borrowed revenue of the financial plan
TOTAL_TP_REVENUE_IN	NUMBER			The total transfer-price revenue in of financial plan.
TOTAL_TP_REVENUE_OUT	NUMBER			The total transfer-price revenue out of financial plan.
TOTAL_REVENUE_ADJ	NUMBER			The total revenue adjustment of financial plan.
TOTAL_LENT_RESOURCE_COST	NUMBER			The total lent resource cost of financial plan.
TOTAL_TP_COST_IN	NUMBER			The total transfer-price cost in of financial plan
TOTAL_TP_COST_OUT	NUMBER			The total transfer-price cost out of financial plan.
TOTAL_COST_ADJ	NUMBER			The total cost adjustment of financial plan
TOTAL_UNASSIGNED_TIME_COST	NUMBER			The total unassigned time cost of financial plan
TOTAL_UTILIZATION_PERCENT	NUMBER			The total utilization percent of financial plan
TOTAL_UTILIZATION_HOURS	NUMBER			The total utilization hours of financial plan.
TOTAL_UTILIZATION_ADJ	NUMBER			The Total utilization percent adjustment of financial plan.
TOTAL_CAPACITY	NUMBER			The total capacity of financial plan.
TOTAL_HEAD_COUNT	NUMBER			The total head count of financial plan.
TOTAL_HEAD_COUNT_ADJ	NUMBER			The total head count adjustment of financial plan
CURRENT_WORKING_FLAG	VARCHAR2	(1)		Indicates that this is the current working version of the financial plan
VERSION_TYPE	VARCHAR2	(30)		The planning type of the financial plan. Valid values are COST, REVENUE, ALL and ORG_FORECAST
REQUEST_ID	NUMBER			The concurrent request id of the budget version being processed
TOTAL_PROJECT_RAW_COST	NUMBER			The raw cost in project currency
TOTAL_PROJECT_BURDENED_COST	NUMBER			The burdened cost in project currency
TOTAL_PROJECT_REVENUE	NUMBER			The revenue in project currency
LOCKED_BY_PERSON_ID	NUMBER	(15)		Identifier of the person who has locked the plan version
APPROVED_COST_PLAN_TYPE_FLAG	VARCHAR2	(1)		Indicates whether the plan version is an Approved Cost version
APPROVED_REV_PLAN_TYPE_FLAG	VARCHAR2	(1)		Indicates whether the plan version is an Approved Revenue version
EST_PROJECT_RAW_COST	NUMBER			Stores the estimated raw cost in project currency. Applicable only if the version is in the context of a change document.
EST_PROJECT_BURDENED_COST	NUMBER			Stores the estimated burdened cost in project currency. Applicable only if the version is in the context of a change document.
EST_PROJECT_REVENUE	NUMBER			Stores the estimated revenue in project currency. Applicable only if the version is in the context of a change document
EST_QUANTITY	NUMBER			Stores the quantity of people resources. Applicable only if the version is in the context of a change document
EST_PROJFUNC_RAW_COST	NUMBER			Stores the estimated raw cost in project functional currency. Applicable only if the version is in the context of a change document
EST_PROJFUNC_BURDENED_COST	NUMBER			Stores the estimated burdened cost in project functional currency. Applicable only if the version is in the context of a change document.
EST_PROJFUNC_REVENUE	NUMBER			Stores the estimated revenue in project functional currency. Applicable only if the version is in the context of a change document
CI_ID	NUMBER	(15)		Unique Identifier of the Control Item to which the plan version pertains to
AGREEMENT_ID	NUMBER	(15)		Unique Identifier of the agreement that is impacted by the Control Item
PROCESS_UPDATE_WBS_FLAG	VARCHAR2	(1)		This column indicates whether the budget version requires a planning elements refresh
OBJECT_TYPE_CODE	VARCHAR2	(30)		The source object for the budget. Or forecast (Intended for future use)
OBJECT_ID	NUMBER	(15)		Indicates the source (Intended for future use)
PRIMARY_COST_FORECAST_FLAG	VARCHAR2	(1)		Indicates if the plan type is a primary cost forecast
PRIMARY_REV_FORECAST_FLAG	VARCHAR2	(1)		Indicates if the plan type is a primary revenue forecast
REV_PARTIALLY_IMPL_FLAG	VARCHAR2	(1)		Indicates if change order impact has been partially implemented. This column is maintained for the change order version.
EQUIPMENT_QUANTITY	NUMBER			The number of equipment hours budgeted for the project. This is a denormalized column which sums the quantities for all equipment resources budgeted.
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)		Indicates whether the budget version has been extracted for reporting summary.
WP_VERSION_FLAG	VARCHAR2	(1)		Indicates whether the budget version is used for work plan.
CURRENT_PLANNING_PERIOD	VARCHAR2	(15)		Indicates anchoring period for a budget versions.
PERIOD_MASK_ID	NUMBER	(15)		The identifier of the period mask that is used for the plan version
LAST_AMT_GEN_DATE	DATE			This column stores the amount generated date for the plan version.
ACTUAL_AMTS_THRU_PERIOD	VARCHAR2	(30)		This column stores the PA/GL period to which the actual amounts have been copied to the plan version by the amount generation process.
EST_EQUIPMENT_QUANTITY	NUMBER			Stores the estimated quantity of equipment resources. Applicable only if the version is in the context of a change document
ETC_START_DATE	DATE			This column stores the Estimate To Complete start date.
PURGED_FLAG	VARCHAR2	(2)		Purged version flag
OLAP_CHANGE_FLAG	VARCHAR2	(1)		Stores OLAP Change Flag. Change Flag is used to indicate that budget version is changed. Changed budget versions are refreshed into OLAP CUBE.

Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      BUDGET_TYPE_CODE
,      VERSION_NUMBER
,      BUDGET_STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CURRENT_FLAG
,      ORIGINAL_FLAG
,      CURRENT_ORIGINAL_FLAG
,      RESOURCE_ACCUMULATED_FLAG
,      RESOURCE_LIST_ID
,      VERSION_NAME
,      BUDGET_ENTRY_METHOD_CODE
,      BASELINED_BY_PERSON_ID
,      BASELINED_DATE
,      CHANGE_REASON_CODE
,      LABOR_QUANTITY
,      LABOR_UNIT_OF_MEASURE
,      RAW_COST
,      BURDENED_COST
,      REVENUE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FIRST_BUDGET_PERIOD
,      PM_PRODUCT_CODE
,      PM_BUDGET_REFERENCE
,      WF_STATUS_CODE
,      ADW_NOTIFY_FLAG
,      PRC_GENERATED_FLAG
,      PLAN_RUN_DATE
,      PLAN_PROCESSING_CODE
,      RECORD_VERSION_NUMBER
,      PERIOD_PROFILE_ID
,      FIN_PLAN_TYPE_ID
,      PARENT_PLAN_VERSION_ID
,      PROJECT_STRUCTURE_VERSION_ID
,      TOTAL_BORROWED_REVENUE
,      TOTAL_TP_REVENUE_IN
,      TOTAL_TP_REVENUE_OUT
,      TOTAL_REVENUE_ADJ
,      TOTAL_LENT_RESOURCE_COST
,      TOTAL_TP_COST_IN
,      TOTAL_TP_COST_OUT
,      TOTAL_COST_ADJ
,      TOTAL_UNASSIGNED_TIME_COST
,      TOTAL_UTILIZATION_PERCENT
,      TOTAL_UTILIZATION_HOURS
,      TOTAL_UTILIZATION_ADJ
,      TOTAL_CAPACITY
,      TOTAL_HEAD_COUNT
,      TOTAL_HEAD_COUNT_ADJ
,      CURRENT_WORKING_FLAG
,      VERSION_TYPE
,      REQUEST_ID
,      TOTAL_PROJECT_RAW_COST
,      TOTAL_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_REVENUE
,      LOCKED_BY_PERSON_ID
,      APPROVED_COST_PLAN_TYPE_FLAG
,      APPROVED_REV_PLAN_TYPE_FLAG
,      EST_PROJECT_RAW_COST
,      EST_PROJECT_BURDENED_COST
,      EST_PROJECT_REVENUE
,      EST_QUANTITY
,      EST_PROJFUNC_RAW_COST
,      EST_PROJFUNC_BURDENED_COST
,      EST_PROJFUNC_REVENUE
,      CI_ID
,      AGREEMENT_ID
,      PROCESS_UPDATE_WBS_FLAG
,      OBJECT_TYPE_CODE
,      OBJECT_ID
,      PRIMARY_COST_FORECAST_FLAG
,      PRIMARY_REV_FORECAST_FLAG
,      REV_PARTIALLY_IMPL_FLAG
,      EQUIPMENT_QUANTITY
,      PJI_SUMMARIZED_FLAG
,      WP_VERSION_FLAG
,      CURRENT_PLANNING_PERIOD
,      PERIOD_MASK_ID
,      LAST_AMT_GEN_DATE
,      ACTUAL_AMTS_THRU_PERIOD
,      EST_EQUIPMENT_QUANTITY
,      ETC_START_DATE
,      PURGED_FLAG
,      OLAP_CHANGE_FLAG
FROM PA.PA_BUDGET_VERSIONS;

Dependencies

[top of page]

PA.PA_BUDGET_VERSIONS does not reference any database object

PA.PA_BUDGET_VERSIONS is referenced by following:

PA: PA_BUDGET_VERSIONS#