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

VIEW: APPS.QPR_SR_CURRENCY_RATES_V

Object Details
Object Name: QPR_SR_CURRENCY_RATES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Currency conversion rates


[View Source]

Columns
Name Datatype Length Mandatory Comments
FROM_CURRENCY VARCHAR2 (15) Yes From currency
TO_CURRENCY VARCHAR2 (15) Yes To currency
CONVERSION_DATE DATE
Yes Conversion date
CONVERSION_TYPE VARCHAR2 (30) Yes Conversion type
CONVERSION_RATE NUMBER
Yes Conversion rate
CONVERSION_CLASS CHAR (5)
Conversion class
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FROM_CURRENCY
,      TO_CURRENCY
,      CONVERSION_DATE
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      CONVERSION_CLASS
FROM APPS.QPR_SR_CURRENCY_RATES_V;

Dependencies

[top of page]

APPS.QPR_SR_CURRENCY_RATES_V references the following:

SchemaAPPS
SynonymGL_DAILY_RATES

APPS.QPR_SR_CURRENCY_RATES_V is not referenced by any database object