[Home] [Help]
View: BIL_DIMV_CURRENCIES
View Text
SELECT FLV.LOOKUP_CODE
, FLV.MEANING
, FLV.DESCRIPTION
, FLV.TERRITORY_CODE
, NULL
, FLV.ENABLED_FLAG
, FLV.START_DATE_ACTIVE
, FLV.END_DATE_ACTIVE
, FLV.LOOKUP_CODE
, FLV.MEANING
FROM FND_LOOKUP_VALUES FLV
WHERE FLV.LOOKUP_TYPE='REPORTING_CURRENCY'
AND ENABLED_FLAG = 'Y' WITH READ ONLY
Columns
Name |
CURRENCY_CODE |
CURRENCY_NAME |
CURRENCY_DESCRIPTION |
COUNTRY_SHORT_NAME |
COUNTRY_FULL_NAME |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
ID |
VALUE |