Product: | OKX - Contracts Integration |
---|---|
Description: | This view stores information about asset depreciation methods. |
Implementation/DBA Data: | APPS.OKX_ASST_DEP_METHODS_V |
SELECT METHOD_ID ID1
, '#' ID2
, METHOD_CODE||'
, '||TO_CHAR(LIFE_IN_MONTHS) NAME
, NAME DESCRIPTION
, METHOD_CODE METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, DEPRECIATE_LASTYEAR_FLAG DEPRECIATE_LASTYEAR_FLAG
, STL_METHOD_FLAG STL_METHOD_FLAG
, RATE_SOURCE_RULE RATE_SOURCE_RULE
, DEPRN_BASIS_RULE DEPRN_BASIS_RULE
, PRORATE_PERIODS_PER_YEAR PRORATE_PERIODS_PER_YEAR
, EXCLUDE_SALVAGE_VALUE_FLAG EXCLUDE_SALVAGE_VALUE_FLAG
, DEPRN_BASIS_FORMULA DEPRN_BASIS_FORMULA
, SYSDATE START_DATE_ACTIVE
, SYSDATE+1 END_DATE_ACTIVE
, 'A' STATUS
, NULL PRIMARY_UOM_CODE
FROM FA_METHODS