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.

VIEW: APPS.OKX_ASST_DEP_METHODS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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