View: CSP_REP_HIERARCHIES_NAV

Product:	CSP - Spares Management
Description:	View for Reporting Hierarchy Root to Reporting Hierarchy flow
Implementation/DBA Data:	APPS.CSP_REP_HIERARCHIES_NAV

View Text

SELECT RH.NODE_NAME
, NT.NODE_TYPE
, RH.HIERARCHY_NODE_ID
, NT.ICON_NAME
, 'N'
, 'ROOT'
, NT.ROOT_KEY
FROM CSP_NAV_NODE_TYPES NT
, CSP_REP_HIERARCHIES RH
WHERE NT.ROOT_KEY = 'CSP_HIERARCHY'
AND NT.NODE_TYPE = 'REP_HIERARCHY'
AND RH.HIERARCHY_NODE_ID = RH.TOP_NODE_ID ORDER BY 1

Columns