View: OKX_AST_CT_BK_DFS_V

Product:	OKX - Contracts Integration
Description:	Provides default depreciation rules based on asset category and book. This view will be used to default depreciation rules at the time asset line creation.
Implementation/DBA Data:	APPS.OKX_AST_CT_BK_DFS_V

View Text

SELECT FACBD.CATEGORY_ID ID1
, FACBD.BOOK_TYPE_CODE||'
, '||TO_CHAR(START_DPIS
, 'DD-MON-YYYY HH24:MI:SS') ID2
, '#' NAME
, '#' DESCRIPTION
, FACBD.CATEGORY_ID CATEGORY_ID
, FACBD.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FACBD.START_DPIS START_DPIS
, FACBD.END_DPIS END_DPIS
, FACBD.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FACBD.DEPRN_METHOD DEPRN_METHOD
, FACBD.PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, FACBD.ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG
, FACBD.USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG
, FACBD.CEILING_NAME CEILING_NAME
, FACBD.BASIC_RATE BASIC_RATE
, FACBD.ADJUSTED_RATE ADJUSTED_RATE
, FACBD.BONUS_RULE BONUS_RULE
, FACBD.DEPRECIATE_FLAG DEPRECIATE_FLAG
, FACBD.RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION
, FACBD.PRICE_INDEX_NAME PRICE_INDEX_NAME
, FACBD.USE_STL_RETIREMENTS_FLAG USE_STL_RETIREMENTS_FLAG
, FACBD.STL_METHOD_CODE STL_METHOD_CODE
, FACBD.STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS
, FACBD.SUBCOMPONENT_LIFE_RULE SUBCOMPONENT_LIFE_RULE
, FACBD.MINIMUM_LIFE_IN_MONTHS MINIMUM_LIFE_IN_MONTHS
, FACBD.PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, FACBD.UNIT_OF_MEASURE UNIT_OF_MEASURE
, FACBD.CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD
, FACBD.USE_DEPRN_LIMITS_FLAG USE_DEPRN_LIMITS_FLAG
, FACBD.ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT
, FACBD.SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT
, FACBD.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FACBD.CUA_LIFE_END_DATE CUA_LIFE_END_DATE
, FACBD.CUA_RULE_SET_ID CUA_RULE_SET_ID
FROM FA_CATEGORY_BOOK_DEFAULTS FACBD

Columns