HZ_RELATIONSHIP_TYPES_VL

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name

RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE FORWARD_REL_CODE BACKWARD_REL_CODE DIRECTION_CODE ALLOW_RELATE_TO_SELF_FLAG SUBJECT_TYPE OBJECT_TYPE STATUS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ALLOW_CIRCULAR_RELATIONSHIPS OBJECT_VERSION_NUMBER CREATED_BY_MODULE ROLE HIERARCHICAL_FLAG MULTIPLE_PARENT_ALLOWED TYPE_MEANING TYPE_DESCRIPTION FORWARD_REL_MEANING FORWARD_REL_DESCRIPTION BACKWARD_REL_MEANING BACKWARD_REL_DESCRIPTION ROLE_MEANING ROLE_DESCRIPTION

Query

SQL_Statement

SELECT hrt.RELATIONSHIP_TYPE_ID, hrt.RELATIONSHIP_TYPE, hrt.FORWARD_REL_CODE, hrt.BACKWARD_REL_CODE, hrt.DIRECTION_CODE, hrt.ALLOW_RELATE_TO_SELF_FLAG, hrt.SUBJECT_TYPE, hrt.OBJECT_TYPE, hrt.STATUS, hrt.CREATED_BY, hrt.CREATION_DATE, hrt.LAST_UPDATED_BY, hrt.LAST_UPDATE_DATE, hrt.LAST_UPDATE_LOGIN, hrt.ALLOW_CIRCULAR_RELATIONSHIPS, hrt.OBJECT_VERSION_NUMBER, hrt.CREATED_BY_MODULE, hrt.ROLE, hrt.HIERARCHICAL_FLAG, hrt.MULTIPLE_PARENT_ALLOWED, hrtl.TYPE_MEANING, hrtl.TYPE_DESCRIPTION, hrtl.FORWARD_REL_MEANING, hrtl.FORWARD_REL_DESCRIPTION, hrtl.BACKWARD_REL_MEANING, hrtl.BACKWARD_REL_DESCRIPTION, hrtl.ROLE_MEANING, hrtl.ROLE_DESCRIPTION FROM hz_relationship_types hrt, hz_relationship_types_tl hrtl WHERE hrt.RELATIONSHIP_TYPE_ID = hrtl.RELATIONSHIP_TYPE_ID and hrtl.LANGUAGE = USERENV('LANG')