eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CUN_ASSET_ADDITIONS_UNITS_V

Product:	CUN - Network Logistics - NATS (Obsolete)
Description:	Fixed Asset information
Implementation/DBA Data:	Not implemented in this database

View Text

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(+)

Columns

Name
ASSET_NUMBER
DESCRIPTION
ASSET_TYPE
ASSET_STATUS
ASSET_SERIAL_NUMBER
QUANTITY
ASSET_TAG_NUMBER
ASSET_CATEGORY
ASSET_RETIREMENT_DATE
ASSET_MANUFACTURER
ASSET_MODEL_NUMBER
IN_SERVICE_DATE
ASSET_PARENT
ASSET_LEASE_NUMBER
ASSET_LESSOR
ASSET_UNIT_ID
ASSET_ID
INV_ITEM_ID
INVENTORY_ORG_ID
BOOK_TYPE_CODE