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'
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'
|
|
|