DBA Data[Home] [Help]

VIEW: APPS.BIL_DIMV_CURRENCIES

Source

View Text - Preformatted

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_VL FLV WHERE FLV.LOOKUP_TYPE='REPORTING_CURRENCY' AND ENABLED_FLAG = 'Y' WITH READ ONLY
View Text - HTML Formatted

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_VL FLV
WHERE FLV.LOOKUP_TYPE='REPORTING_CURRENCY'
AND ENABLED_FLAG = 'Y' WITH READ ONLY