VIEW: APPS.FA_LEASES_WEB_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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