DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSD_CURRENCY_CONVERSIONS_V

Object Details
Object Name: MSD_CURRENCY_CONVERSIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_CURRENCY_CONVERSIONS_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.MSD_CURRENCY_CONVERSIONS_V references the following:

SchemaAPPS
SynonymMSD_CURRENCY_CONVERSIONS

APPS.MSD_CURRENCY_CONVERSIONS_V is not referenced by any database object