VIEW: APPS.XNB_PARTY_RELATIONSHIP_V

Source

View Text - Preformatted

SELECT PARTY_2.PARTY_ID PARENT_PARTY_ID, PARTY_2.PARTY_NAME PARENT_PARTY_NAME, RELATIONS.RELATIONSHIP_CODE PARENT_RELATIONSHIP_TYPE, RELATIONS.END_DATE END_DATE, RELATIONS.SUBJECT_ID SUBJECT_ID FROM HZ_RELATIONSHIPS RELATIONS, HZ_PARTIES PARTY_2 WHERE RELATIONS.OBJECT_ID = PARTY_2.PARTY_ID AND RELATIONS.RELATIONSHIP_CODE IN('EMPLOYEE_OF','SUBSIDIARY_OF') AND (RELATIONS.END_DATE IS NULL OR RELATIONS.END_DATE > SYSDATE) AND RELATIONS.STATUS = 'A'

View Text - HTML Formatted

SELECT PARTY_2.PARTY_ID PARENT_PARTY_ID
, PARTY_2.PARTY_NAME PARENT_PARTY_NAME
, RELATIONS.RELATIONSHIP_CODE PARENT_RELATIONSHIP_TYPE
, RELATIONS.END_DATE END_DATE
, RELATIONS.SUBJECT_ID SUBJECT_ID
FROM HZ_RELATIONSHIPS RELATIONS
, HZ_PARTIES PARTY_2
WHERE RELATIONS.OBJECT_ID = PARTY_2.PARTY_ID
AND RELATIONS.RELATIONSHIP_CODE IN('EMPLOYEE_OF'
, 'SUBSIDIARY_OF')
AND (RELATIONS.END_DATE IS NULL OR RELATIONS.END_DATE > SYSDATE)
AND RELATIONS.STATUS = 'A'