[Home] [Help]
View: FII_CUSTOMERS_V
Product: | FII - Financial Intelligence |
Description: | Internal view used to support customer dimension in DBI. |
Implementation/DBA Data: |
APPS.FII_CUSTOMERS_V
|
View Text
SELECT PARTY_ID
, PARTY_NAME
, -999 PARENT_ID
FROM HZ_PARTIES HZ
WHERE EXISTS (SELECT 1
FROM HZ_CUST_ACCOUNTS HZA
WHERE HZ.PARTY_ID = HZA.PARTY_ID)
Columns