SELECT T.CURRENCY_CODE, T.NAME, T.DESCRIPTION FROM FND_CURRENCIES_TL T,FND_CURRENCIES B WHERE B.CURRENCY_CODE = T.CURRENCY_CODE AND T.LANGUAGE = USERENV('LANG') AND SYSDATE BETWEEN NVL(B.START_DATE_ACTIVE,SYSDATE) AND NVL(B.END_DATE_ACTIVE,SYSDATE) AND NVL(B.CURRENCY_FLAG,'N') = 'Y' AND NVL(B.ENABLED_FLAG,'N') = 'Y'
SELECT T.CURRENCY_CODE
, T.NAME
, T.DESCRIPTION
FROM FND_CURRENCIES_TL T
, FND_CURRENCIES B
WHERE B.CURRENCY_CODE = T.CURRENCY_CODE
AND T.LANGUAGE = USERENV('LANG')
AND SYSDATE BETWEEN NVL(B.START_DATE_ACTIVE
, SYSDATE)
AND NVL(B.END_DATE_ACTIVE
, SYSDATE)
AND NVL(B.CURRENCY_FLAG
, 'N') = 'Y'
AND NVL(B.ENABLED_FLAG
, 'N') = 'Y'
|
|
|