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

VIEW: APPS.AS_PERIOD_RATES_V

Object Details
Object Name: AS_PERIOD_RATES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_PERIOD_RATES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

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
PERIOD_SET_NAME VARCHAR2 (15)
Accounting calendar name
PERIOD_NAME VARCHAR2 (15)
System generated accounting period name
PERIOD_TYPE VARCHAR2 (15)
Accounting period type
FROM_CURRENCY VARCHAR2 (15)
From currency
TO_CURRENCY VARCHAR2 (15)
To currency
MAP_DATE_TYPE CHAR (1)
Map Date Type
CONVERSION_DATE DATE

Date on which accounting period begins
CONVERSION_RATE NUMBER

Currency conversion rate
CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
STATUS_CODE VARCHAR2 (1)
Daily balances up to date flag
UPDATEABLE_FLAG VARCHAR2 (1)
If daily rates are updateable from OSM for this mapping.
DELETEABLE_FLAG VARCHAR2 (1)
If daily rates are deleteable from OSM for this mapping.
Query Text

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


SELECT PERIOD_SET_NAME
,      PERIOD_NAME
,      PERIOD_TYPE
,      FROM_CURRENCY
,      TO_CURRENCY
,      MAP_DATE_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE
,      STATUS_CODE
,      UPDATEABLE_FLAG
,      DELETEABLE_FLAG
FROM APPS.AS_PERIOD_RATES_V;

Dependencies

[top of page]

APPS.AS_PERIOD_RATES_V references the following:

SchemaAPPS
SynonymAS_MC_TYPE_MAPPINGS
SynonymGL_DAILY_RATES
SynonymGL_PERIODS

APPS.AS_PERIOD_RATES_V is not referenced by any database object