MOT_AC_GROUP_RESOURCES_HIER_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MOT
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
RESOURCE_ID TYPE_CODE PARENT_GROUP_ID OWNER_FLAG GROUP_ID |
問合せ
| SQL_Statement |
|---|
|
SELECT ACR.RESOURCE_ID AS RESOURCE_ID, ACR.TYPE_CODE AS TYPE_CODE, ACR.GROUP_ID AS PARENT_GROUP_ID, ACR.OWNER_FLAG AS OWNER_FLAG, ACH.GROUP_ID AS GROUP_ID FROM MOT_AC_GROUP_RESOURCES ACR, MOT_AC_GROUP_HIER_RF_DN ACH WHERE ACR.GROUP_ID = ACH.PARENT_GROUP_ID AND ACR.TYPE_CODE=ACH.TYPE_CODE |