DBA Data[Home] [Help]

VIEW: APPS.BIM_BUDGET_NAME_V

Source

View Text - Preformatted

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')