VIEW: APPS.CSP_NOT_STAT_ITEMS_NAV

Source

View Text - Preformatted

SELECT msiv.concatenated_segments , nt.node_type , '"' || cn.inventory_item_id || '"' , nt.icon_name , 'Y' leaf_flag, 'NOTIF_STATUS' , '"' || cn.status || '"' || ',' || '"' || cn.reason || '"' || ','|| '"' || cn.parts_loop_id || '"' from csp_nav_node_types nt, csp_notifications cn, mtl_system_items_vl msiv where nt.root_key = 'CSP_NOTIF' and nt.node_type = 'NOTIF_ITEMS' and msiv.organization_id = csp_pick_utils.csp_global_org_id and cn.inventory_item_id = msiv.inventory_item_id order by 1

View Text - HTML Formatted

SELECT MSIV.CONCATENATED_SEGMENTS
, NT.NODE_TYPE
, '"' || CN.INVENTORY_ITEM_ID || '"'
, NT.ICON_NAME
, 'Y' LEAF_FLAG
, 'NOTIF_STATUS'
, '"' || CN.STATUS || '"' || '
, ' || '"' || CN.REASON || '"' || '
, '|| '"' || CN.PARTS_LOOP_ID || '"'
FROM CSP_NAV_NODE_TYPES NT
, CSP_NOTIFICATIONS CN
, MTL_SYSTEM_ITEMS_VL MSIV
WHERE NT.ROOT_KEY = 'CSP_NOTIF'
AND NT.NODE_TYPE = 'NOTIF_ITEMS'
AND MSIV.ORGANIZATION_ID = CSP_PICK_UTILS.CSP_GLOBAL_ORG_ID
AND CN.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID ORDER BY 1