[Home] [Help]
View: WSH_CUSTOMER_PHONE
View Text
SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB ( PARTY.PARTY_NAME
, 1
, 50 ) CUSTOMER_NAME
, WPCP.AREA_CODE AREA_CODE
, WPCP.PHONE_NUMBER PHONE_NUMBER
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, WSH_PRIMARY_CUSTOMER_PHONE_V WPCP
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID = WPCP.CUSTOMER_ID (+)
Columns
Name |
CUSTOMER_ID |
CUSTOMER_NAME |
AREA_CODE |
PHONE_NUMBER |