MOT_AC_GROUP_RESOURCES_HIER_V

Details

• Schema: FUSION

• Object owner: MOT

• Object type: VIEW

Columns

Name
RESOURCE_ID TYPE_CODE PARENT_GROUP_ID OWNER_FLAG GROUP_ID

Query

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