Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: VIEW
Columns
Name |
---|
TEMPLATE_ID TEMPLATE_NUMBER ACTIVE_FLAG FOOTER_FORMAT TEMPLATE_NAME TEMPLATE_DESCRIPTION FOOTER_CONTENT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER |
Query
SQL_Statement |
---|
SELECT ZCA_EMAIL_FOOTER_TEMPLATES_B.TEMPLATE_ID TEMPLATE_ID, ZCA_EMAIL_FOOTER_TEMPLATES_B.TEMPLATE_NUMBER TEMPLATE_NUMBER, ZCA_EMAIL_FOOTER_TEMPLATES_B.ACTIVE_FLAG ACTIVE_FLAG, ZCA_EMAIL_FOOTER_TEMPLATES_B.FOOTER_FORMAT FOOTER_FORMAT, ZCA_EMAIL_FOOTER_TEMPLATES_TL.TEMPLATE_NAME TEMPLATE_NAME, ZCA_EMAIL_FOOTER_TEMPLATES_TL.TEMPLATE_DESCRIPTION TEMPLATE_DESCRIPTION, ZCA_EMAIL_FOOTER_TEMPLATES_TL.FOOTER_CONTENT FOOTER_CONTENT, ZCA_EMAIL_FOOTER_TEMPLATES_B.CREATED_BY CREATED_BY, ZCA_EMAIL_FOOTER_TEMPLATES_B.CREATION_DATE CREATION_DATE, ZCA_EMAIL_FOOTER_TEMPLATES_B.LAST_UPDATED_BY LAST_UPDATED_BY, ZCA_EMAIL_FOOTER_TEMPLATES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ZCA_EMAIL_FOOTER_TEMPLATES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ZCA_EMAIL_FOOTER_TEMPLATES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM ZCA_EMAIL_FOOTER_TEMPLATES_B, ZCA_EMAIL_FOOTER_TEMPLATES_TL WHERE ZCA_EMAIL_FOOTER_TEMPLATES_B.TEMPLATE_ID = ZCA_EMAIL_FOOTER_TEMPLATES_TL.TEMPLATE_ID AND ZCA_EMAIL_FOOTER_TEMPLATES_TL.LANGUAGE = USERENV('LANG') |