ACA_WF_OBJECT_TYPES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ACA
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
OBJECT_TYPE_ID OBJECT_VERSION_NUMBER OBJECT_CODE PARENT_OBJECT_CODE OBJECT_DISPLAY_NAME DESCRIPTION DELETE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
問合せ
| SQL_Statement |
|---|
|
SELECT ACA_WF_OBJECT_TYPES_B.OBJECT_TYPE_ID OBJECT_TYPE_ID, ACA_WF_OBJECT_TYPES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACA_WF_OBJECT_TYPES_B.OBJECT_CODE OBJECT_CODE, ACA_WF_OBJECT_TYPES_B.PARENT_OBJECT_CODE PARENT_OBJECT_CODE, ACA_WF_OBJECT_TYPES_TL.OBJECT_DISPLAY_NAME OBJECT_DISPLAY_NAME, ACA_WF_OBJECT_TYPES_TL.DESCRIPTION DESCRIPTION, ACA_WF_OBJECT_TYPES_B.DELETE_FLAG DELETE_FLAG, ACA_WF_OBJECT_TYPES_B.CREATED_BY CREATED_BY, ACA_WF_OBJECT_TYPES_B.CREATION_DATE CREATION_DATE, ACA_WF_OBJECT_TYPES_B.LAST_UPDATED_BY LAST_UPDATED_BY, ACA_WF_OBJECT_TYPES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, ACA_WF_OBJECT_TYPES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM ACA_WF_OBJECT_TYPES_B, ACA_WF_OBJECT_TYPES_TL WHERE ACA_WF_OBJECT_TYPES_B.OBJECT_TYPE_ID = ACA_WF_OBJECT_TYPES_TL.OBJECT_TYPE_ID AND ACA_WF_OBJECT_TYPES_TL.LANGUAGE = USERENV('LANG') |