FAI_MSG_DLVY_OPTNS_VL

Details

• Schema: FUSION

• Object owner: FAI

• Object type: VIEW

Columns

Name
OPTION_ID OPTION_CODE TOOL_ID DELIVERY_OPTION_TYPE OBJECT_CODE TEMPLATE_NAME OPTION_PROPERTIES SEEDED_FLAG MODULE_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SUBJECT MESSAGE_CONTENT

Query

SQL_Statement

SELECT b.OPTION_ID OPTION_ID, b.OPTION_CODE OPTION_CODE, b.TOOL_ID TOOL_ID, b.DELIVERY_OPTION_TYPE DELIVERY_OPTION_TYPE, b.OBJECT_CODE OBJECT_CODE, b.TEMPLATE_NAME TEMPLATE_NAME, b.OPTION_PROPERTIES OPTION_PROPERTIES, b.SEEDED_FLAG SEEDED_FLAG, b.MODULE_ID MODULE_ID, b.CREATED_BY CREATED_BY, b.CREATION_DATE CREATION_DATE, b.LAST_UPDATED_BY LAST_UPDATED_BY, b.LAST_UPDATE_DATE LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, tl.SUBJECT SUBJECT, tl.MESSAGE_CONTENT MESSAGE_CONTENT FROM FAI_MSG_DLVY_OPTNS_B b, FAI_MSG_DLVY_OPTNS_TL tl WHERE b.OPTION_ID = tl.OPTION_ID AND tl.LANGUAGE = USERENV('LANG')