eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.GLFV_GL_PERIOD_EXCHANGE_RATES

Object Details

Object Name:	GLFV_GL_PERIOD_EXCHANGE_RATES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GLFV_GL_PERIOD_EXCHANGE_RATES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

General Ledger period exchange rates are average, period-end, and revaluation conversion rates defined between any two currencies.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ID	NUMBER	(15)	Yes
LEDGER_NAME	VARCHAR2	(30)	Yes
PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period name
TO_CURRENCY	VARCHAR2	(15)	Yes	To currency
BALANCE_TYPE	VARCHAR2	(80)	Yes
PERIOD_AVERAGE_RATE	NUMBER		Yes	Currency conversion rate
PERIOD_END_RATE	NUMBER		Yes	Currency conversion rate

Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      PERIOD_NAME
,      TO_CURRENCY
,      BALANCE_TYPE
,      PERIOD_AVERAGE_RATE
,      PERIOD_END_RATE
FROM APPS.GLFV_GL_PERIOD_EXCHANGE_RATES;

Dependencies

[top of page]

APPS.GLFV_GL_PERIOD_EXCHANGE_RATES references the following:

APPS: GL_DAILY_RATES; GL_LEDGERS; GL_LOOKUPS; GL_PERIOD_STATUSES; GL_ROW_MULTIPLIERS

APPS.GLFV_GL_PERIOD_EXCHANGE_RATES is not referenced by any database object