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: FA.FA_CAPITAL_BUDGET

Object Details

Object Name:	FA_CAPITAL_BUDGET
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_CAPITAL_BUDGET
Subobject Name:
Status:	VALID

FA_CAPITAL_BUDGET stores information about your budget assets.
Oracle Assets uses this table to store budget assets for
depreciation projections and the Budget-to-Actual Report.
.
When you use the Upload Capital Budget form to Create Budget
Assets, it inserts 12 rows, one row per budget period in this
table, for each row in FA_BUDGET_INTERFACE.
.
BUDGET_ID uniquely identifies the budget amounts for one asset
category and accounting flexfield code combination pair.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_CAPITAL_BUDGET_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_ID PERIOD_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
BUDGET_ID	NUMBER	(15)	Yes	Unique identification number for each budget asset
PERIOD_NUMBER	NUMBER	(2)	Yes	Period number in the fiscal year
PERIOD_COST	NUMBER		Yes	Budgeted expenditure for the period
ASSET_ID	NUMBER	(15)		Asset identification number
BOOK_HEADER_ID	NUMBER	(15)		Identifies the addition transaction
TRANSFER_HEADER_ID	NUMBER	(15)		Identifies the transfer in transaction
DISTRIBUTION_ID	NUMBER	(15)		Identifies the initial distributions
QUARTER_NUMBER	NUMBER	(2)		Quarter number in the fiscal year
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
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Descriptive flexfield structure defining column

Query Text

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


SELECT BUDGET_ID
,      PERIOD_NUMBER
,      PERIOD_COST
,      ASSET_ID
,      BOOK_HEADER_ID
,      TRANSFER_HEADER_ID
,      DISTRIBUTION_ID
,      QUARTER_NUMBER
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
FROM FA.FA_CAPITAL_BUDGET;

Dependencies

[top of page]

FA.FA_CAPITAL_BUDGET does not reference any database object

FA.FA_CAPITAL_BUDGET is referenced by following:

FA: FA_CAPITAL_BUDGET#