View: CSP_PLN_SUBINV_NAV

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

View Text

SELECT MSI.SECONDARY_INVENTORY_NAME LABEL
, NT.NODE_TYPE NODE_TYPE
, MSI.SECONDARY_INVENTORY_NAME NODE_KEY
, DECODE(CSI.CONDITION_TYPE
, 'G'
, 'ECGRNFLG'
, 'B'
, 'ECRDFLG'
, NT.ICON_NAME) ICON_NAME
, 'Y' LEAF_FLAG
, 'ORGANIZATION' PARENT_NODE_TYPE
, MSI.ORGANIZATION_ID PARENT_NODE_KEY
FROM CSP_NAV_NODE_TYPES NT
, MTL_SECONDARY_INVENTORIES MSI
, MTL_PARAMETERS MP
, CSP_SEC_INVENTORIES CSI
WHERE NT.ROOT_KEY = 'CSP_PLANNING'
AND NT.NODE_TYPE = 'SUBINVENTORY'
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CSI.ORGANIZATION_ID (+) = MSI.ORGANIZATION_ID
AND CSI.SECONDARY_INVENTORY_NAME (+) = MSI.SECONDARY_INVENTORY_NAME ORDER BY 4
, 1

Columns