[Home] [Help] [Dependency Information]
Object Name: | MSD_SR_CURRENCY_CONVERSIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_SR_CURRENCY_CONVERSIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the Source View for Currency Conversions. This view would be applied to an Oracle Applications 11i instance from which the Currency Conversion information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_CURRENCY | VARCHAR2 | (15) | Yes | From Currency |
TO_CURRENCY | VARCHAR2 | (15) | Yes | To Currency |
CONVERSION_DATE | DATE | Yes | Convsersion Date | |
CONVERSION_TYPE | VARCHAR2 | (30) | Yes | Conversion Type |
CONVERSION_RATE | NUMBER | Yes | Conversion Rate | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | (15) | Yes | Created By |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Last Updated By |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Last Update Login |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_CURRENCY
, TO_CURRENCY
, CONVERSION_DATE
, CONVERSION_TYPE
, CONVERSION_RATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM APPS.MSD_SR_CURRENCY_CONVERSIONS_V;
APPS.MSD_SR_CURRENCY_CONVERSIONS_V is not referenced by any database object
|
|
|