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

VIEW: APPS.FA_RETIREMENTS_WEB_V

Object Details
Object Name: FA_RETIREMENTS_WEB_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_RETIREMENTS_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 asset retirement
transactions.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RET_ROWID ROWID (10)
Refer to base table
RETIREMENT_ID NUMBER (15) Yes Refer to base table
BOOK_TYPE_CODE VARCHAR2 (15) Yes Refer to base table
ASSET_ID NUMBER (15) Yes Refer to base table
TRANSACTION_HEADER_ID_IN NUMBER (15) Yes Refer to base table
DATE_RETIRED DATE
Yes Refer to base table
DATE_EFFECTIVE DATE
Yes Refer to base table
COST_RETIRED VARCHAR2 (4000)
Refer to base table
STATUS VARCHAR2 (15) Yes Refer to base table
LAST_UPDATE_DATE DATE
Yes Refer to base table
LAST_UPDATED_BY NUMBER (15) Yes Refer to base table
RETIREMENT_PRORATE_CONVENTION VARCHAR2 (10) Yes Refer to base table
TRANSACTION_HEADER_ID_OUT NUMBER (15)
Refer to base table
UNITS NUMBER

Refer to base table
COST_OF_REMOVAL VARCHAR2 (4000)
Refer to base table
NBV_RETIRED VARCHAR2 (4000)
Refer to base table
GAIN_LOSS_AMOUNT VARCHAR2 (4000)
Refer to base table
PROCEEDS_OF_SALE VARCHAR2 (4000)
Refer to base table
GAIN_LOSS_TYPE_CODE VARCHAR2 (15)
Refer to base table
RETIREMENT_TYPE_CODE VARCHAR2 (15)
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
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
CREATED_BY NUMBER (15)
Refer to base table
CREATION_DATE DATE

Refer to base table
LAST_UPDATE_LOGIN NUMBER (15)
Refer to base table
RET_ATTRIBUTE1 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE2 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE3 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE4 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE5 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE6 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE7 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE8 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE9 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE10 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE11 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE12 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE13 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE14 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE15 VARCHAR2 (150)
Refer to base table
RET_ATTRIBUTE_CATEGORY_CODE VARCHAR2 (30)
Refer to base table
REVAL_RESERVE_RETIRED VARCHAR2 (4000)
Refer to base table
UNREVALUED_COST_RETIRED VARCHAR2 (4000)
Refer to base table
ASSET_NUMBER VARCHAR2 (15) Yes Refer to base table
COST VARCHAR2 (4000)
Refer to base table
CURRENT_UNITS NUMBER
Yes Refer to base table
TRADE_IN_ASSET_NUMBER VARCHAR2 (15)
Refer to base table
TRADE_IN_ASSET_DESC VARCHAR2 (80)
Refer to base table
TRANSACTION_NAME VARCHAR2 (30)
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
CURRENT_FISCAL_YEAR NUMBER (4) Yes Refer to base table
FISCAL_YEAR_NAME VARCHAR2 (30)
Refer to base table
FY_START_DATE DATE
Yes Refer to base table
FY_END_DATE DATE
Yes Refer to base table
Query Text

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


SELECT RET_ROWID
,      RETIREMENT_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      TRANSACTION_HEADER_ID_IN
,      DATE_RETIRED
,      DATE_EFFECTIVE
,      COST_RETIRED
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      RETIREMENT_PRORATE_CONVENTION
,      TRANSACTION_HEADER_ID_OUT
,      UNITS
,      COST_OF_REMOVAL
,      NBV_RETIRED
,      GAIN_LOSS_AMOUNT
,      PROCEEDS_OF_SALE
,      GAIN_LOSS_TYPE_CODE
,      RETIREMENT_TYPE_CODE
,      ITC_RECAPTURED
,      ITC_RECAPTURE_ID
,      REFERENCE_NUM
,      SOLD_TO
,      TRADE_IN_ASSET_ID
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      STL_DEPRN_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      RET_ATTRIBUTE1
,      RET_ATTRIBUTE2
,      RET_ATTRIBUTE3
,      RET_ATTRIBUTE4
,      RET_ATTRIBUTE5
,      RET_ATTRIBUTE6
,      RET_ATTRIBUTE7
,      RET_ATTRIBUTE8
,      RET_ATTRIBUTE9
,      RET_ATTRIBUTE10
,      RET_ATTRIBUTE11
,      RET_ATTRIBUTE12
,      RET_ATTRIBUTE13
,      RET_ATTRIBUTE14
,      RET_ATTRIBUTE15
,      RET_ATTRIBUTE_CATEGORY_CODE
,      REVAL_RESERVE_RETIRED
,      UNREVALUED_COST_RETIRED
,      ASSET_NUMBER
,      COST
,      CURRENT_UNITS
,      TRADE_IN_ASSET_NUMBER
,      TRADE_IN_ASSET_DESC
,      TRANSACTION_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      CURRENT_FISCAL_YEAR
,      FISCAL_YEAR_NAME
,      FY_START_DATE
,      FY_END_DATE
FROM APPS.FA_RETIREMENTS_WEB_V;

Dependencies

[top of page]

APPS.FA_RETIREMENTS_WEB_V references the following:

SchemaAPPS
SynonymFA_ADDITIONS
SynonymFA_ASSET_HISTORY
SynonymFA_BOOKS
SynonymFA_BOOK_CONTROLS
SynonymFA_FISCAL_YEAR
SynonymFA_RETIREMENTS
SynonymFA_TRANSACTION_HEADERS
PL/SQL PackageFND_CURRENCY - show dependent code
ViewGL_SETS_OF_BOOKS

APPS.FA_RETIREMENTS_WEB_V is not referenced by any database object