View: FA_LEASES_WEB_V

Product:	OFA - Assets
Description:	Information about leases assigned to assets
Implementation/DBA Data:	APPS.FA_LEASES_WEB_V

View Text

SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, AD.ASSET_KEY_CCID
, AD.CURRENT_UNITS
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, AD.ASSET_CATEGORY_ID
, AD.PARENT_ASSET_ID
, AD.MANUFACTURER_NAME
, AD.SERIAL_NUMBER
, AD.MODEL_NUMBER
, AD.PROPERTY_TYPE_CODE
, AD.PROPERTY_1245_1250_CODE
, AD.IN_USE_FLAG
, AD.OWNED_LEASED
, AD.NEW_USED
, AD.UNIT_ADJUSTMENT_FLAG
, AD.ADD_COST_JE_FLAG
, AD.LEASE_ID
, LS.LEASE_NUMBER
, LS.LESSOR_ID
, LS.DESCRIPTION LEASE_DESCRIPTION
, LS.LAST_UPDATE_DATE
, LS.LAST_UPDATED_BY
, LS.CREATED_BY
, LS.CREATION_DATE
, LS.LAST_UPDATE_LOGIN
, LS.ATTRIBUTE1
, LS.ATTRIBUTE2
, LS.ATTRIBUTE3
, LS.ATTRIBUTE4
, LS.ATTRIBUTE5
, LS.ATTRIBUTE6
, LS.ATTRIBUTE7
, LS.ATTRIBUTE8
, LS.ATTRIBUTE9
, LS.ATTRIBUTE10
, LS.ATTRIBUTE11
, LS.ATTRIBUTE12
, LS.ATTRIBUTE13
, LS.ATTRIBUTE14
, LS.ATTRIBUTE15
, LS.ATTRIBUTE_CATEGORY_CODE
, VD.VENDOR_ID
, VD.VENDOR_NAME
, CA.CATEGORY_TYPE
, CA.CAPITALIZE_FLAG
, AK.CONCATENATED_SEGMENTS ASSET_KEY
, CK.CONCATENATED_SEGMENTS CATEGORY
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B CA
, FA_CATEGORIES_B_KFV CK
, FA_ASSET_KEYWORDS_KFV AK
, PO_VENDORS VD
, FA_LEASES LS
WHERE AD.LEASE_ID = LS.LEASE_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID(+)
AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID(+)
AND LS.LESSOR_ID = VD.VENDOR_ID

Columns