[Home] [Help]
View: WSH_CONTACT_PHONE
View Text
SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID CONTACT_ID
, ACCT_ROLE.CUST_ACCOUNT_ID CUSTOMER_ID
, ACCT_ROLE.CUST_ACCT_SITE_ID ADDRESS_ID
, SUBSTRB ( PARTY.PERSON_LAST_NAME
, 1
, 50) LAST_NAME
, SUBSTRB ( PARTY.PERSON_FIRST_NAME
, 1
, 40) FIRST_NAME
, ORG_CONT.JOB_TITLE JOB_TITLE
, WPCP.AREA_CODE AREA_CODE
, WPCP.PHONE_NUMBER PHONE_NUMBER
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_ORG_CONTACTS ORG_CONT
, HZ_RELATIONSHIPS REL
, HZ_CUST_ACCOUNTS ROLE_ACCT
, WSH_PRIMARY_CONTACT_PHONE_V WPCP
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = WPCP.CONTACT_ID (+)
Columns
Name |
CONTACT_ID |
CUSTOMER_ID |
ADDRESS_ID |
LAST_NAME |
FIRST_NAME |
JOB_TITLE |
AREA_CODE |
PHONE_NUMBER |