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.OKL_AM_ASST_DEP_METHODS_UV

Source

View Text - Preformatted


SELECT FAMET.METHOD_ID ID1, '#' ID2, FAMET.METHOD_CODE||','||TO_CHAR(FAMET.LIFE_IN_MONTHS) NAME, FAMET.NAME DESCRIPTION, FAMET.METHOD_CODE METHOD_CODE, FAMET.LIFE_IN_MONTHS LIFE_IN_MONTHS, FAMET.DEPRECIATE_LASTYEAR_FLAG DEPRECIATE_LASTYEAR_FLAG, FAMET.STL_METHOD_FLAG STL_METHOD_FLAG, FAMET.RATE_SOURCE_RULE RATE_SOURCE_RULE, FAMET.DEPRN_BASIS_RULE DEPRN_BASIS_RULE, FAMET.PRORATE_PERIODS_PER_YEAR PRORATE_PERIODS_PER_YEAR, FAMET.EXCLUDE_SALVAGE_VALUE_FLAG EXCLUDE_SALVAGE_VALUE_FLAG, FAMET.DEPRN_BASIS_FORMULA DEPRN_BASIS_FORMULA, SYSDATE START_DATE_ACTIVE, SYSDATE+1 END_DATE_ACTIVE, 'A' STATUS, NULL PRIMARY_UOM_CODE, ( FLAT.ADJUSTED_RATE *100 )DEPRN_RATE FROM FA_METHODS FAMET,FA_FLAT_RATES FLAT WHERE FAMET.METHOD_ID = FLAT.METHOD_ID (+) AND NVL(FLAT.ADJUSTING_RATE,0) = 0

View Text - HTML Formatted

SELECT FAMET.METHOD_ID ID1
, '#' ID2
, FAMET.METHOD_CODE||'
, '||TO_CHAR(FAMET.LIFE_IN_MONTHS) NAME
, FAMET.NAME DESCRIPTION
, FAMET.METHOD_CODE METHOD_CODE
, FAMET.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FAMET.DEPRECIATE_LASTYEAR_FLAG DEPRECIATE_LASTYEAR_FLAG
, FAMET.STL_METHOD_FLAG STL_METHOD_FLAG
, FAMET.RATE_SOURCE_RULE RATE_SOURCE_RULE
, FAMET.DEPRN_BASIS_RULE DEPRN_BASIS_RULE
, FAMET.PRORATE_PERIODS_PER_YEAR PRORATE_PERIODS_PER_YEAR
, FAMET.EXCLUDE_SALVAGE_VALUE_FLAG EXCLUDE_SALVAGE_VALUE_FLAG
, FAMET.DEPRN_BASIS_FORMULA DEPRN_BASIS_FORMULA
, SYSDATE START_DATE_ACTIVE
, SYSDATE+1 END_DATE_ACTIVE
, 'A' STATUS
, NULL PRIMARY_UOM_CODE
, ( FLAT.ADJUSTED_RATE *100 )DEPRN_RATE
FROM FA_METHODS FAMET
, FA_FLAT_RATES FLAT
WHERE FAMET.METHOD_ID = FLAT.METHOD_ID (+)
AND NVL(FLAT.ADJUSTING_RATE
, 0) = 0