PATCH_ARTIFACT_DEP

Details

Schema: FUSION
Object type: VIEW

Columns

Name
ARTIFACT_ID GUID APP_ID DEP_ID DEP_GUID DEP_REASON DEP_TYPE DEP_NAME DEP_CHOSEN_RESOLUTION DEP_DEFAULT_RESOLUTION

Name

ARTIFACT_ID

GUID

APP_ID

DEP_ID

DEP_GUID

DEP_REASON

DEP_TYPE

DEP_NAME

DEP_CHOSEN_RESOLUTION

DEP_DEFAULT_RESOLUTION

Query

SQL_Statement
SELECT b.artifact_id, b.guid, a.app_id, a.id DEP_ID, a.guid DEP_GUID, a.reason DEP_REASON, a.type DEP_TYPE, (case a.type when 'APPROLE_TO_MEMBER' then 'APPROLE_TO_MEMBER_ARTIFACT' when 'GRANTEE_TO_PERMISSION' then 'GRANTEE_TO_PERMISSION_ARTIFACT' when 'GRANTEE_TO_PERMISSION_SET' then 'GRANTEE_TO_PERMISSION_SET_ARTIFACT' when 'PERMISSION_SET_TO_RESOURCE' then 'PERMISSION_SET_TO_RESOURCE_ARTIFACT' when 'RESOURCE_TO_RESOURCE_TYPE' then 'RESOURCE_TO_RESOURCE_TYPE_ARTIFACT' when 'ROLE_TO_ROLE_CATEGORY' then 'ROLE_TO_ROLE_CATEGORY_ARTIFACT' else a.name end) DEP_NAME, a.choosen_resolution DEP_CHOSEN_RESOLUTION, a.default_resolution DEP_DEFAULT_RESOLUTION FROM patch_artifact a, patch_artifact_dependency b WHERE b.guid = a.guid

SQL_Statement

SELECT b.artifact_id, b.guid, a.app_id, a.id DEP_ID, a.guid DEP_GUID, a.reason DEP_REASON, a.type DEP_TYPE, (case a.type

when 'APPROLE_TO_MEMBER' then 'APPROLE_TO_MEMBER_ARTIFACT'

when 'GRANTEE_TO_PERMISSION' then 'GRANTEE_TO_PERMISSION_ARTIFACT'

when 'GRANTEE_TO_PERMISSION_SET' then 'GRANTEE_TO_PERMISSION_SET_ARTIFACT'

when 'PERMISSION_SET_TO_RESOURCE' then 'PERMISSION_SET_TO_RESOURCE_ARTIFACT'

when 'RESOURCE_TO_RESOURCE_TYPE' then 'RESOURCE_TO_RESOURCE_TYPE_ARTIFACT'

when 'ROLE_TO_ROLE_CATEGORY' then 'ROLE_TO_ROLE_CATEGORY_ARTIFACT'

else a.name end)

DEP_NAME, a.choosen_resolution DEP_CHOSEN_RESOLUTION, a.default_resolution DEP_DEFAULT_RESOLUTION FROM patch_artifact a, patch_artifact_dependency b WHERE b.guid = a.guid