VIEW: APPS.WSH_CARRIER_SITECONTACT_INFO_V

Source

View Text - Preformatted

SELECT HP.PARTY_ID, HCP.CONTACT_POINT_ID, HCP.PHONE_COUNTRY_CODE, HCP.PHONE_AREA_CODE, HCP.PHONE_EXTENSION, HCP.PHONE_NUMBER, HCP.PHONE_LINE_TYPE, HCP.PRIMARY_FLAG, HCP.STATUS FROM HZ_CONTACT_POINTS HCP, HZ_PARTIES HP WHERE HCP.OWNER_TABLE_NAME = 'HZ_PARTIES' AND HCP.OWNER_TABLE_ID = HP.PARTY_ID AND HCP.CONTACT_POINT_TYPE = 'PHONE'

View Text - HTML Formatted

SELECT HP.PARTY_ID
, HCP.CONTACT_POINT_ID
, HCP.PHONE_COUNTRY_CODE
, HCP.PHONE_AREA_CODE
, HCP.PHONE_EXTENSION
, HCP.PHONE_NUMBER
, HCP.PHONE_LINE_TYPE
, HCP.PRIMARY_FLAG
, HCP.STATUS
FROM HZ_CONTACT_POINTS HCP
, HZ_PARTIES HP
WHERE HCP.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND HCP.OWNER_TABLE_ID = HP.PARTY_ID
AND HCP.CONTACT_POINT_TYPE = 'PHONE'