[Home] [Help]
VIEW: APPS.CS_NEW_ACCOUNT_RG_V
Source
View Text - Preformatted
SELECT HZP.party_name , HZCUST.account_number , HZCUST.cust_account_id FROM hz_parties HZP, hz_cust_accounts HZCUST WHERE HZP.party_id = HZCUST.party_id
View Text - HTML Formatted
SELECT HZP.PARTY_NAME
, HZCUST.ACCOUNT_NUMBER
, HZCUST.CUST_ACCOUNT_ID
FROM HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCUST
WHERE HZP.PARTY_ID = HZCUST.PARTY_ID