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: GMS.GMS_BUDGET_VERSIONS

Object Details

Object Name:	GMS_BUDGET_VERSIONS
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_BUDGET_VERSIONS
Subobject Name:
Status:	VALID

GMS_BUDGET_VERSIONS stores the versions of award budgets. There are three categories of budget versions: Draft, Baselined, and Original. For an award and budget type, there is only one draft budget.
There can be many baselined budgets for an award and budget type. One baselined budget version is identified as the current budget and one is identified as the original budget.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_BUDGET_VERSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID
GMS_BUDGET_VERSIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID AWARD_ID BUDGET_TYPE_CODE BUDGET_STATUS_CODE VERSION_NUMBER
GMS_BUDGET_VERSIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENT_FLAG PROJECT_ID BUDGET_TYPE_CODE RESOURCE_ACCUMULATED_FLAG
GMS_BUDGET_VERSIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENT_ORIGINAL_FLAG PROJECT_ID BUDGET_TYPE_CODE RESOURCE_ACCUMULATED_FLAG
GMS_BUDGET_VERSIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ADW_NOTIFY_FLAG PROJECT_ID CURRENT_FLAG
GMS_BUDGET_VERSIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_VERSION_ID	NUMBER	(15)	Yes	System-generated number that uniquely identifies the budget version
PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project for which the budget is entered
AWARD_ID	NUMBER	(15)	Yes	Identifier of the award for which the budget is entered
BUDGET_TYPE_CODE	VARCHAR2	(30)	Yes	Type of budget
VERSION_NUMBER	NUMBER	(15)	Yes	Version number of the budget. For a draft budget, the version number is always 1, for a baselined budget this number is increased sequentially
BUDGET_STATUS_CODE	VARCHAR2	(30)	Yes	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	Identifier of the resource list used by the budget version
VERSION_NAME	VARCHAR2	(60)		Name of the budget version
BUDGET_ENTRY_METHOD_CODE	VARCHAR2	(30)		Method used to enter the budget version
BASELINED_BY_PERSON_ID	NUMBER	(15)		Identifier of the person who baselined the budget
BASELINED_DATE	DATE			Baselined date of the budget version
CHANGE_REASON_CODE	VARCHAR2	(30)		Reason to create this budget version
LABOR_QUANTITY	NUMBER			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)		Unit of measure of labor hours for the project. This is always set to Hours.
RAW_COST	NUMBER			Raw cost budget of the project. This is a denormalized column.
BURDENED_COST	NUMBER			Burdened cost budget of the project. This is a denormalized column.
REVENUE	NUMBER			Revenue budget of the project. This is a denormalized column.
DESCRIPTION	VARCHAR2	(255)		Description of the budget version
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield segment
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)		Identifier of the external project management system from which the budget was imported
PM_BUDGET_REFERENCE	VARCHAR2	(25)		Identifier of the budget in the external project management system from which the budget was imported
WF_STATUS_CODE	VARCHAR2	(30)		Column stores the workflow status code for Budget Approval workflows
ADW_NOTIFY_FLAG	VARCHAR2	(1)		Flag used for Project Analysis Collection Pack
PRC_GENERATED_FLAG	VARCHAR2	(1)		For future use
FC_REQUIRED_FLAG	VARCHAR2	(1)		Flag used to indicate if funds checking is required or not for this budget
CONC_REQUEST_ID	NUMBER	(15)		Concurrent request identifier for the submit or baseline process

Query Text

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


SELECT BUDGET_VERSION_ID
,      PROJECT_ID
,      AWARD_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
,      FC_REQUIRED_FLAG
,      CONC_REQUEST_ID
FROM GMS.GMS_BUDGET_VERSIONS;

Dependencies

[top of page]

GMS.GMS_BUDGET_VERSIONS does not reference any database object

GMS.GMS_BUDGET_VERSIONS is referenced by following:

APPS: GMS_BUDGET_VERSIONS