[Home] [Help]
View: WSH_CARRIER_CONTACT_INFO_V
View Text
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 ORDER BY PRIMARY_FLAG DESC
Columns
Name |
RELATION_PARTY_ID |
CONTACT_POINT_ID |
COUNTRY_CODE |
AREA_CODE |
EXTENSION |
PHONE_NUMBER |
CONTACT_TYPE |
PRIMARY |
ACTIVE |