ZCA_EMAIL_TEMPLATES_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name
TEMPLATE_ID TEMPLATE_NUMBER TEMPLATE_ACTIVE_FLAG EMAIL_FORMAT OBJECT_CODE FOOTER_TEMPLATE_ID TEMPLATE_NAME TEMPLATE_DESCRIPTION EMAIL_SUBJECT EMAIL_BODY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT ZCA_EMAIL_TEMPLATES_B.TEMPLATE_ID TEMPLATE_ID, ZCA_EMAIL_TEMPLATES_B.TEMPLATE_NUMBER TEMPLATE_NUMBER, ZCA_EMAIL_TEMPLATES_B.TEMPLATE_ACTIVE_FLAG TEMPLATE_ACTIVE_FLAG, ZCA_EMAIL_TEMPLATES_B.EMAIL_FORMAT EMAIL_FORMAT, ZCA_EMAIL_TEMPLATES_B.OBJECT_CODE OBJECT_CODE, ZCA_EMAIL_TEMPLATES_B.FOOTER_TEMPLATE_ID FOOTER_TEMPLATE_ID, ZCA_EMAIL_TEMPLATES_TL.TEMPLATE_NAME TEMPLATE_NAME, ZCA_EMAIL_TEMPLATES_TL.TEMPLATE_DESCRIPTION TEMPLATE_DESCRIPTION, ZCA_EMAIL_TEMPLATES_TL.EMAIL_SUBJECT EMAIL_SUBJECT, ZCA_EMAIL_TEMPLATES_TL.EMAIL_BODY EMAIL_BODY, ZCA_EMAIL_TEMPLATES_B.CREATED_BY CREATED_BY, ZCA_EMAIL_TEMPLATES_B.CREATION_DATE CREATION_DATE, ZCA_EMAIL_TEMPLATES_B.LAST_UPDATED_BY LAST_UPDATED_BY, ZCA_EMAIL_TEMPLATES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ZCA_EMAIL_TEMPLATES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ZCA_EMAIL_TEMPLATES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM ZCA_EMAIL_TEMPLATES_B, ZCA_EMAIL_TEMPLATES_TL WHERE ZCA_EMAIL_TEMPLATES_B.TEMPLATE_ID = ZCA_EMAIL_TEMPLATES_TL.TEMPLATE_ID AND ZCA_EMAIL_TEMPLATES_TL.LANGUAGE = USERENV('LANG')