PSC_COM_CC_TEMPLATES

Details

Schema: FUSION
Object owner: PSC_CC
Object type: VIEW

Columns

Name
TEMPLATE_ID TEMPLATE_CODE RESOURCE_ID EVENT_ID CHANNEL_TYPE ALERT_START ALERT_END MIME_TYPE ENABLED_FLAG ATTACHMENTS_ENABLED ATTACHMENT_KEY_REF PRIORITY VISIBILITY ATTRIBUTES FROM_ADDRESS TO_EMAIL_ADDRESS CC_EMAIL_ADDRESS BCC_EMAIL_ADDRESS TO_PHONE_NUMBER TO_USERID TEMPLATE_NAME SHORT_MESSAGE SUBJECT BODY LANGUAGE SOURCE_LANG COMMENTS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER RUN_EXPRESSION AGENCY_ID DEFAULT_LANGUAGE MODULE_ID MESSAGE_DELETE_ALLOWED ATTACHMENT_ATTRIBUTES

Name

TEMPLATE_ID

TEMPLATE_CODE

RESOURCE_ID

EVENT_ID

CHANNEL_TYPE

ALERT_START

ALERT_END

MIME_TYPE

ENABLED_FLAG

ATTACHMENTS_ENABLED

ATTACHMENT_KEY_REF

PRIORITY

VISIBILITY

ATTRIBUTES

FROM_ADDRESS

TO_EMAIL_ADDRESS

CC_EMAIL_ADDRESS

BCC_EMAIL_ADDRESS

TO_PHONE_NUMBER

TO_USERID

TEMPLATE_NAME

SHORT_MESSAGE

SUBJECT

BODY

LANGUAGE

SOURCE_LANG

COMMENTS

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

RUN_EXPRESSION

AGENCY_ID

DEFAULT_LANGUAGE

MODULE_ID

MESSAGE_DELETE_ALLOWED

ATTACHMENT_ATTRIBUTES

Query

SQL_Statement
SELECT b.TEMPLATE_ID TEMPLATE_ID, b.TEMPLATE_CODE TEMPLATE_CODE, b.RESOURCE_ID RESOURCE_ID, b.EVENT_ID EVENT_ID, b.CHANNEL_TYPE CHANNEL_TYPE, b.ALERT_START ALERT_START, b.ALERT_END ALERT_END, b.MIME_TYPE MIME_TYPE, b.ENABLED_FLAG ENABLED_FLAG, b.ATTACHMENTS_ENABLED, b.ATTACHMENT_KEY_REF, b.PRIORITY PRIORITY, b.VISIBILITY VISIBILITY, b.ATTRIBUTES ATTRIBUTES, b.FROM_ADDRESS FROM_ADDRESS , b.TO_EMAIL_ADDRESS TO_EMAIL_ADDRESS, b.CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS, b.BCC_EMAIL_ADDRESS BCC_EMAIL_ADDRESS, b.TO_PHONE_NUMBER TO_PHONE_NUMBER, b.TO_USERID TO_USERID, tl.TEMPLATE_NAME TEMPLATE_NAME, tl.SHORT_MESSAGE SHORT_MESSAGE, tl.SUBJECT SUBJECT, tl.BODY BODY, tl.LANGUAGE LANGUAGE, tl.SOURCE_LANG SOURCE_LANG, tl.COMMENTS COMMENTS, 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, b.RUN_EXPRESSION RUN_EXPRESSION, b.AGENCY_ID AGENCY_ID, b.DEFAULT_LANGUAGE DEFAULT_LANGUAGE , b.MODULE_ID MODULE_ID, b.MESSAGE_DELETE_ALLOWED MESSAGE_DELETE_ALLOWED, b.ATTACHMENT_ATTRIBUTES FROM PSC_COM_CC_TEMPLATES_B b, PSC_COM_CC_TEMPLATES_TL tl WHERE b.TEMPLATE_ID = tl.TEMPLATE_ID AND tl.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

b.TEMPLATE_ID TEMPLATE_ID,

b.TEMPLATE_CODE TEMPLATE_CODE,

b.RESOURCE_ID RESOURCE_ID,

b.EVENT_ID EVENT_ID,

b.CHANNEL_TYPE CHANNEL_TYPE,

b.ALERT_START ALERT_START,

b.ALERT_END ALERT_END,

b.MIME_TYPE MIME_TYPE,

b.ENABLED_FLAG ENABLED_FLAG,

b.ATTACHMENTS_ENABLED,

b.ATTACHMENT_KEY_REF,

b.PRIORITY PRIORITY,

b.VISIBILITY VISIBILITY,

b.ATTRIBUTES ATTRIBUTES,

b.FROM_ADDRESS FROM_ADDRESS ,

b.TO_EMAIL_ADDRESS TO_EMAIL_ADDRESS,

b.CC_EMAIL_ADDRESS CC_EMAIL_ADDRESS,

b.BCC_EMAIL_ADDRESS BCC_EMAIL_ADDRESS,

b.TO_PHONE_NUMBER TO_PHONE_NUMBER,

b.TO_USERID TO_USERID,

tl.TEMPLATE_NAME TEMPLATE_NAME,

tl.SHORT_MESSAGE SHORT_MESSAGE,

tl.SUBJECT SUBJECT,

tl.BODY BODY,

tl.LANGUAGE LANGUAGE,

tl.SOURCE_LANG SOURCE_LANG,

tl.COMMENTS COMMENTS,

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,

b.RUN_EXPRESSION RUN_EXPRESSION,

b.AGENCY_ID AGENCY_ID,

b.DEFAULT_LANGUAGE DEFAULT_LANGUAGE ,

b.MODULE_ID MODULE_ID,

b.MESSAGE_DELETE_ALLOWED MESSAGE_DELETE_ALLOWED,

b.ATTACHMENT_ATTRIBUTES

FROM

PSC_COM_CC_TEMPLATES_B b,

PSC_COM_CC_TEMPLATES_TL tl

WHERE

b.TEMPLATE_ID = tl.TEMPLATE_ID AND tl.LANGUAGE = USERENV('LANG')