機械翻訳について

ZCA_SHARE_REASON_ELASTIC_VIEW

詳細

• スキーマ: FUSION

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

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

列

名前
OBJECT_ID OBJECT_NUMBER ASSIGNMENT_RULE_GROUP_ID OBJECT_TYPE

問合せ

SQL_Statement

SELECT S.OBJECT_ID,S.OBJECT_NUMBER,SR.ASSIGNMENT_RULE_GROUP_ID,SR.OBJECT_TYPE FROM ZCA_OBJECT_SHARE_REASON SR, ZCA_OBJECT_SHARE S WHERE S.OBJECT_TYPE=SR.OBJECT_TYPE AND S.OBJECT_SHARE_ID=SR.OBJECT_SHARE_ID UNION ALL SELECT S.OBJECT_ID,S.OBJECT_NUMBER,AER.SRC_OBJ_ACCESS_GROUP_ID,SR.OBJECT_TYPE FROM ZCA_OBJECT_SHARE_REASON SR, ZCA_OBJECT_SHARE S, ZCA_AG_ACC_EXT_RULE_DN AER WHERE S.OBJECT_TYPE=SR.OBJECT_TYPE AND S.OBJECT_SHARE_ID=SR.OBJECT_SHARE_ID AND SR.SRC_ACC_EXT_RULE_DN_ID=AER.ACC_EXT_RULE_DN_ID