VIEW: APPS.BEN_CWB_CURRENCY_LOV_V

Source

View Text - Preformatted

SELECT currency_code ID, currency_code || ' - ' || name Value from fnd_currencies_vl WHERE enabled_flag = 'Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) and currency_flag = 'Y'

View Text - HTML Formatted

SELECT CURRENCY_CODE ID
, CURRENCY_CODE || ' - ' || NAME VALUE
FROM FND_CURRENCIES_VL
WHERE ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)
AND CURRENCY_FLAG = 'Y'