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

Product:	ITG - Internet Procurement Enterprise Connector
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT C.LEAF_NUM_ID
, C.SYS_ID_NUM
, C.ID_DESC_SHORT
, CN.COUNT_NODES
, DN.DISTINCT_NODES
FROM ITG_CATALOG_OF_IDS C
, (SELECT SYS_ID_NUM
, COUNT(ROLLUP_NODE) COUNT_NODES
FROM ITG_NODE_DESC
WHERE ROLLUP_NODE >= 0 GROUP BY SYS_ID_NUM) CN
, (SELECT SYS_ID_NUM
, COUNT(DISTINCT ROLLUP_NODE) DISTINCT_NODES
FROM ITG_NODE_DESC
WHERE ROLLUP_NODE >= 0 GROUP BY SYS_ID_NUM) DN
WHERE C.ID_TYPE = 5
AND C.SYS_ID_NUM = CN.SYS_ID_NUM
AND C.SYS_ID_NUM = DN.SYS_ID_NUM

Columns

Name
LEAF_NUM_ID
SYS_ID_NUM
ID_DESC_SHORT
COUNT_NODES
DISTINCT_NODES