VIEW: APPS.CSP_PLIST_BOXITEMS_NAV

Source

View Text - Preformatted

SELECT pll.quantity_packed || '   ' || msiv.concatenated_segments , nt.node_type , pll.packlist_line_id , nt.icon_name , 'N' , 'PLIST_BOX' , pll.box_id from csp_nav_node_types nt, csp_packlist_lines pll, mtl_system_items_vl msiv where nt.root_key = 'CSP_PACKLIST' and nt.node_type = 'PLIST_ITEMS' and pll.inventory_item_id = msiv.inventory_item_id and pll.organization_id = msiv.organization_id order by 1

View Text - HTML Formatted

SELECT PLL.QUANTITY_PACKED || ' ' || MSIV.CONCATENATED_SEGMENTS
, NT.NODE_TYPE
, PLL.PACKLIST_LINE_ID
, NT.ICON_NAME
, 'N'
, 'PLIST_BOX'
, PLL.BOX_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_PACKLIST_LINES PLL
, MTL_SYSTEM_ITEMS_VL MSIV
WHERE NT.ROOT_KEY = 'CSP_PACKLIST'
AND NT.NODE_TYPE = 'PLIST_ITEMS'
AND PLL.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND PLL.ORGANIZATION_ID = MSIV.ORGANIZATION_ID ORDER BY 1