Product: | ASF - Sales Online |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT REL.RELATIONSHIP_ID
, SPARTY.PERSON_FIRST_NAME
, SPARTY.PERSON_LAST_NAME
, REL.SUBJECT_ID
, OPARTY.PERSON_FIRST_NAME
, OPARTY.PERSON_LAST_NAME
, REL.OBJECT_ID
, REL.PARTY_ID
, REL.RELATIONSHIP_CODE
, REL.START_DATE
, REL.END_DATE
, REL.LAST_UPDATE_DATE
, PARTY.LAST_UPDATE_DATE
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTY
, HZ_PARTIES OPARTY
, HZ_PARTIES SPARTY
WHERE REL.SUBJECT_ID = SPARTY.PARTY_ID
AND OPARTY.PARTY_TYPE = 'PERSON'
AND SPARTY.PARTY_TYPE = 'PERSON'
AND REL.OBJECT_ID = OPARTY.PARTY_ID
AND REL.PARTY_ID = PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.DIRECTIONAL_FLAG = 'F'
AND REL.STATUS = 'A'
AND PARTY.STATUS IN ('A'
, 'I')
AND OPARTY.STATUS IN ('A'
, 'I')
AND SPARTY.STATUS IN ('A'
, 'I')