[Home] [Help]
View: CSP_NOT_TYSTAT_NAV
Product: | CSP - Spares Management |
Description: | View for Notification Types to Status flow |
Implementation/DBA Data: |
APPS.CSP_NOT_TYSTAT_NAV
|
View Text
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
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |