[Home] [Help]
View: BIS_CUSTOMERS_V
View Text
SELECT HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID ID
, HZ_PARTIES.PARTY_NAME VALUE
, HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID CUSTOMER_ID
, HZ_PARTIES.PARTY_NAME CUSTOMER_NAME
, HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER CUSTOMER_NUMBER
FROM HZ_CUST_ACCOUNTS
, HZ_PARTIES
WHERE HZ_CUST_ACCOUNTS.PARTY_ID = HZ_PARTIES.PARTY_ID
Columns
Name |
ID |
VALUE |
CUSTOMER_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |