VIEW: APPS.FII_CUST_ACCOUNTS_V

Source

View Text - Preformatted

SELECT hza.cust_account_id ID, hza.account_number VALUE, party_id party_id FROM hz_cust_accounts hza UNION ALL SELECT -2 ID, FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER') VALUE, -2 party_id from dual

View Text - HTML Formatted

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