View: CSC_HZ_PARTY_RELATIONSHIPS_V

Product:	CSC - Customer Care
Description:	View of HZ_RELATIONSHIPS. View is used to get party relationship details.
Implementation/DBA Data:	APPS.CSC_HZ_PARTY_RELATIONSHIPS_V

View Text

SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY_REL.RELATIONSHIP_ID
, PARTY.PARTY_NUMBER
, SUB_PARTY.PARTY_ID
, OBJ_PARTY.PARTY_ID
, OBJ_PARTY.PARTY_TYPE
, SUB_PARTY.PARTY_TYPE
, PARTY_REL.RELATIONSHIP_TYPE
, OBJ_PARTY.PARTY_NAME
, SUB_PARTY.PARTY_NAME
, ORG_CONT.JOB_TITLE
, OBJ_PARTY.LAST_UPDATE_DATE
, PARTY_REL.START_DATE
, PARTY_REL.END_DATE
, PARTY_REL.STATUS
, PARTY_REL.COMMENTS
, PARTY_REL.DIRECTIONAL_FLAG
, PARTY_REL.RELATIONSHIP_CODE
, L.MEANING
FROM HZ_PARTIES PARTY
, HZ_PARTIES SUB_PARTY
, HZ_PARTIES OBJ_PARTY
, HZ_RELATIONSHIPS PARTY_REL
, AR_LOOKUPS L
, HZ_ORG_CONTACTS ORG_CONT
WHERE PARTY.PARTY_ID(+) = PARTY_REL.PARTY_ID
AND (PARTY_REL.SUBJECT_ID = SUB_PARTY.PARTY_ID
AND PARTY_REL.OBJECT_ID = OBJ_PARTY.PARTY_ID)
AND ORG_CONT.PARTY_RELATIONSHIP_ID = PARTY_REL.RELATIONSHIP_ID
AND L.LOOKUP_TYPE = 'PARTY_RELATIONS_TYPE'
AND L.LOOKUP_CODE = PARTY_REL.RELATIONSHIP_CODE --
AND NVL(PARTY_REL.START_DATE
, SYSDATE-1) < SYSDATE --
AND NVL(PARTY_REL.END_DATE
, SYSDATE+1) > SYSDATE

Columns