SELECT DISTINCT S.ASSET_ID , S.DATE_RETIRED , A.ASSET_NUMBER , A.TAG_NUMBER , A.DESCRIPTION , A.ASSET_CATEGORY_ID , A.ATTRIBUTE_CATEGORY_CODE , A.ASSET_KEY_CCID , A.ASSET_TYPE , A.MANUFACTURER_NAME , A.MODEL_NUMBER , A.SERIAL_NUMBER FROM JA_AU_BAL_CHG_SOURCE S, FA_ADDITIONS A WHERE S.ASSET_ID = A.ASSET_ID
SELECT DISTINCT S.ASSET_ID
, S.DATE_RETIRED
, A.ASSET_NUMBER
, A.TAG_NUMBER
, A.DESCRIPTION
, A.ASSET_CATEGORY_ID
, A.ATTRIBUTE_CATEGORY_CODE
, A.ASSET_KEY_CCID
, A.ASSET_TYPE
, A.MANUFACTURER_NAME
, A.MODEL_NUMBER
, A.SERIAL_NUMBER
FROM JA_AU_BAL_CHG_SOURCE S
, FA_ADDITIONS A
WHERE S.ASSET_ID = A.ASSET_ID
|
|
|