VIEW: APPS.JTF_RS_PTNR_MIGR_VL

Source

View Text - Preformatted

SELECT a.party_id party_id,a.party_name,a.party_type,b.relationship_code from hz_parties a, hz_relationships b WHERE ((a.party_type = 'ORGANIZATION') and (a.party_id = b.subject_id) or (a.party_type = 'PARTY_RELATIONSHIP') and (a.party_id = b.party_id)) AND b.RELATIONSHIP_CODE IN ('PARTNER_OF', 'VAD_OF', 'VAD_VENDOR_OF', 'THIRD_PARTY_FOR', 'INDIRECTLY_MANAGES_CUSTOMER', 'CUSTOMER_INDIRECTLY_MANAGED_BY') AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND b.DIRECTIONAL_FLAG = 'F'

View Text - HTML Formatted

SELECT A.PARTY_ID PARTY_ID
, A.PARTY_NAME
, A.PARTY_TYPE
, B.RELATIONSHIP_CODE
FROM HZ_PARTIES A
, HZ_RELATIONSHIPS B
WHERE ((A.PARTY_TYPE = 'ORGANIZATION')
AND (A.PARTY_ID = B.SUBJECT_ID) OR (A.PARTY_TYPE = 'PARTY_RELATIONSHIP')
AND (A.PARTY_ID = B.PARTY_ID))
AND B.RELATIONSHIP_CODE IN ('PARTNER_OF'
, 'VAD_OF'
, 'VAD_VENDOR_OF'
, 'THIRD_PARTY_FOR'
, 'INDIRECTLY_MANAGES_CUSTOMER'
, 'CUSTOMER_INDIRECTLY_MANAGED_BY')
AND B.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND B.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND B.DIRECTIONAL_FLAG = 'F'