SELECT A.FUND_ID ID, SHORT_NAME VALUE, DESCRIPTION, PARENT_FUND_ID PARENT_ID FROM OZF_FUNDS_ALL_TL A ,OZF_FUNDS_All_B B WHERE A.FUND_ID = B.FUND_ID AND LANGUAGE = USERENV ('LANG')
View Text - HTML Formatted
SELECT A.FUND_ID ID , SHORT_NAME VALUE , DESCRIPTION , PARENT_FUND_ID PARENT_ID FROM OZF_FUNDS_ALL_TL A , OZF_FUNDS_ALL_B B WHERE A.FUND_ID = B.FUND_ID AND LANGUAGE = USERENV ('LANG')