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

VIEW: APPS.GL_TRANSLATION_RATES

Object Details
Object Name: GL_TRANSLATION_RATES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_TRANSLATION_RATES
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
PERIOD_NAME VARCHAR2 (15) Yes Accounting period name
TO_CURRENCY_CODE VARCHAR2 (15) Yes To currency
ACTUAL_FLAG VARCHAR2 (1)
AVG_RATE NUMBER
Yes
EOP_RATE NUMBER
Yes
AVG_RATE_NUMERATOR NUMBER
Yes
EOP_RATE_NUMERATOR NUMBER
Yes
AVG_RATE_DENOMINATOR NUMBER

EOP_RATE_DENOMINATOR NUMBER

UPDATE_FLAG VARCHAR2 (1)
LAST_UPDATE_DATE VARCHAR2 (0)
LAST_UPDATED_BY VARCHAR2 (0)
CREATION_DATE VARCHAR2 (0)
CREATED_BY VARCHAR2 (0)
LAST_UPDATE_LOGIN VARCHAR2 (0)
ATTRIBUTE1 VARCHAR2 (0)
ATTRIBUTE2 VARCHAR2 (0)
ATTRIBUTE3 VARCHAR2 (0)
ATTRIBUTE4 VARCHAR2 (0)
ATTRIBUTE5 VARCHAR2 (0)
CONTEXT VARCHAR2 (0)
Query Text

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


SELECT SET_OF_BOOKS_ID
,      PERIOD_NAME
,      TO_CURRENCY_CODE
,      ACTUAL_FLAG
,      AVG_RATE
,      EOP_RATE
,      AVG_RATE_NUMERATOR
,      EOP_RATE_NUMERATOR
,      AVG_RATE_DENOMINATOR
,      EOP_RATE_DENOMINATOR
,      UPDATE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONTEXT
FROM APPS.GL_TRANSLATION_RATES;

Dependencies

[top of page]

APPS.GL_TRANSLATION_RATES references the following:

SchemaAPPS
SynonymGL_DAILY_RATES
SynonymGL_LEDGERS
SynonymGL_PERIOD_STATUSES
SynonymGL_ROW_MULTIPLIERS
APPS.GL_TRANSLATION_RATES is referenced by following:

SchemaAPPS
Package BodyAR_ARXINREV_XMLP_PKG - show dependent code
ViewCST_GL_TRANSLATION_VIEW