View: OKC_LAUNCH_WFRESP_ATTR_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.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