View: CSP_PLN_ORG_NAV

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

View Text

SELECT OOD.ORGANIZATION_NAME LABEL
, NT.NODE_TYPE NODE_TYPE
, MP.ORGANIZATION_ID NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'N' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, NT.ROOT_KEY PARENT_NODE_KEY
FROM CSP_NAV_NODE_TYPES NT
, MTL_PARAMETERS MP
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSP_PLANNING_PARAMETERS CPP
WHERE NT.ROOT_KEY = 'CSP_PLANNING'
AND NT.NODE_TYPE = 'ORGANIZATION'
AND MP.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND (MP.ORGANIZATION_ID = CPP.ORGANIZATION_ID(+)
AND CPP.SECONDARY_INVENTORY IS NULL) ORDER BY CPP.ORGANIZATION_TYPE
, 1

Columns