VIEW: APPS.OKL_CURE_CUSTOMER_UV

Source

View Text - Preformatted

SELECT parties.party_name party_name, accounts.account_number party_id FROM HZ_CUST_ACCOUNTS ACCOUNTS,HZ_PARTIES PARTIES WHERE parties.party_id=accounts.party_id

View Text - HTML Formatted

SELECT PARTIES.PARTY_NAME PARTY_NAME
, ACCOUNTS.ACCOUNT_NUMBER PARTY_ID
FROM HZ_CUST_ACCOUNTS ACCOUNTS
, HZ_PARTIES PARTIES
WHERE PARTIES.PARTY_ID=ACCOUNTS.PARTY_ID