[Home] [Help]
View: XNC_PVT_CUST_ACCOUNTS_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | This View retrieves the Customer Accounts for a given Party |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CUST_ACCOUNT_ID
, PARTY_ID
, ACCOUNT_NUMBER
, ACCOUNT_NAME
FROM HZ_CUST_ACCOUNTS
WHERE STATUS = 'A'
AND TRUNC(NVL(ACCOUNT_ACTIVATION_DATE
, SYSDATE)) <= TRUNC(SYSDATE)
AND TRUNC(NVL(ACCOUNT_TERMINATION_DATE
, SYSDATE)) >= TRUNC(SYSDATE)
Columns
Name |
CUST_ACCOUNT_ID |
PARTY_ID |
ACCOUNT_NUMBER |
ACCOUNT_NAME |