[Home] [Help]
View: OKC_LAUNCH_WFRESP_ATTR_V
View Text
SELECT N.NOTIFICATION_ID
, N.MESSAGE_TYPE
, N.MESSAGE_NAME
, NA.NAME
, MAT.DISPLAY_NAME
, MA.TYPE
, MA.SUBTYPE
, MA.FORMAT
, MA.TEXT_DEFAULT
, MA.NUMBER_DEFAULT
, MA.DATE_DEFAULT
, MA.FORMAT ENTERED_VALUE
FROM WF_NOTIFICATIONS N
, WF_NOTIFICATION_ATTRIBUTES NA
, WF_MESSAGE_ATTRIBUTES MA
, WF_MESSAGE_ATTRIBUTES_TL MAT
WHERE N.NOTIFICATION_ID = NA.NOTIFICATION_ID
AND N.MESSAGE_TYPE = MA.MESSAGE_TYPE
AND N.MESSAGE_NAME = MA.MESSAGE_NAME
AND NA.NAME = MA.NAME
AND MA.MESSAGE_TYPE = MAT.MESSAGE_TYPE
AND MA.MESSAGE_NAME = MAT.MESSAGE_NAME
AND MA.NAME = MAT.NAME
Columns
Name |
NOTIFICATION_ID |
MESSAGE_TYPE |
MESSAGE_NAME |
NAME |
DISPLAY_NAME |
TYPE |
SUBTYPE |
FORMAT |
TEXT_DEFAULT |
NUMBER_DEFAULT |
DATE_DEFAULT |
ENTERED_VALUE |