FND Design Data [Home] [Help]

View: OKC_KOL_CURRENCIES_V

Product: OKC - Contracts Core
Description: Displays active currency codes that are enabled for use at your site. Any currency code can be selected for a contract creation.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT FCL.CURRENCY_CODE CURRENCY_CODE
, FCL.DESCRIPTION DESCRIPTION
, CURRENCY_CODE||DESCRIPTION SEARCH
FROM FND_CURRENCIES_VL FCL
WHERE ENABLED_FLAG = 'Y'
AND (SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)) ORDER BY 1

Columns

Name
CURRENCY_CODE
DESCRIPTION
SEARCH