DBA Data[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