Product: | CUN - Network Logistics - NATS (obsolete) |
---|---|
Description: | This view contains network unit information from the Network Logistics system |
Implementation/DBA Data: | Not implemented in this database |
SELECT CAU.UNIT_ID
, CAU.NETWORK_NUMBER
, CAU.STATUS
, CAU.STATUS_DESCRIPTION
, CAU.LOT_NUMBER VENDOR_EQUIPMENT_CODE
, CAU.EFFECTIVE_DATE
, CAU.REFERENCE_DATA
, CAU.WORK_ORDER_NUMBER
, CAU.VENDOR_ID
, CAU.VENDOR_NAME
, CAU.CLLI_CODE
, CAU.FA_LOCATION_ID
, CAU.FIXED_ASSET_LOCATION
, CAU.LAST_TRANSACTION_ID
, TO_CHAR(CAU.INV_ITEM_ID)||TO_CHAR(CAU.HZ_LOCATION_ID)||CAU.STATUS NETWORK_IDENTIFIER
, CAU.CREATION_DATE
, CAU.CREATED_BY
, CAU.LAST_UPDATED_BY
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATE_LOGIN
FROM CUN_ASSET_UNITS_V CAU
WHERE CAU.STATUS IN ('IN_SERVICE'
, 'OUT_OF_SERVICE'
, 'RETIRED')