View: CSP_PLIST_STATUS_NAV

Product:	CSP - Spares Management
Description:	View for Packlist Root to Packlist status
Implementation/DBA Data:	APPS.CSP_PLIST_STATUS_NAV

View Text

SELECT FL.MEANING
, NT.NODE_TYPE
, FL.LOOKUP_CODE
, NT.ICON_NAME
, 'N'
, 'ROOT'
, NT.ROOT_KEY
FROM CSP_NAV_NODE_TYPES NT
, FND_LOOKUPS FL
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PLIST_STATUS'
AND FL.LOOKUP_TYPE = 'CSP_PACKLIST_STATUS' ORDER BY 1

Columns