View: CSP_NOT_PLOOP_NAV

Product:	CSP - Spares Management
Description:	View for Notification Root to Parts Loop flow
Implementation/DBA Data:	APPS.CSP_NOT_PLOOP_NAV

View Text

SELECT PL.PARTS_LOOP_NAME
, NT.NODE_TYPE
, PL.PARTS_LOOP_ID
, NT.ICON_NAME
, 'N'
, 'ROOT'
, NT.ROOT_KEY
FROM CSP_NAV_NODE_TYPES NT
, CSP_PARTS_LOOPS_B PL
WHERE NT.ROOT_KEY = 'CSP_NOTIF'
AND NT.NODE_TYPE = 'NOTIF_PARTS_LOOP' ORDER BY 1

Columns