View: CSP_PLN_REGION_ORG_NAV

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

View Text

SELECT CPL.NODE_NAME
, DECODE(CPL.NODE_TYPE
, 'SUBINVENTORY'
, 'SUBINVENTORY'
, 'ORGANIZATION_FE'
, 'ORGANIZATION'
, 'ORGANIZATION_WH'
, 'ORGANIZATION'
, 'REGION')
, TO_CHAR(CPL.PLANNING_PARAMETERS_ID)
, DECODE(CPL.NODE_TYPE
, 'SUBINVENTORY'
, DECODE(CPL.CONDITION_TYPE
, 'G'
, 'ECGRNFLG'
, 'B'
, 'ECRDFLG'
, NULL)
, 'ORGANIZATION_FE'
, 'MSC_ORGA'
, 'ORGANIZATION_WH'
, 'INVIORGA'
, NT.ICON_NAME) ICON_NAME
, DECODE(CPL.NODE_TYPE
, 'SUBINVENTORY'
, 'Y'
, 'ORGANIZATION_FE'
, 'N'
, 'ORGANIZATION_WH'
, 'Y'
, 'N')
, 'REGION'
, CPL.PARENT_NODE_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_PLANNING_PARAMETERS CPL
, CSP_SEC_INVENTORIES SI
WHERE NT.ROOT_KEY = 'CSP_PLANNING'
AND NT.NODE_TYPE = 'REGION'
AND CPL.NODE_TYPE IN ('SUBINVENTORY'
, 'REGION'
, 'ORGANIZATION_WH'
, 'ORGANIZATION_ FE')
AND CPL.ORGANIZATION_ID = SI.ORGANIZATION_ID (+)
AND CPL.SECONDARY_INVENTORY = SI.SECONDARY_INVENTORY_NAME (+) ORDER BY 2
, 4
, 1

Columns