View: OKL_ASSET_RETURNS_V

Product:	OKL - Lease and Finance Management
Description:	The transaction table for managing assets that are off lease after a contract termination or assets that have been identified as possible returns
Implementation/DBA Data:	APPS.OKL_ASSET_RETURNS_V

View Text

SELECT ARTB.ROWID ROW_ID
, ARTB.ID ID
, ARTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ARTT.SFWT_FLAG SFWT_FLAG
, ARTB.RMR_ID RMR_ID
, ARTB.IMR_ID IMR_ID
, ARTB.RNA_ID RNA_ID
, ARTB.KLE_ID KLE_ID
, ARTB.ISO_ID ISO_ID
, ARTB.SECURITY_DEP_TRX_AP_ID SECURITY_DEP_TRX_AP_ID
, ARTB.ARS_CODE ARS_CODE
, ARTB.ART1_CODE ART1_CODE
, ARTB.DATE_RETURNED DATE_RETURNED
, ARTB.DATE_TITLE_RETURNED DATE_TITLE_RETURNED
, ARTB.DATE_RETURN_DUE DATE_RETURN_DUE
, ARTB.DATE_RETURN_NOTIFIED DATE_RETURN_NOTIFIED
, ARTB.RELOCATE_ASSET_YN RELOCATE_ASSET_YN
, ARTB.ASSET_RELOCATED_YN ASSET_RELOCATED_YN
, ARTB.REPURCHASE_AGMT_YN REPURCHASE_AGMT_YN
, ARTB.FLOOR_PRICE FLOOR_PRICE
, ARTB.NEW_ITEM_PRICE NEW_ITEM_PRICE
, ARTB.VOLUNTARY_YN VOLUNTARY_YN
, ARTB.DATE_REPOSSESSION_REQUIRED DATE_REPOSSESSION_REQUIRED
, ARTB.DATE_REPOSSESSION_ACTUAL DATE_REPOSSESSION_ACTUAL
, ARTB.DATE_HOLD_UNTIL DATE_HOLD_UNTIL
, ARTB.COMMMERCIALLY_REAS_SALE_YN COMMMERCIALLY_REAS_SALE_YN
, ARTB.LIKE_KIND_YN LIKE_KIND_YN
, ARTT.NEW_ITEM_DESCRIPTION NEW_ITEM_DESCRIPTION
, ARTT.COMMENTS COMMENTS
, ARTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ARTB.ATTRIBUTE1 ATTRIBUTE1
, ARTB.ATTRIBUTE2 ATTRIBUTE2
, ARTB.ATTRIBUTE3 ATTRIBUTE3
, ARTB.ATTRIBUTE4 ATTRIBUTE4
, ARTB.ATTRIBUTE5 ATTRIBUTE5
, ARTB.ATTRIBUTE6 ATTRIBUTE6
, ARTB.ATTRIBUTE7 ATTRIBUTE7
, ARTB.ATTRIBUTE8 ATTRIBUTE8
, ARTB.ATTRIBUTE9 ATTRIBUTE9
, ARTB.ATTRIBUTE10 ATTRIBUTE10
, ARTB.ATTRIBUTE11 ATTRIBUTE11
, ARTB.ATTRIBUTE12 ATTRIBUTE12
, ARTB.ATTRIBUTE13 ATTRIBUTE13
, ARTB.ATTRIBUTE14 ATTRIBUTE14
, ARTB.ATTRIBUTE15 ATTRIBUTE15
, ARTB.ORG_ID ORG_ID
, ARTB.REQUEST_ID REQUEST_ID
, ARTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ARTB.PROGRAM_ID PROGRAM_ID
, ARTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ARTB.CREATED_BY CREATED_BY
, ARTB.CREATION_DATE CREATION_DATE
, ARTB.LAST_UPDATED_BY LAST_UPDATED_BY
, ARTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ARTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ARTB.CURRENCY_CODE
, ARTB.CURRENCY_CONVERSION_CODE
, ARTB.CURRENCY_CONVERSION_TYPE
, ARTB.CURRENCY_CONVERSION_RATE
, ARTB.CURRENCY_CONVERSION_DATE
, ARTB.NEW_ITEM_NUMBER
, ARTB.LEGAL_ENTITY_ID
, ARTB.ASSET_FMV_AMOUNT
FROM OKL_ASSET_RETURNS_B ARTB
, OKL_ASSET_RETURNS_TL ARTT
WHERE ARTB.ID = ARTT.ID
AND ARTT.LANGUAGE = USERENV('LANG')

Columns