機械翻訳について

ACA_DOCUMENT_VL

詳細

• スキーマ: FUSION

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

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

列

名前
DOCUMENT_ID OBJECT_VERSION_NUMBER DOCUMENT_TYPE DOCUMENT_NUMBER LATEST_REVISION_ID OWNER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION

問合せ

SQL_Statement

SELECT ACA_DOCUMENT_B.DOCUMENT_ID DOCUMENT_ID, ACA_DOCUMENT_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACA_DOCUMENT_B.DOCUMENT_TYPE DOCUMENT_TYPE, ACA_DOCUMENT_B.DOCUMENT_NUMBER DOCUMENT_NUMBER, ACA_DOCUMENT_B.LATEST_REVISION_ID LATEST_REVISION_ID, ACA_DOCUMENT_B.OWNER OWNER, ACA_DOCUMENT_B.CREATED_BY CREATED_BY, ACA_DOCUMENT_B.CREATION_DATE CREATION_DATE, ACA_DOCUMENT_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACA_DOCUMENT_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACA_DOCUMENT_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ACA_DOCUMENT_TL.NAME NAME, ACA_DOCUMENT_TL.DESCRIPTION DESCRIPTION FROM ACA_DOCUMENT_B, ACA_DOCUMENT_TL WHERE ACA_DOCUMENT_B.DOCUMENT_ID = ACA_DOCUMENT_TL.DOCUMENT_ID AND ACA_DOCUMENT_TL.LANGUAGE = USERENV('LANG')