View: JTF_RS_PARTIES_VL

Product:	JTF - CRM Foundation
Description:	The details of parties that can be imported as resource or are already present as resource
Implementation/DBA Data:	APPS.JTF_RS_PARTIES_VL

View Text

SELECT PARTY.PARTY_ID PARTY_ID
, PARTY.PARTY_NUMBER PARTY_NUMBER
, PARTY.PARTY_NAME PARTY_NAME
, PARTY.PARTY_TYPE PARTY_TYPE
, CT_POINT.EMAIL_ADDRESS EMAIL
, CT_POINT1.PHONE_AREA_CODE||CT_POINT1.PHONE_NUMBER PHONE
, CT_POINT1.PHONE_EXTENSION PHONE_EXTENSION
, CT_POINT1.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, TO_NUMBER(NULL) ORG_ID
, NULL ORG_NAME
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS CT_POINT
, HZ_CONTACT_POINTS CT_POINT1
WHERE PARTY.PARTY_TYPE <> 'ORGANIZATION'
AND PARTY.PARTY_TYPE <> 'GROUP'
AND CT_POINT.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
AND CT_POINT.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
AND CT_POINT.PRIMARY_FLAG (+)= 'Y'
AND CT_POINT.STATUS (+)= 'A'
AND CT_POINT.CONTACT_POINT_TYPE (+)= 'EMAIL'
AND CT_POINT1.OWNER_TABLE_NAME (+)= 'HZ_PARTIES'
AND CT_POINT1.OWNER_TABLE_ID (+)= PARTY.PARTY_ID
AND CT_POINT1.PRIMARY_FLAG (+)= 'Y'
AND CT_POINT1.STATUS (+)= 'A'
AND CT_POINT1.CONTACT_POINT_TYPE (+)= 'PHONE'

Columns