VIEW: APPS.WSH_CARRIER_CONTACTS_V

Source

View Text - Preformatted

SELECT hr.party_id, hr.object_id, hr.subject_id, hp.person_pre_name_adjunct, hp.person_first_name, hp.person_last_name, hp.status FROM hz_parties hp, hz_relationships hr WHERE hr.subject_id = hp.party_id and subject_table_name = 'HZ_PARTIES' and object_table_name = 'HZ_PARTIES' and directional_flag = 'F' and NOT EXISTS ( SELECT 'exists' FROM hz_org_contacts org WHERE org.party_relationship_id = hr.relationship_id AND org.party_site_id IS NOT NULL )

View Text - HTML Formatted

SELECT HR.PARTY_ID
, HR.OBJECT_ID
, HR.SUBJECT_ID
, HP.PERSON_PRE_NAME_ADJUNCT
, HP.PERSON_FIRST_NAME
, HP.PERSON_LAST_NAME
, HP.STATUS
FROM HZ_PARTIES HP
, HZ_RELATIONSHIPS HR
WHERE HR.SUBJECT_ID = HP.PARTY_ID
AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F'
AND NOT EXISTS ( SELECT 'EXISTS'
FROM HZ_ORG_CONTACTS ORG
WHERE ORG.PARTY_RELATIONSHIP_ID = HR.RELATIONSHIP_ID
AND ORG.PARTY_SITE_ID IS NOT NULL )