View: WSH_CARRIER_CONTACTS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_CARRIER_CONTACTS_V

View Text

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 )

Columns