FND Design Data [Home] [Help]

View: FII_CUST_ACCTS_V

Product: FII - Financial Intelligence
Description: This view contains the Party Name and Customer Account Number(s) for the FII view of Customer Account Dimension.
Implementation/DBA Data: ViewAPPS.FII_CUST_ACCTS_V
View Text

SELECT HZA.CUST_ACCOUNT_ID
, HZA.ACCOUNT_NUMBER
FROM HZ_CUST_ACCOUNTS HZA UNION ALL SELECT -2
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER')
FROM DUAL

Columns

Name
ID
VALUE