VIEW: APPS.FII_CUST_V

Source

View Text - Preformatted

SELECT PARTY_ID ID, PARTY_NAME VALUE from HZ_PARTIES hz WHERE exists (select 1 from HZ_CUST_ACCOUNTS hza where hz.party_id = hza.party_id) UNION ALL SELECT -2 ID, FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER') VALUE FROM DUAL

View Text - HTML Formatted

SELECT PARTY_ID ID
, PARTY_NAME VALUE
FROM HZ_PARTIES HZ
WHERE EXISTS (SELECT 1
FROM HZ_CUST_ACCOUNTS HZA
WHERE HZ.PARTY_ID = HZA.PARTY_ID) UNION ALL SELECT -2 ID
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER') VALUE
FROM DUAL