View: CSP_PLIST_BOXES_NAV

Product:	CSP - Spares Management
Description:	View for Packlist to Boxes flow
Implementation/DBA Data:	APPS.CSP_PLIST_BOXES_NAV

View Text

SELECT PB.BOX_NAME
, NT.NODE_TYPE
, PB.BOX_ID
, NT.ICON_NAME
, 'N'
, 'PACK_LIST'
, PB.PACKLIST_HEADER_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_PACKLIST_BOXES PB
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PLIST_BOX' ORDER BY 1

Columns