Product: | CUN - Network Logistics - NATS (obsolete) |
---|---|
Description: | Fixed Asset information |
Implementation/DBA Data: | Not implemented in this database |
SELECT CAU.ASSET_NUMBER ASSET_NUMBER
, CAU.ASSET_DESCRIPTION DESCRIPTION
, CAU.ASSET_TYPE ASSET_TYPE
, CAU.STATUS ASSET_STATUS
, CAU.ASSET_SERIAL_NUMBER ASSET_SERIAL_NUMBER
, CAU.CURRENT_UNITS QUANTITY
, CAU.ASSET_TAG_NUMBER ASSET_TAG_NUMBER
, CAU.CATEGORY_TYPE ASSET_CATEGORY
, CAU.ASSET_RETIREMENT_DATE ASSET_RETIREMENT_DATE
, CAU.ASSET_MANUFACTURER_NAME ASSET_MANUFACTURER
, FAV.MODEL_NUMBER ASSET_MODEL_NUMBER
, CAU.IN_SERVICE_DATE IN_SERVICE_DATE
, FAV.PARENT_ASSET ASSET_PARENT
, FAV.LEASE_NUMBER ASSET_LEASE_NUMBER
, FAV.LESSOR ASSET_LESSOR
, CAU.UNIT_ID ASSET_UNIT_ID
, CAU.ASSET_ID ASSET_ID
, CAU.INV_ITEM_ID INV_ITEM_ID
, CAU.INVENTORY_ORG_ID INVENTORY_ORG_ID
, FA_DIST.BOOK_TYPE_CODE BOOK_TYPE_CODE
FROM CUN_ASSET_UNITS_V CAU
, FA_ADDITIONS_V FAV
, FA_DISTRIBUTION_HISTORY FA_DIST WHERE CAU.FA_DISTRIBUTION_ID = FA_DIST.DISTRIBUTION_ID
AND CAU.ASSET_ID = FAV.ASSET_ID(+)