VIEW: APPS.HZ_WSRVC_REL_TYPES_V

Source

View Text - Preformatted

SELECT A.RELATIONSHIP_TYPE_ID, A.RELATIONSHIP_TYPE, A.FORWARD_REL_CODE, A.BACKWARD_REL_CODE, A.DIRECTION_CODE, A.HIERARCHICAL_FLAG, A.CREATE_PARTY_FLAG, A.ALLOW_RELATE_TO_SELF_FLAG, A.SUBJECT_TYPE, A.OBJECT_TYPE, A.STATUS, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, A.ALLOW_CIRCULAR_RELATIONSHIPS, A.OBJECT_VERSION_NUMBER, A.CREATED_BY_MODULE, A.APPLICATION_ID, A.MULTIPLE_PARENT_ALLOWED, A.INCL_UNRELATED_ENTITIES, A.ROLE FORWARD_ROLE, B.ROLE BACKWARD_ROLE FROM HZ_RELATIONSHIP_TYPES A, HZ_RELATIONSHIP_TYPES B WHERE A.RELATIONSHIP_TYPE = B.RELATIONSHIP_TYPE AND ((A.RELATIONSHIP_TYPE_ID <> B.RELATIONSHIP_TYPE_ID AND A.DIRECTION_CODE IN ('P','C') AND A.FORWARD_REL_CODE = B.BACKWARD_REL_CODE AND A.BACKWARD_REL_CODE = B.FORWARD_REL_CODE AND A.SUBJECT_TYPE = B.OBJECT_TYPE AND A.OBJECT_TYPE = B.SUBJECT_TYPE) OR A.FORWARD_REL_CODE = A.BACKWARD_REL_CODE)

View Text - HTML Formatted

SELECT A.RELATIONSHIP_TYPE_ID
, A.RELATIONSHIP_TYPE
, A.FORWARD_REL_CODE
, A.BACKWARD_REL_CODE
, A.DIRECTION_CODE
, A.HIERARCHICAL_FLAG
, A.CREATE_PARTY_FLAG
, A.ALLOW_RELATE_TO_SELF_FLAG
, A.SUBJECT_TYPE
, A.OBJECT_TYPE
, A.STATUS
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.ALLOW_CIRCULAR_RELATIONSHIPS
, A.OBJECT_VERSION_NUMBER
, A.CREATED_BY_MODULE
, A.APPLICATION_ID
, A.MULTIPLE_PARENT_ALLOWED
, A.INCL_UNRELATED_ENTITIES
, A.ROLE FORWARD_ROLE
, B.ROLE BACKWARD_ROLE
FROM HZ_RELATIONSHIP_TYPES A
, HZ_RELATIONSHIP_TYPES B
WHERE A.RELATIONSHIP_TYPE = B.RELATIONSHIP_TYPE
AND ((A.RELATIONSHIP_TYPE_ID <> B.RELATIONSHIP_TYPE_ID
AND A.DIRECTION_CODE IN ('P'
, 'C')
AND A.FORWARD_REL_CODE = B.BACKWARD_REL_CODE
AND A.BACKWARD_REL_CODE = B.FORWARD_REL_CODE
AND A.SUBJECT_TYPE = B.OBJECT_TYPE
AND A.OBJECT_TYPE = B.SUBJECT_TYPE) OR A.FORWARD_REL_CODE = A.BACKWARD_REL_CODE)