View: QA_HZ_PARTY_RELATIONSHIPS_V

Product:	QA - Quality
Description:	TCA obsoleted the hz_party_relationships view in R12. This is a replacement to help make the uptake easier.
Implementation/DBA Data:	APPS.QA_HZ_PARTY_RELATIONSHIPS_V

View Text

SELECT RELATIONSHIP_ID PARTY_RELATIONSHIP_ID
, SUBJECT_ID
, OBJECT_ID
, PARTY_ID
, RELATIONSHIP_CODE PARTY_RELATIONSHIP_TYPE
, 'N' DIRECTIONAL_FLAG
, COMMENTS
, START_DATE
, END_DATE
, STATUS
, OBJECT_VERSION_NUMBER
FROM HZ_RELATIONSHIPS
WHERE SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F'

Columns