VIEW: APPS.CSP_PLIST_ITMSLNO_NAV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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