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

TABLE: FA.FA_BOOKS_GROUPS

Object Details
Object Name: FA_BOOKS_GROUPS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_BOOKS_GROUPS
Subobject Name:
Status: VALID


Contains financial (cost) information for a group asset within a particular book. This is also a history table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_BOOKS_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ASSET_ID
ColumnBOOK_TYPE_CODE
ColumnDATE_EFFECTIVE
Columns
Name Datatype Length Mandatory Comments
GROUP_ASSET_ID NUMBER (15) Yes Unique identifier for group asset
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book type code.
COST NUMBER
Yes Group Asset Current Cost
ORIGINAL_COST NUMBER (22) Yes Group asset original cost
SALVAGE_VALUE NUMBER

Group asset salvage value
ADJUSTED_COST NUMBER (22) Yes Group asset adjusted cost
ADJUSTED_RECOVERABLE_COST NUMBER

Group asset adjusted recoverable cost
RECOVERABLE_COST NUMBER

Group asset recoverable cost
COST_CHANGE_FLAG VARCHAR2 (3)
Yes/No flag to allow group asset cost change
TRANSACTION_HEADER_ID_IN NUMBER (15) Yes Identification of input transaction header for group asset
TRANSACTION_HEADER_ID_OUT NUMBER (15)
Identification for output transaction header
PERIOD_COUNTER_LIFE_COMPLETE NUMBER (15)
Period counter life complete
PERIOD_COUNTER NUMBER (15)
Period counter
BEGINNING_BALANCE_FLAG VARCHAR2 (1)
Flag to specify beginning balance
DATE_INEFFECTIVE DATE

Date ineffective
DATE_EFFECTIVE DATE
Yes Date effective
IDLED_FLAG VARCHAR2 (3)
Idled flag
ITC_AMOUNT NUMBER

Investment tax credit amount
ITC_AMOUNT_ID NUMBER (15)
Identification for Investment tax credit
ITC_BASIS NUMBER

Basis for investment tax credit
PERCENT_SALVAGE_VALUE NUMBER

Percent salvage value
PERIOD_COUNTER_CAPITALIZED NUMBER (15)
Capitalized period counter for group asset
PERIOD_COUNTER_FULLY_RESERVED NUMBER (15)
Period counter for fully reserved group asset
PERIOD_COUNTER_FULLY_RETIRED NUMBER (15)
Period counter for fully retired group asset
RETIREMENT_ID NUMBER (15)
Identification for retirement group
RETIREMENT_PENDING_FLAG VARCHAR2 (3)
Flag to indicate retirement pending status
TAX_REQUEST_ID NUMBER (15)
Tax request ID.
CAPITALIZE_FLAG VARCHAR2 (3)
Flag to indicate that the group asset is capitalized
YTD_PROCEEDS NUMBER

Year to date group proceeds.
LTD_PROCEEDS NUMBER

Life to date group proceeds.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment for globalization.
Query Text

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


SELECT GROUP_ASSET_ID
,      BOOK_TYPE_CODE
,      COST
,      ORIGINAL_COST
,      SALVAGE_VALUE
,      ADJUSTED_COST
,      ADJUSTED_RECOVERABLE_COST
,      RECOVERABLE_COST
,      COST_CHANGE_FLAG
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      PERIOD_COUNTER_LIFE_COMPLETE
,      PERIOD_COUNTER
,      BEGINNING_BALANCE_FLAG
,      DATE_INEFFECTIVE
,      DATE_EFFECTIVE
,      IDLED_FLAG
,      ITC_AMOUNT
,      ITC_AMOUNT_ID
,      ITC_BASIS
,      PERCENT_SALVAGE_VALUE
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RESERVED
,      PERIOD_COUNTER_FULLY_RETIRED
,      RETIREMENT_ID
,      RETIREMENT_PENDING_FLAG
,      TAX_REQUEST_ID
,      CAPITALIZE_FLAG
,      YTD_PROCEEDS
,      LTD_PROCEEDS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
FROM FA.FA_BOOKS_GROUPS;

Dependencies

[top of page]

FA.FA_BOOKS_GROUPS does not reference any database object

FA.FA_BOOKS_GROUPS is referenced by following:

SchemaFA
ViewFA_BOOKS_GROUPS#