View: ASF_CNT_ORG_RELS_VO_V

View Text

SELECT REL.RELATIONSHIP_ID
, REL.SUBJECT_ID
, SPARTY.PERSON_FIRST_NAME
, SPARTY.PERSON_LAST_NAME
, CONT.ORG_CONTACT_ID
, CONT.JOB_TITLE
, REL.OBJECT_ID
, OPARTY.PARTY_NAME
, REL.PARTY_ID
, REL.RELATIONSHIP_CODE
, REL.START_DATE
, REL.END_DATE
, CONT.DECISION_MAKER_FLAG
, CONT.REFERENCE_USE_FLAG
, REL.LAST_UPDATE_DATE
, PARTY.LAST_UPDATE_DATE
, CONT.LAST_UPDATE_DATE
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES SPARTY
, HZ_ORG_CONTACTS CONT
, HZ_PARTIES OPARTY
, HZ_PARTIES PARTY
WHERE REL.OBJECT_ID = OPARTY.PARTY_ID
AND SPARTY.PARTY_TYPE = 'PERSON'
AND OPARTY.PARTY_TYPE = 'ORGANIZATION'
AND REL.RELATIONSHIP_ID = CONT.PARTY_RELATIONSHIP_ID
AND REL.SUBJECT_ID = SPARTY.PARTY_ID
AND REL.PARTY_ID = PARTY.PARTY_ID
AND REL.STATUS = 'A'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG = 'F'
AND PARTY.STATUS IN ('A'
, 'I')
AND OPARTY.STATUS IN ('A'
, 'I')
AND SPARTY.STATUS IN ('A'
, 'I')
AND CONT.STATUS IN ('A'
, 'I')

Columns