View: JTF_RS_PTNR_MIGR_VL

Product:	JTF - CRM Foundation
Description:	Stores specific partner related data used for internal migration.
Implementation/DBA Data:	APPS.JTF_RS_PTNR_MIGR_VL

View Text

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'

Columns