VIEW: APPS.CSP_NOT_TYSTAT_NAV

Source

View Text - Preformatted

SELECT fl1.meaning , nt.node_type , '"' || fl1.lookup_code || '"' || ',' || '"' || fl2.lookup_code || '"'|| ',' || '"' || pl.parts_loop_id || '"' , nt.icon_name , 'N' , 'NOTIF_TYPES' , '"' || fl2.lookup_code || '"' || ',' || '"' || pl.parts_loop_id || '"' from csp_nav_node_types nt, fnd_lookups fl1,fnd_lookups fl2, csp_parts_loops_b pl where nt.root_key = 'CSP_NOTIF' and nt.node_type = 'NOTIF_STATUS' and fl1.lookup_type = 'CSP_NOTIFICATION_STATUS' and fl2.lookup_type = 'CSP_NOTIFICATION_TYPES' order by fl1.lookup_code, 3

View Text - HTML Formatted

SELECT FL1.MEANING
, NT.NODE_TYPE
, '"' || FL1.LOOKUP_CODE || '"' || '
, ' || '"' || FL2.LOOKUP_CODE || '"'|| '
, ' || '"' || PL.PARTS_LOOP_ID || '"'
, NT.ICON_NAME
, 'N'
, 'NOTIF_TYPES'
, '"' || FL2.LOOKUP_CODE || '"' || '
, ' || '"' || PL.PARTS_LOOP_ID || '"'
FROM CSP_NAV_NODE_TYPES NT
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, CSP_PARTS_LOOPS_B PL
WHERE NT.ROOT_KEY = 'CSP_NOTIF'
AND NT.NODE_TYPE = 'NOTIF_STATUS'
AND FL1.LOOKUP_TYPE = 'CSP_NOTIFICATION_STATUS'
AND FL2.LOOKUP_TYPE = 'CSP_NOTIFICATION_TYPES' ORDER BY FL1.LOOKUP_CODE
, 3