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
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
|
|
|