Sales and Fusion Serviceの表およびビューZCA_EMAIL_FOOTER_TEMPLATES_VL 機械翻訳について ZCA_EMAIL_FOOTER_TEMPLATES_VL 詳細 スキーマ: FUSION オブジェクト所有者: ZCA オブジェクト・タイプ: VIEW 列 名前 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 問合せ 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')