View: HZ_RELATIONSHIP_GROUPINGS_V

Product:	AR - Receivables
Description:	Relationship Groupings
Implementation/DBA Data:	APPS.HZ_RELATIONSHIP_GROUPINGS_V

View Text

SELECT CA.CLASS_CODE REL_GROUP_CODE
, CA.START_DATE_ACTIVE
, CA.END_DATE_ACTIVE
, CA.OWNER_TABLE_ID RELATIONSHIP_TYPE_ID
, RT.RELATIONSHIP_TYPE
, RT.FORWARD_REL_CODE
, RT.BACKWARD_REL_CODE
, RT.ROLE
, RR.DESCRIPTION ROLE_MEANING_SINGULAR
, RR.MEANING ROLE_MEANING_PLURAL
, RT.DIRECTION_CODE
, RT.HIERARCHICAL_FLAG
, RT.CREATE_PARTY_FLAG
, RT.ALLOW_RELATE_TO_SELF_FLAG
, RT.SUBJECT_TYPE
, RT.OBJECT_TYPE
FROM HZ_CODE_ASSIGNMENTS CA
, AR_LOOKUPS RR
, HZ_RELATIONSHIP_TYPES RT
WHERE CA.CLASS_CATEGORY = 'RELATIONSHIP_TYPE_GROUP'
AND CA.OWNER_TABLE_NAME = 'HZ_RELATIONSHIP_TYPES'
AND CA.OWNER_TABLE_ID = RT.RELATIONSHIP_TYPE_ID
AND RR.LOOKUP_TYPE = 'HZ_RELATIONSHIP_ROLE'
AND RR.LOOKUP_CODE = RT.ROLE
AND RT.STATUS = 'A'
AND CA.START_DATE_ACTIVE <= SYSDATE
AND NVL(CA.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE

Columns