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

TABLE: FA.FA_GROUP_ASSET_RULES

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


Defines the depreciation rules to be followed when depreciating 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_GROUP_ASSET_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOK_TYPE_CODE
ColumnGROUP_ASSET_ID
FA_GROUP_ASSET_RULES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRORATE_CONVENTION_CODE
Columns
Name Datatype Length Mandatory Comments
GROUP_ASSET_ID NUMBER (15) Yes Unique key to identify group asset
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book type code
DATE_EFFECTIVE DATE
Yes Effective date
REVAL_AMORTIZATION_BASIS NUMBER (15)
Basis for revaluation amortization
LIFE_IN_MONTHS NUMBER

Group asset life in months
DEPRN_METHOD_CODE VARCHAR2 (15)
Group depreciation method code
PRORATE_DATE DATE

Prorate date for group depreciation
DEPRN_START_DATE DATE

Group depreciation start date
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure
ADJUST_ACCOUNT_BASE_FLAG VARCHAR2 (1) Yes Adjustment account base flag
ADJUSTED_RATE NUMBER

Adjusted rate for group depreciation
BASE_CALCULATION_TYPE VARCHAR2 (3)
Base calculation type for group depreciation
BASIC_RATE NUMBER

Basic rate for group depreciation
CAPITAL_GAIN_THRESHOLD NUMBER

Capital gain threshold value
USE_DEPRECIATION_LIMITS_FLAG VARCHAR2 (1) Yes Flag to indicate whether to limit depreciation
ALLOWED_DEPRN_LIMIT_FLAG VARCHAR2 (1) Yes Flag to indicate whether depreciation limit allowed
SPECIAL_DEPRN_LIMIT_AMOUNT NUMBER

Special depreciation limit amount
PERCENT_SALVAGE_VALUE NUMBER

Percentage of salvage value
REDUCE_SALVAGE_VALUE_FLAG VARCHAR2 (1) Yes Flag to indicate whether to reduce salvage value
STL_LIFE_IN_MONTHS NUMBER (4)
Straight line depreciation life in months
CREATION_DATE DATE

Standard WHO column.
CEILING_NAME VARCHAR2 (30)
Ceiling name
BONUS_RULE VARCHAR2 (15)
Bonus rule for group depreciation
DEPRECIABLE_BASIS_FLAG VARCHAR2 (3)
Flag to indicate depreciable basis
PRODUCTION_CAPACITY NUMBER

Production capacity
ADJUSTED_CAPACITY NUMBER

Adjusted capacity
LAST_UPDATE_DATE DATE

Standard WHO column.
CREATED_BY NUMBER (15)
Standard WHO column.
LAST_UPDATED_BY NUMBER (15)
Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
DATE_INEFFECTIVE DATE

Date ineffective
PRORATE_CONVENTION_CODE VARCHAR2 (10)
Prorate convention code
ITC_ELIGIBLE_FLAG VARCHAR2 (1) Yes Flag to indicate Income tax credit eligibility
USE_ITC_CEILINGS_FLAG VARCHAR2 (1) Yes Use Income tax credit ceiling flag
DEPRECIATE_FLAG VARCHAR2 (1) Yes Depreciate flag for group depreciation
STL_METHOD_CODE VARCHAR2 (12)
Straight line method of depreciation code
Query Text

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


SELECT GROUP_ASSET_ID
,      BOOK_TYPE_CODE
,      DATE_EFFECTIVE
,      REVAL_AMORTIZATION_BASIS
,      LIFE_IN_MONTHS
,      DEPRN_METHOD_CODE
,      PRORATE_DATE
,      DEPRN_START_DATE
,      UNIT_OF_MEASURE
,      ADJUST_ACCOUNT_BASE_FLAG
,      ADJUSTED_RATE
,      BASE_CALCULATION_TYPE
,      BASIC_RATE
,      CAPITAL_GAIN_THRESHOLD
,      USE_DEPRECIATION_LIMITS_FLAG
,      ALLOWED_DEPRN_LIMIT_FLAG
,      SPECIAL_DEPRN_LIMIT_AMOUNT
,      PERCENT_SALVAGE_VALUE
,      REDUCE_SALVAGE_VALUE_FLAG
,      STL_LIFE_IN_MONTHS
,      CREATION_DATE
,      CEILING_NAME
,      BONUS_RULE
,      DEPRECIABLE_BASIS_FLAG
,      PRODUCTION_CAPACITY
,      ADJUSTED_CAPACITY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DATE_INEFFECTIVE
,      PRORATE_CONVENTION_CODE
,      ITC_ELIGIBLE_FLAG
,      USE_ITC_CEILINGS_FLAG
,      DEPRECIATE_FLAG
,      STL_METHOD_CODE
FROM FA.FA_GROUP_ASSET_RULES;

Dependencies

[top of page]

FA.FA_GROUP_ASSET_RULES does not reference any database object

FA.FA_GROUP_ASSET_RULES is referenced by following:

SchemaFA
ViewFA_GROUP_ASSET_RULES#