VIEW: AR.HZ_RELATIONSHIP_TYPES#

Source

View Text - Preformatted

select RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID, RELATIONSHIP_TYPE RELATIONSHIP_TYPE, FORWARD_REL_CODE FORWARD_REL_CODE, BACKWARD_REL_CODE BACKWARD_REL_CODE, DIRECTION_CODE DIRECTION_CODE, HIERARCHICAL_FLAG HIERARCHICAL_FLAG, CREATE_PARTY_FLAG CREATE_PARTY_FLAG, ALLOW_RELATE_TO_SELF_FLAG ALLOW_RELATE_TO_SELF_FLAG, SUBJECT_TYPE SUBJECT_TYPE, OBJECT_TYPE OBJECT_TYPE, STATUS STATUS, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ALLOW_CIRCULAR_RELATIONSHIPS ALLOW_CIRCULAR_RELATIONSHIPS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY_MODULE CREATED_BY_MODULE, APPLICATION_ID APPLICATION_ID, MULTIPLE_PARENT_ALLOWED MULTIPLE_PARENT_ALLOWED, INCL_UNRELATED_ENTITIES INCL_UNRELATED_ENTITIES, ROLE ROLE, DO_NOT_ALLOW_CONVERT DO_NOT_ALLOW_CONVERT, ZD_EDITION_NAME ZD_EDITION_NAME from "AR"."HZ_RELATIONSHIP_TYPES"

View Text - HTML Formatted

SELECT RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID
, RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, FORWARD_REL_CODE FORWARD_REL_CODE
, BACKWARD_REL_CODE BACKWARD_REL_CODE
, DIRECTION_CODE DIRECTION_CODE
, HIERARCHICAL_FLAG HIERARCHICAL_FLAG
, CREATE_PARTY_FLAG CREATE_PARTY_FLAG
, ALLOW_RELATE_TO_SELF_FLAG ALLOW_RELATE_TO_SELF_FLAG
, SUBJECT_TYPE SUBJECT_TYPE
, OBJECT_TYPE OBJECT_TYPE
, STATUS STATUS
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ALLOW_CIRCULAR_RELATIONSHIPS ALLOW_CIRCULAR_RELATIONSHIPS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE CREATED_BY_MODULE
, APPLICATION_ID APPLICATION_ID
, MULTIPLE_PARENT_ALLOWED MULTIPLE_PARENT_ALLOWED
, INCL_UNRELATED_ENTITIES INCL_UNRELATED_ENTITIES
, ROLE ROLE
, DO_NOT_ALLOW_CONVERT DO_NOT_ALLOW_CONVERT
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "AR"."HZ_RELATIONSHIP_TYPES"