VIEW: APPS.HZ_RELATIONSHIP_GROUPINGS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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