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_GROUP_ASSET_RULES

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_GROUP_ASSET_RULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE GROUP_ASSET_ID
FA_GROUP_ASSET_RULES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PRORATE_CONVENTION_CODE

Columns

Name	Datatype	Length	Mandatory
GROUP_ASSET_ID	NUMBER	(15)	Yes
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
DATE_EFFECTIVE	DATE		Yes
REVAL_AMORTIZATION_BASIS	NUMBER	(15)
LIFE_IN_MONTHS	NUMBER
DEPRN_METHOD_CODE	VARCHAR2	(15)
PRORATE_DATE	DATE
DEPRN_START_DATE	DATE
UNIT_OF_MEASURE	VARCHAR2	(25)
ADJUST_ACCOUNT_BASE_FLAG	VARCHAR2	(1)	Yes
ADJUSTED_RATE	NUMBER
BASE_CALCULATION_TYPE	VARCHAR2	(3)
BASIC_RATE	NUMBER
CAPITAL_GAIN_THRESHOLD	NUMBER
USE_DEPRECIATION_LIMITS_FLAG	VARCHAR2	(1)	Yes
ALLOWED_DEPRN_LIMIT_FLAG	VARCHAR2	(1)	Yes
SPECIAL_DEPRN_LIMIT_AMOUNT	NUMBER
PERCENT_SALVAGE_VALUE	NUMBER
REDUCE_SALVAGE_VALUE_FLAG	VARCHAR2	(1)	Yes
STL_LIFE_IN_MONTHS	NUMBER	(4)
CREATION_DATE	DATE
CEILING_NAME	VARCHAR2	(30)
BONUS_RULE	VARCHAR2	(15)
DEPRECIABLE_BASIS_FLAG	VARCHAR2	(3)
PRODUCTION_CAPACITY	NUMBER
ADJUSTED_CAPACITY	NUMBER
LAST_UPDATE_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
DATE_INEFFECTIVE	DATE
PRORATE_CONVENTION_CODE	VARCHAR2	(10)
ITC_ELIGIBLE_FLAG	VARCHAR2	(1)	Yes
USE_ITC_CEILINGS_FLAG	VARCHAR2	(1)	Yes
DEPRECIATE_FLAG	VARCHAR2	(1)	Yes
STL_METHOD_CODE	VARCHAR2	(12)

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:

APPS: FA_GROUP_ASSET_RULES