[Home] [Help] [Dependency Information]
Object Name: | MSD_CURRENCY_CONVERSIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_CURRENCY_CONVERSIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view specifies the Conversion Rate between two currencies. The fact table underlying this would be populated with the currency conversion rate for the converion type specified in the profile at the planning server level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_CURRENCY | VARCHAR2 | (15) | Yes | Currency from which the conersion takes place. |
TO_CURRENCY | VARCHAR2 | (15) | Yes | Currency to which the conersion takes place. |
CONVERSION_DATE | DATE | Yes | The date of currency conversion. | |
CONVERSION_RATE | NUMBER | Yes | The currency conversion rate. |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_CURRENCY
, TO_CURRENCY
, CONVERSION_DATE
, CONVERSION_RATE
FROM APPS.MSD_CURRENCY_CONVERSIONS_V;
APPS.MSD_CURRENCY_CONVERSIONS_V is not referenced by any database object
|
|
|