eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WSH_CARRIER_SITE_CONTACTS_V

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

View Text

SELECT REL.PARTY_ID
, ORG.ORG_CONTACT_ID
, HCP.CONTACT_POINT_ID
, ORG.PARTY_SITE_ID
, PARTY.PARTY_ID
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, ORG.CONTACT_NUMBER
, HCP.EMAIL_ADDRESS
, ORG.DECISION_MAKER_FLAG
, PARTY.PERSON_PRE_NAME_ADJUNCT
, ORG.JOB_TITLE_CODE
, PARTY.STATUS
FROM HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTY_REL
, HZ_ORG_CONTACTS ORG
, HZ_CONTACT_POINTS HCP
, HZ_PARTIES PARTY
WHERE REL.PARTY_ID = PARTY_REL.PARTY_ID
AND ORG.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND HCP.OWNER_TABLE_ID = PARTY_REL.PARTY_ID
AND HCP.CONTACT_POINT_TYPE = 'EMAIL'
AND PARTY.PARTY_ID = REL.SUBJECT_ID
AND PARTY.PARTY_TYPE = 'PERSON'
AND SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND DIRECTIONAL_FLAG = 'F'

Columns

Name
RELATION_PARTY_ID
ORG_CONTACT_ID
CONTACT_POINT_ID
CARRIER_SITE_ID
PERSON_ID
FIRST_NAME
LAST_NAME
CONTACT_NUMBER
EMAIL_ADDRESS
ACCEPTS_LOAD_TENDER
TITLE
JOB_TITLE
STATUS