[Home] [Help]
View: CS_NEW_ACCOUNT_RG_V
| Product: | CS - Service |
| Description: | New Account Infomation for Transfer Product |
| Implementation/DBA Data: |
APPS.CS_NEW_ACCOUNT_RG_V
|
View Text
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
Columns
| Name |
| PARTY_NAME |
| ACCOUNT_NUMBER |
| CUST_ACCOUNT_ID |