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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.FA_RETIRED_ASSET_WEB_V

Object Details

Object Name:	FA_RETIRED_ASSET_WEB_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_RETIRED_ASSET_WEB_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This web inquiry view contains information about retired assets.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RETIREMENT_ID	NUMBER	(15)	Yes	Refer to base table
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes	Refer to base table
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)		Refer to base table
ASSET_ID	NUMBER	(15)	Yes	Refer to base table
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Refer to base table
DATE_RETIRED	DATE		Yes	Refer to base table
DATE_EFFECTIVE	DATE		Yes	Refer to base table
STATUS	VARCHAR2	(15)	Yes	Refer to base table
UNITS	NUMBER			Refer to base table
RETIREMENT_TYPE_CODE	VARCHAR2	(15)		Refer to base table
RETIREMENT_PRORATE_CONVENTION	VARCHAR2	(10)	Yes	Refer to base table
COST_RETIRED	VARCHAR2	(4000)		Refer to base table
COST_OF_REMOVAL	VARCHAR2	(4000)		Refer to base table
NBV_RETIRED	VARCHAR2	(4000)		Refer to base table
REVAL_RESERVE_RETIRED	VARCHAR2	(4000)		Refer to base table
UNREVALUED_COST_RETIRED	VARCHAR2	(4000)		Refer to base table
GAIN_LOSS_TYPE_CODE	VARCHAR2	(15)		Refer to base table
GAIN_LOSS_AMOUNT	VARCHAR2	(4000)		Refer to base table
PROCEEDS_OF_SALE	VARCHAR2	(4000)		Refer to base table
STL_METHOD_CODE	VARCHAR2	(12)		Refer to base table
STL_LIFE_IN_MONTHS	NUMBER	(4)		Refer to base table
STL_DEPRN_AMOUNT	VARCHAR2	(4000)		Refer to base table
ITC_RECAPTURED	VARCHAR2	(4000)		Refer to base table
ITC_RECAPTURE_ID	NUMBER	(15)		Refer to base table
REFERENCE_NUM	VARCHAR2	(15)		Refer to base table
SOLD_TO	VARCHAR2	(30)		Refer to base table
TRADE_IN_ASSET_ID	NUMBER	(15)		Refer to base table
ATTRIBUTE1	VARCHAR2	(150)		Refer to base table
ATTRIBUTE2	VARCHAR2	(150)		Refer to base table
ATTRIBUTE3	VARCHAR2	(150)		Refer to base table
ATTRIBUTE4	VARCHAR2	(150)		Refer to base table
ATTRIBUTE5	VARCHAR2	(150)		Refer to base table
ATTRIBUTE6	VARCHAR2	(150)		Refer to base table
ATTRIBUTE7	VARCHAR2	(150)		Refer to base table
ATTRIBUTE8	VARCHAR2	(150)		Refer to base table
ATTRIBUTE9	VARCHAR2	(150)		Refer to base table
ATTRIBUTE10	VARCHAR2	(150)		Refer to base table
ATTRIBUTE11	VARCHAR2	(150)		Refer to base table
ATTRIBUTE12	VARCHAR2	(150)		Refer to base table
ATTRIBUTE13	VARCHAR2	(150)		Refer to base table
ATTRIBUTE14	VARCHAR2	(150)		Refer to base table
ATTRIBUTE15	VARCHAR2	(150)		Refer to base table
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Refer to base table
LAST_UPDATE_DATE	DATE		Yes	Refer to base table
LAST_UPDATED_BY	NUMBER	(15)	Yes	Refer to base table
LAST_UPDATE_LOGIN	NUMBER	(15)		Refer to base table
CREATED_BY	NUMBER	(15)		Refer to base table
CREATION_DATE	DATE			Refer to base table
DATE_PLACED_IN_SERVICE	DATE		Yes	Refer to base table
BOOK_DATE_EFFECTIVE	DATE		Yes	Refer to base table
BOOK_DATE_INEFFECTIVE	DATE			Refer to base table
DEPRN_START_DATE	DATE		Yes	Refer to base table
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes	Refer to base table
LIFE_IN_MONTHS	NUMBER	(4)		Refer to base table
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes	Refer to base table
ADJUSTED_COST	VARCHAR2	(4000)		Refer to base table
COST	VARCHAR2	(4000)		Refer to base table
ORIGINAL_COST	VARCHAR2	(4000)		Refer to base table
SALVAGE_VALUE	VARCHAR2	(4000)		Refer to base table
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes	Refer to base table
PRORATE_DATE	DATE		Yes	Refer to base table
COST_CHANGE_FLAG	VARCHAR2	(3)	Yes	Refer to base table
ADJUSTMENT_REQUIRED_STATUS	VARCHAR2	(4)	Yes	Refer to base table
CAPITALIZE_FLAG	VARCHAR2	(3)	Yes	Refer to base table
RETIREMENT_PENDING_FLAG	VARCHAR2	(3)	Yes	Refer to base table
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes	Refer to base table
ITC_AMOUNT_ID	NUMBER	(15)		Refer to base table
ITC_AMOUNT	VARCHAR2	(4000)		Refer to base table
TAX_REQUEST_ID	NUMBER	(15)		Refer to base table
ITC_BASIS	VARCHAR2	(4000)		Refer to base table
ADJUSTED_RATE	NUMBER			Refer to base table
BONUS_RULE	VARCHAR2	(30)		Refer to base table
CEILING_NAME	VARCHAR2	(30)		Refer to base table
RECOVERABLE_COST	VARCHAR2	(4000)		Refer to base table
ADJUSTED_CAPACITY	NUMBER			Refer to base table
FULLY_RSVD_REVALS_COUNTER	NUMBER	(5)		Refer to base table
IDLED_FLAG	VARCHAR2	(3)		Refer to base table
PERIOD_COUNTER_CAPITALIZED	NUMBER	(15)		Refer to base table
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)		Refer to base table
PERIOD_COUNTER_FULLY_RETIRED	NUMBER	(15)		Refer to base table
PRODUCTION_CAPACITY	NUMBER			Refer to base table
REVAL_AMORTIZATION_BASIS	NUMBER			Refer to base table
REVAL_CEILING	VARCHAR2	(4000)		Refer to base table
UNIT_OF_MEASURE	VARCHAR2	(25)		Refer to base table
UNREVALUED_COST	VARCHAR2	(4000)		Refer to base table
ANNUAL_DEPRN_ROUNDING_FLAG	VARCHAR2	(5)		Refer to base table
PERCENT_SALVAGE_VALUE	NUMBER			Refer to base table
ALLOWED_DEPRN_LIMIT	NUMBER			Refer to base table
ALLOWED_DEPRN_LIMIT_AMOUNT	VARCHAR2	(4000)		Refer to base table
PERIOD_COUNTER_LIFE_COMPLETE	NUMBER	(15)		Refer to base table
ADJUSTED_RECOVERABLE_COST	VARCHAR2	(4000)		Refer to base table
TRANSACTION_HEADER_ID	NUMBER	(15)	Yes	Refer to base table
TRANSACTION_TYPE_CODE	VARCHAR2	(20)	Yes	Refer to base table
TRANSACTION_DATE_ENTERED	DATE		Yes	Refer to base table
TRANSACTION_NAME	VARCHAR2	(30)		Refer to base table
TRANSACTION_SUBTYPE	VARCHAR2	(9)		Refer to base table
ASSET_NUMBER	VARCHAR2	(15)	Yes	Refer to base table
ASSET_DESCRIPTION	VARCHAR2	(80)		Refer to base table
ASSET_TYPE	VARCHAR2	(11)	Yes	Refer to base table
TAG_NUMBER	VARCHAR2	(15)		Refer to base table
CURRENT_UNITS	NUMBER		Yes	Refer to base table
ASSET_CATEGORY_ID	NUMBER	(15)	Yes	Refer to base table
ASSET_KEY_CCID	NUMBER	(15)		Refer to base table
PROPERTY_TYPE_CODE	VARCHAR2	(10)		Refer to base table
PROPERTY_1245_1250_CODE	VARCHAR2	(4)		Refer to base table
IN_USE_FLAG	VARCHAR2	(3)	Yes	Refer to base table
OWNED_LEASED	VARCHAR2	(15)	Yes	Refer to base table
NEW_USED	VARCHAR2	(4)	Yes	Refer to base table
UNIT_ADJUSTMENT_FLAG	VARCHAR2	(3)	Yes	Refer to base table
ADD_COST_JE_FLAG	VARCHAR2	(3)	Yes	Refer to base table
MANUFACTURER_NAME	VARCHAR2	(360)		Refer to base table
SERIAL_NUMBER	VARCHAR2	(35)		Refer to base table
MODEL_NUMBER	VARCHAR2	(40)		Refer to base table
CATEGORY_TYPE	VARCHAR2	(30)	Yes	Refer to base table
ASSET_KEY	VARCHAR2	(61)		Refer to base table
CATEGORY	VARCHAR2	(61)		Refer to base table

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RETIREMENT_ID
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      ASSET_ID
,      BOOK_TYPE_CODE
,      DATE_RETIRED
,      DATE_EFFECTIVE
,      STATUS
,      UNITS
,      RETIREMENT_TYPE_CODE
,      RETIREMENT_PRORATE_CONVENTION
,      COST_RETIRED
,      COST_OF_REMOVAL
,      NBV_RETIRED
,      REVAL_RESERVE_RETIRED
,      UNREVALUED_COST_RETIRED
,      GAIN_LOSS_TYPE_CODE
,      GAIN_LOSS_AMOUNT
,      PROCEEDS_OF_SALE
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      STL_DEPRN_AMOUNT
,      ITC_RECAPTURED
,      ITC_RECAPTURE_ID
,      REFERENCE_NUM
,      SOLD_TO
,      TRADE_IN_ASSET_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      DATE_PLACED_IN_SERVICE
,      BOOK_DATE_EFFECTIVE
,      BOOK_DATE_INEFFECTIVE
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      ADJUSTED_COST
,      COST
,      ORIGINAL_COST
,      SALVAGE_VALUE
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      COST_CHANGE_FLAG
,      ADJUSTMENT_REQUIRED_STATUS
,      CAPITALIZE_FLAG
,      RETIREMENT_PENDING_FLAG
,      DEPRECIATE_FLAG
,      ITC_AMOUNT_ID
,      ITC_AMOUNT
,      TAX_REQUEST_ID
,      ITC_BASIS
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      RECOVERABLE_COST
,      ADJUSTED_CAPACITY
,      FULLY_RSVD_REVALS_COUNTER
,      IDLED_FLAG
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RESERVED
,      PERIOD_COUNTER_FULLY_RETIRED
,      PRODUCTION_CAPACITY
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      UNIT_OF_MEASURE
,      UNREVALUED_COST
,      ANNUAL_DEPRN_ROUNDING_FLAG
,      PERCENT_SALVAGE_VALUE
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      PERIOD_COUNTER_LIFE_COMPLETE
,      ADJUSTED_RECOVERABLE_COST
,      TRANSACTION_HEADER_ID
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_DATE_ENTERED
,      TRANSACTION_NAME
,      TRANSACTION_SUBTYPE
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      ASSET_TYPE
,      TAG_NUMBER
,      CURRENT_UNITS
,      ASSET_CATEGORY_ID
,      ASSET_KEY_CCID
,      PROPERTY_TYPE_CODE
,      PROPERTY_1245_1250_CODE
,      IN_USE_FLAG
,      OWNED_LEASED
,      NEW_USED
,      UNIT_ADJUSTMENT_FLAG
,      ADD_COST_JE_FLAG
,      MANUFACTURER_NAME
,      SERIAL_NUMBER
,      MODEL_NUMBER
,      CATEGORY_TYPE
,      ASSET_KEY
,      CATEGORY
FROM APPS.FA_RETIRED_ASSET_WEB_V;

Dependencies

[top of page]

APPS.FA_RETIRED_ASSET_WEB_V references the following:

APPS: FA_ADDITIONS; FA_ASSET_KEYWORDS_KFV; FA_BOOKS; FA_BOOK_CONTROLS; FA_CATEGORIES_B; FA_CATEGORIES_B_KFV; FA_RETIREMENTS; FA_TRANSACTION_HEADERS; FND_CURRENCY - show dependent code; GL_SETS_OF_BOOKS

APPS.FA_RETIRED_ASSET_WEB_V is not referenced by any database object