View: ASF_RELS_EO_V

View Text

SELECT REL.RELATIONSHIP_ID
, OPARTY.PARTY_TYPE
, SPARTY.PARTY_TYPE
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES OPARTY
, HZ_PARTIES SPARTY
WHERE REL.SUBJECT_ID = SPARTY.PARTY_ID
AND REL.OBJECT_ID = OPARTY.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 SPARTY.STATUS IN ('A'
, 'I')
AND OPARTY.STATUS IN ('A'
, 'I')

Columns