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

VIEW: FA.FA_CATEGORY_BOOK_DEFAULTS#

Object Details
Object Name: FA_CATEGORY_BOOK_DEFAULTS#
Object Type: VIEW
Owner: FA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CATEGORY_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
START_DPIS DATE
Yes
END_DPIS DATE

LIFE_IN_MONTHS NUMBER (4)
DEPRN_METHOD VARCHAR2 (12) Yes
PRORATE_CONVENTION_CODE VARCHAR2 (10) Yes
ITC_ELIGIBLE_FLAG VARCHAR2 (3) Yes
USE_ITC_CEILINGS_FLAG VARCHAR2 (3) Yes
CEILING_NAME VARCHAR2 (30)
BASIC_RATE NUMBER

ADJUSTED_RATE NUMBER

BONUS_RULE VARCHAR2 (30)
DEPRECIATE_FLAG VARCHAR2 (3) Yes
RETIREMENT_PRORATE_CONVENTION VARCHAR2 (10) Yes
PRICE_INDEX_NAME VARCHAR2 (40)
USE_STL_RETIREMENTS_FLAG VARCHAR2 (3) Yes
STL_METHOD_CODE VARCHAR2 (12)
STL_LIFE_IN_MONTHS NUMBER (4)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
SUBCOMPONENT_LIFE_RULE VARCHAR2 (13)
MINIMUM_LIFE_IN_MONTHS NUMBER (4)
PRODUCTION_CAPACITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
CAPITAL_GAIN_THRESHOLD NUMBER

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)
USE_DEPRN_LIMITS_FLAG VARCHAR2 (3)
ALLOWED_DEPRN_LIMIT NUMBER

SPECIAL_DEPRN_LIMIT_AMOUNT NUMBER

PERCENT_SALVAGE_VALUE NUMBER

CUA_LIFE_END_DATE DATE

CUA_RULE_SET_ID NUMBER

GROUP_ASSET_ID NUMBER (15)
MASS_PROPERTY_FLAG VARCHAR2 (1)
RECOGNIZE_GAIN_LOSS VARCHAR2 (30)
RECAPTURE_RESERVE_FLAG VARCHAR2 (1)
LIMIT_PROCEEDS_FLAG VARCHAR2 (1)
TERMINAL_GAIN_LOSS VARCHAR2 (30)
TRACKING_METHOD VARCHAR2 (30)
EXCLUDE_FULLY_RSV_FLAG VARCHAR2 (1)
EXCESS_ALLOCATION_OPTION VARCHAR2 (30)
DEPRECIATION_OPTION VARCHAR2 (30)
MEMBER_ROLLUP_FLAG VARCHAR2 (1)
ALLOCATE_TO_FULLY_RSV_FLAG VARCHAR2 (1)
ALLOCATE_TO_FULLY_RET_FLAG VARCHAR2 (1)
Query Text

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


SELECT CATEGORY_ID
,      BOOK_TYPE_CODE
,      START_DPIS
,      END_DPIS
,      LIFE_IN_MONTHS
,      DEPRN_METHOD
,      PRORATE_CONVENTION_CODE
,      ITC_ELIGIBLE_FLAG
,      USE_ITC_CEILINGS_FLAG
,      CEILING_NAME
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      DEPRECIATE_FLAG
,      RETIREMENT_PRORATE_CONVENTION
,      PRICE_INDEX_NAME
,      USE_STL_RETIREMENTS_FLAG
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SUBCOMPONENT_LIFE_RULE
,      MINIMUM_LIFE_IN_MONTHS
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      CAPITAL_GAIN_THRESHOLD
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      USE_DEPRN_LIMITS_FLAG
,      ALLOWED_DEPRN_LIMIT
,      SPECIAL_DEPRN_LIMIT_AMOUNT
,      PERCENT_SALVAGE_VALUE
,      CUA_LIFE_END_DATE
,      CUA_RULE_SET_ID
,      GROUP_ASSET_ID
,      MASS_PROPERTY_FLAG
,      RECOGNIZE_GAIN_LOSS
,      RECAPTURE_RESERVE_FLAG
,      LIMIT_PROCEEDS_FLAG
,      TERMINAL_GAIN_LOSS
,      TRACKING_METHOD
,      EXCLUDE_FULLY_RSV_FLAG
,      EXCESS_ALLOCATION_OPTION
,      DEPRECIATION_OPTION
,      MEMBER_ROLLUP_FLAG
,      ALLOCATE_TO_FULLY_RSV_FLAG
,      ALLOCATE_TO_FULLY_RET_FLAG
FROM FA.FA_CATEGORY_BOOK_DEFAULTS#;

Dependencies

[top of page]

FA.FA_CATEGORY_BOOK_DEFAULTS# references the following:

SchemaFA
TableFA_CATEGORY_BOOK_DEFAULTS
FA.FA_CATEGORY_BOOK_DEFAULTS# is referenced by following:

SchemaAPPS
SynonymFA_CATEGORY_BOOK_DEFAULTS