VIEW: APPS.FABV_ASSETS

Source

View Text - Preformatted

SELECT AD.ASSET_ID , AD.ASSET_NUMBER , '_KF:OFA:KEY#:AK' CODE_COMBINATION, 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 , AD.LEASE_ID , DH.DISTRIBUTION_ID , BK.BOOK_TYPE_CODE FROM FA_ADDITIONS AD, FA_DISTRIBUTION_HISTORY DH, FA_BOOKS BK, FA_ASSET_KEYWORDS AK WHERE AD.ASSET_ID = DH.ASSET_ID AND AD.ASSET_ID = BK.ASSET_ID AND BK.TRANSACTION_HEADER_ID_OUT is null AND DH.TRANSACTION_HEADER_ID_OUT IS NULL AND AD.ASSET_KEY_CCID= AK.CODE_COMBINATION_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT AD.ASSET_ID
, AD.ASSET_NUMBER
, '_KF:OFA:KEY#:AK' CODE_COMBINATION
, 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
, AD.LEASE_ID
, DH.DISTRIBUTION_ID
, BK.BOOK_TYPE_CODE
FROM FA_ADDITIONS AD
, FA_DISTRIBUTION_HISTORY DH
, FA_BOOKS BK
, FA_ASSET_KEYWORDS AK
WHERE AD.ASSET_ID = DH.ASSET_ID
AND AD.ASSET_ID = BK.ASSET_ID
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND DH.TRANSACTION_HEADER_ID_OUT IS NULL
AND AD.ASSET_KEY_CCID= AK.CODE_COMBINATION_ID (+) WITH READ ONLY