View: CSP_PLN_REGIONS_NAV

Product:	CSP - Spares Management
Description:
Implementation/DBA Data:	APPS.CSP_PLN_REGIONS_NAV

View Text

SELECT CPL.NODE_NAME
, NT.NODE_TYPE
, CPL.PLANNING_PARAMETERS_ID
, NT.ICON_NAME
, 'N'
, 'ROOT'
, NT.ROOT_KEY
FROM CSP_NAV_NODE_TYPES NT
, CSP_PLANNING_PARAMETERS CPL
WHERE NT.ROOT_KEY IN ( 'CSP_PLANNING'
, 'CSP_PARTS_SEARCH')
AND NT.NODE_TYPE = 'REGION'
AND CPL.PARENT_NODE_ID = 1 ORDER BY 1

Columns