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_RETIREMENT_REQUESTS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
ASSET_NUMBER	VARCHAR2	(15)	Yes
TRANSACTION_TYPE_CODE	VARCHAR2	(20)	Yes
ASSET_ID	NUMBER	(15)	Yes
COST_RETIRED	NUMBER		Yes
STATUS	VARCHAR2	(15)	Yes
UNITS	NUMBER
COST_OF_REMOVAL	NUMBER
PROCEEDS_OF_SALE	NUMBER
GAIN_LOSS_AMOUNT	NUMBER
NBV_RETIRED	NUMBER
RETIREMENT_PRORATE_CONVENTION	VARCHAR2	(10)	Yes
DATE_EFFECTIVE	DATE		Yes
RETIREMENT_TYPE	VARCHAR2	(80)
GROUP_ASSET_ID	NUMBER	(15)
TRANSACTION_HEADER_ID	NUMBER	(15)	Yes
MASS_RETIREMENT_ID	NUMBER	(15)	Yes
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
COMMENTS	VARCHAR2	(30)
PERIOD_ENTERED	VARCHAR2	(15)	Yes
PERIOD_EFFECTIVE	VARCHAR2	(15)	Yes
DATE_RETIRED	DATE		Yes
CURRENT_UNITS	NUMBER		Yes
COST	NUMBER		Yes
ASSET_NUMBER_DESC	VARCHAR2	(98)

Query Text

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


SELECT BOOK_TYPE_CODE
,      ASSET_NUMBER
,      TRANSACTION_TYPE_CODE
,      ASSET_ID
,      COST_RETIRED
,      STATUS
,      UNITS
,      COST_OF_REMOVAL
,      PROCEEDS_OF_SALE
,      GAIN_LOSS_AMOUNT
,      NBV_RETIRED
,      RETIREMENT_PRORATE_CONVENTION
,      DATE_EFFECTIVE
,      RETIREMENT_TYPE
,      GROUP_ASSET_ID
,      TRANSACTION_HEADER_ID
,      MASS_RETIREMENT_ID
,      PROJECT_ID
,      TASK_ID
,      COMMENTS
,      PERIOD_ENTERED
,      PERIOD_EFFECTIVE
,      DATE_RETIRED
,      CURRENT_UNITS
,      COST
,      ASSET_NUMBER_DESC
FROM APPS.FA_RETIREMENT_REQUESTS_V;

Dependencies

[top of page]

APPS.FA_RETIREMENT_REQUESTS_V references the following:

APPS: FA_ADDITIONS; FA_ASSET_HISTORY; FA_BOOKS; FA_BOOK_CONTROLS; FA_CALENDAR_PERIODS; FA_DEPRN_PERIODS; FA_LOOKUPS; FA_MASS_RETIREMENTS; FA_RETIREMENTS; FA_TRANSACTION_HEADERS

APPS.FA_RETIREMENT_REQUESTS_V is not referenced by any database object