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.

[Home] [Help]

View: FA_ASSET_V

Product:	OFA - Assets
Description:	Asset identification and financial information
Implementation/DBA Data:	APPS.FA_ASSET_V

View Text

SELECT AD.ASSET_NUMBER
, AD.TAG_NUMBER
, AD.DESCRIPTION
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, CA.SEGMENT1 "MAJOR_CATEGORY"
, /* CUSTOMIZE */ CA.SEGMENT2 "SUB_CATEGORY"
, /* CUSTOMIZE */ BK.BOOK_TYPE_CODE
, BK.DATE_PLACED_IN_SERVICE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.COST
, BK.SALVAGE_VALUE
, BK.ADJUSTED_RATE
, BK.PRODUCTION_CAPACITY
FROM FA_ADDITIONS AD
, FA_BOOK_CONTROLS BC
, FA_BOOKS BK
, FA_CATEGORIES_B CA
WHERE BC.BOOK_CLASS = 'CORPORATE'
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.ASSET_ID = AD.ASSET_ID
AND BK.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND BK.DATE_INEFFECTIVE IS NULL
AND CA.CATEGORY_ID = AD.ASSET_CATEGORY_ID

Columns

Name
ASSET_NUMBER
TAG_NUMBER
DESCRIPTION
MANUFACTURER_NAME
SERIAL_NUMBER
MODEL_NUMBER
MAJOR_CATEGORY
SUB_CATEGORY
BOOK_TYPE_CODE
DATE_PLACED_IN_SERVICE
DEPRN_METHOD_CODE
LIFE_IN_MONTHS
COST
SALVAGE_VALUE
ADJUSTED_RATE
PRODUCTION_CAPACITY