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_ITEMS_V

Product:	CUN - Network Logistics - NATS (obsolete)
Description:	This view contains item unit information from the Network Logistics system
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT UNIT_ID
, INV_ITEM_ID
, INV_ITEM
, DESCRIPTION
, INVENTORY_ORG_ID
, INV_ORGANIZATION_NAME
, QUANTITY
, STATUS
, INV_STATUS_NAME
, STATUS_DESCRIPTION
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, REVISION
, LOT_NUMBER
, FA_DISTRIBUTION_ID
, BOOK_TYPE_CODE
, FA_DIST_LOCATION_ID
, FIXED_ASSET_LOCATION
, CODE_COMBINATION_ID
, ASSET_ID
, ASSET_NUMBER
, ASSET_DESCRIPTION
, ASSET_TAG_NUMBER
, ASSET_SERIAL_NUMBER
, ASSET_TYPE
, CURRENT_UNITS
, CATEGORY_TYPE
, ASSET_MANUFACTURER_NAME
, HZ_LOCATION_ID
, CLLI_CODE
, LOC_DESCRIPTION
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_TASK_ID
, TASK_NUMBER
, SERIAL_NUMBER
, VENDOR_SERIAL_NUMBER
, NETWORK_NUMBER
, VENDOR_ID
, VENDOR_NAME
, ASSET_GROUPING_ELEMENT1
, ASSET_GROUPING_ELEMENT2
, ASSET_GROUPING_ELEMENT3
, LAST_TRANSACTION_ID
, REFERENCE_DATA
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM CUN_NON_SERIALIZED_ITEMS_V UNION SELECT UNIT_ID
, INV_ITEM_ID
, INV_ITEM
, DESCRIPTION
, INVENTORY_ORG_ID
, INV_ORGANIZATION_NAME
, QUANTITY
, STATUS
, INV_STATUS_NAME
, STATUS_DESCRIPTION
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, REVISION
, LOT_NUMBER
, FA_DISTRIBUTION_ID
, BOOK_TYPE_CODE
, FA_DIST_LOCATION_ID
, FIXED_ASSET_LOCATION
, CODE_COMBINATION_ID
, ASSET_ID
, ASSET_NUMBER
, ASSET_DESCRIPTION
, ASSET_TAG_NUMBER
, ASSET_SERIAL_NUMBER
, ASSET_TYPE
, CURRENT_UNITS
, CATEGORY_TYPE
, ASSET_MANUFACTURER_NAME
, HZ_LOCATION_ID
, CLLI_CODE
, LOC_DESCRIPTION
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_TASK_ID
, TASK_NUMBER
, SERIAL_NUMBER
, VENDOR_SERIAL_NUMBER
, NETWORK_NUMBER
, VENDOR_ID
, VENDOR_NAME
, ASSET_GROUPING_ELEMENT1
, ASSET_GROUPING_ELEMENT2
, ASSET_GROUPING_ELEMENT3
, LAST_TRANSACTION_ID
, REFERENCE_DATA
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM CUN_SERIALIZED_ITEMS_V

Columns

Name
UNIT_ID
INV_ITEM_ID
INV_ITEM
DESCRIPTION
INVENTORY_ORG_ID
INV_ORGANIZATION_NAME
QUANTITY
STATUS
INV_STATUS_NAME
STATUS_DESCRIPTION
SUBINVENTORY
LOCATOR_ID
LOCATOR
REVISION
LOT_NUMBER
FA_DISTRIBUTION_ID
BOOK_TYPE_CODE
FA_DIST_LOCATION_ID
FIXED_ASSET_LOCATION
CODE_COMBINATION_ID
ASSET_ID
ASSET_NUMBER
ASSET_DESCRIPTION
ASSET_TAG_NUMBER
ASSET_SERIAL_NUMBER
ASSET_TYPE
CURRENT_UNITS
CATEGORY_TYPE
ASSET_MANUFACTURER_NAME
HZ_LOCATION_ID
CLLI_CODE
LOC_DESCRIPTION
PROJECT_ID
PROJECT_NUMBER
PROJECT_TASK_ID
TASK_NUMBER
SERIAL_NUMBER
VENDOR_SERIAL_NUMBER
NETWORK_NUMBER
VENDOR_ID
VENDOR_NAME
ASSET_GROUPING_ELEMENT1
ASSET_GROUPING_ELEMENT2
ASSET_GROUPING_ELEMENT3
LAST_TRANSACTION_ID
REFERENCE_DATA
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN