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]

VIEW: FA.FA_GROUP_ASSET_RULES#

Object Details

Object Name:	FA_GROUP_ASSET_RULES#
Object Type:	VIEW
Owner:	FA
Subobject Name:
Status:	VALID

[View Source]

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# references the following:

FA: FA_GROUP_ASSET_RULES

FA.FA_GROUP_ASSET_RULES# is referenced by following:

APPS: FA_GROUP_ASSET_RULES