View: CSP_PLIST_ITMSLNO_NAV

Product:	CSP - Spares Management
Description:	View for packlist items to Serial/Lot flow
Implementation/DBA Data:	APPS.CSP_PLIST_ITMSLNO_NAV

View Text

SELECT PSL.SERIAL_NUMBER || DECODE(LOT_NUMBER
, NULL
, ' '
, '/' || LOT_NUMBER) LABEL
, NT.NODE_TYPE NODE_TYPE
, PSL.PACKLIST_SERIAL_LOT_ID NODE_KEY
, NT.ICON_NAME ICON_NAME
, 'Y' LEAF_FLAG
, 'PLIST_ITEMS' PARENT_NODE_TYPE
, PLL.PACKLIST_LINE_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_PACKLIST_SERIAL_LOTS PSL
, CSP_PACKLIST_LINES PLL
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PLIST_SERIAL_LOT'
AND PSL.ORGANIZATION_ID = PLL.ORGANIZATION_ID
AND PSL.PACKLIST_LINE_ID = PLL.PACKLIST_LINE_ID ORDER BY 1

Columns