[Home] [Help]
View: JA_AU_SOURCE_ADDITIONS_V
View Text
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
Columns
Name |
ASSET_ID |
DATE_RETIRED |
ASSET_NUMBER |
TAG_NUMBER |
DESCRIPTION |
ASSET_CATEGORY_ID |
ATTRIBUTE_CATEGORY_CODE |
ASSET_KEY_CCID |
ASSET_TYPE |
MANUFACTURER_NAME |
MODEL_NUMBER |
SERIAL_NUMBER |