機械翻訳について

POR_INFO_TEMPLATES_ALL_VL

詳細

• スキーマ: FUSION

• オブジェクト所有者: POR

• オブジェクト・タイプ: VIEW

列

名前
INFO_TEMPLATE_ID PRC_BU_ID INFO_TEMPLATE_CODE INFO_TEMPLATE_NAME DESCRIPTION INACTIVE_DATE DFF_CONTEXT_CODE ATTACHMENT_CATEGORY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

問合せ

SQL_Statement

SELECT B.INFO_TEMPLATE_ID INFO_TEMPLATE_ID, B.PRC_BU_ID PRC_BU_ID, B.INFO_TEMPLATE_CODE INFO_TEMPLATE_CODE, TL.INFO_TEMPLATE_NAME INFO_TEMPLATE_NAME, TL.DESCRIPTION DESCRIPTION, B.INACTIVE_DATE INACTIVE_DATE, B.DFF_CONTEXT_CODE DFF_CONTEXT_CODE, B.ATTACHMENT_CATEGORY ATTACHMENT_CATEGORY, 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 FROM POR_INFO_TEMPLATES_ALL_B B, POR_INFO_TEMPLATES_ALL_TL TL WHERE B.INFO_TEMPLATE_ID = TL.INFO_TEMPLATE_ID AND TL.LANGUAGE = USERENV('LANG')