[Home] [Help]
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
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |