VIEW: APPS.JTF_RS_PARTIES_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'