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: TableOFA.FA_CAPITAL_BUDGET
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_CAPITAL_BUDGET_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUDGET_ID
ColumnPERIOD_NUMBER
Columns
Name Datatype Length Mandatory Comments
BUDGET_ID NUMBER (15) Yes
PERIOD_NUMBER NUMBER (2) Yes
PERIOD_COST NUMBER
Yes
ASSET_ID NUMBER (15)
BOOK_HEADER_ID NUMBER (15)
TRANSFER_HEADER_ID NUMBER (15)
DISTRIBUTION_ID NUMBER (15)
QUARTER_NUMBER NUMBER (2)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
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:

SchemaAPPS
SynonymFA_CAPITAL_BUDGET