VIEW: APPS.RCI_SIGNIFICANT_ACCT_V

Source

View Text - Preformatted

SELECT distinct natural_account_id as ID , account_name||' ('||natural_account_value||') ' as value from amw_fin_key_accounts_vl

View Text - HTML Formatted

SELECT DISTINCT NATURAL_ACCOUNT_ID AS ID
, ACCOUNT_NAME||' ('||NATURAL_ACCOUNT_VALUE||') ' AS VALUE
FROM AMW_FIN_KEY_ACCOUNTS_VL