View: CSP_PACK_LIST_NAV

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

View Text

SELECT PH.PACKLIST_NUMBER
, NT.NODE_TYPE
, PH.PACKLIST_HEADER_ID
, NT.ICON_NAME
, 'N'
, 'PLIST_STATUS'
, PH.PACKLIST_STATUS
FROM CSP_NAV_NODE_TYPES NT
, CSP_PACKLIST_HEADERS PH
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PACK_LIST'
AND PH.ORGANIZATION_ID = CSP_PICK_UTILS.CSP_GLOBAL_ORG_ID ORDER BY 1

Columns