機械翻訳について

ZCA_OBJECT_SHARE_ELASTIC_VIEW

詳細

• スキーマ: FUSION

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

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

列

名前
OBJECT_ID ACCESS_GROUP_ID OBJECT_TYPE ACCESS_LEVEL_CODE OBJECT_NUMBER ACCESS_GROUP_NUMBER

問合せ

SQL_Statement

SELECT OBJECT_ID,ACCESS_GROUP_ID,OBJECT_TYPE,ACCESS_LEVEL_CODE,OBJECT_NUMBER,ACCESS_GROUP_NUMBER FROM ZCA_OBJECT_SHARE WHERE ACCESS_GROUP_TYPE_CODE NOT IN ('ORA_ZCA_RESOURCE_ANCESTORS','ORA_ZCA_TERRITORY_ANCESTORS','ORA_ZCA_PARTNER_ANCESTORS','ORA_ZCA_QUEUE_ANCESTORS','ORA_ZCA_TERR_ADMIN_ANCESTORS','ORA_ZCA_TERR_DELEG_ANCESTORS','ORA_ZCA_TERR_OWNER_ANCESTORS') UNION ALL SELECT S.OBJECT_ID,G.ACCESS_GROUP_ID,S.OBJECT_TYPE,S.ACCESS_LEVEL_CODE,S.OBJECT_NUMBER,G.ACCESS_GROUP_NUMBER FROM ZCA_OBJECT_SHARE S , ZCA_ACCESS_GROUP_MEMBERS GM ,ZCA_ACCESS_GROUPS G WHERE S.ACCESS_GROUP_TYPE_CODE IN ('ORA_ZCA_RESOURCE_ANCESTORS','ORA_ZCA_TERRITORY_ANCESTORS','ORA_ZCA_PARTNER_ANCESTORS','ORA_ZCA_QUEUE_ANCESTORS','ORA_ZCA_TERR_ADMIN_ANCESTORS','ORA_ZCA_TERR_DELEG_ANCESTORS','ORA_ZCA_TERR_OWNER_ANCESTORS') AND S.ACCESS_GROUP_ID=GM.ACCESS_GROUP_ID AND GM.PARTY_ID=G.SOURCE_ID1 AND G.TYPE_CODE ='ORA_ZCA_RESOURCE'