VIEW: APPS.OKC_LAUNCH_WFRESP_ATTR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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