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_ITEM_SUMMARY_V

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

View Text

SELECT INV_ITEM_ID
, INV_ITEM
, INVENTORY_ORG_ID
, STATUS
, STATUS_DESCRIPTION
, SUBINVENTORY
, REVISION
, LOT_NUMBER
, ASSET_ID
, ASSET_NUMBER
, PROJECT_ID
, PROJECT_TASK_ID
, TO_CHAR(INV_ITEM_ID)||TO_CHAR(HZ_LOCATION_ID)||STATUS IDENTIFIER
, SUM(QUANTITY) QUANTITY
, HZ_LOCATION_ID
, INV_ORGANIZATION_NAME
, PROJECT_NUMBER
, TASK_NUMBER
FROM CUN_ITEMS_V
WHERE 1=1 GROUP BY INV_ITEM
, INV_ITEM_ID
, INV_ORGANIZATION_NAME
, INVENTORY_ORG_ID
, SUBINVENTORY
, PROJECT_NUMBER
, TASK_NUMBER
, HZ_LOCATION_ID
, TO_CHAR(INV_ITEM_ID)||TO_CHAR(HZ_LOCATION_ID)||STATUS
, ASSET_NUMBER
, REVISION
, LOT_NUMBER
, PROJECT_ID
, PROJECT_TASK_ID
, STATUS
, ASSET_ID
, STATUS_DESCRIPTION

Columns

Name
INV_ITEM_ID
INV_ITEM
INVENTORY_ORG_ID
STATUS
STATUS_DESCRIPTION
SUBINVENTORY
REVISION
LOT_NUMBER
ASSET_ID
ASSET_NUMBER
PROJECT_ID
PROJECT_TASK_ID
IDENTIFIER
QUANTITY
HZ_LOCATION_ID
INV_ORGANIZATION_NAME
PROJECT_NUMBER
TASK_NUMBER