Product: | AR - Receivables |
---|---|
Description: | Internal view for Relationship Types |
Implementation/DBA Data: | APPS.HZ_WSRVC_REL_TYPES_V |
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)