View: FAFV_ASSETS

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FAFV_ASSETS

View Text

SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, '_KF:OFA:KEY#:AK'
, AD.CURRENT_UNITS
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.DESCRIPTION
, 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.INVENTORIAL
, AD.ASSET_CATEGORY_ID
, CA.DESCRIPTION
, AD.LEASE_ID
, LE.LEASE_NUMBER
, DH.DISTRIBUTION_ID
, BK.BOOK_TYPE_CODE
FROM FA_ADDITIONS AD
, FA_LEASES LE
, FA_DISTRIBUTION_HISTORY DH
, FA_CATEGORIES CA
, FA_BOOKS BK
, FA_ASSET_KEYWORDS AK
WHERE AD.ASSET_ID = DH.ASSET_ID
AND AD.ASSET_ID = BK.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID
AND AD.LEASE_ID = LE.LEASE_ID (+)
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND DH.TRANSACTION_HEADER_ID_OUT IS NULL
AND BK.BOOK_TYPE_CODE = DH.BOOK_TYPE_CODE
AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+) WITH READ ONLY

Columns