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