VIEW: APPS.FAFV_ASSETS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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