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 |
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