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

VIEW: APPS.ASO_I_CURRENCIES_V

Object Details
Object Name: ASO_I_CURRENCIES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewASO.ASO_I_CURRENCIES_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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY_CODE VARCHAR2 (15) Yes Currency code
NAME VARCHAR2 (80) Yes Currency name
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
START_DATE_ACTIVE DATE

The date when the currency code becomes active
END_DATE_ACTIVE DATE

The date when the currency code expires
DERIVE_TYPE VARCHAR2 (8)
Indicates whether the currency has a special relationship with other currencies. Currently, only EURO (Euro currency), EMU (European Monetary Union currency), and NULL (no special relationship) are possible values.
DERIVE_EFFECTIVE DATE

The date from which this currency's value becomes derived from the related currency. If this value is null or later than the computation date, then the other derive_ columns are undefined.
Query Text

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


SELECT CURRENCY_CODE
,      NAME
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DERIVE_TYPE
,      DERIVE_EFFECTIVE
FROM APPS.ASO_I_CURRENCIES_V;

Dependencies

[top of page]

APPS.ASO_I_CURRENCIES_V references the following:

SchemaAPPS
ViewFND_CURRENCIES_VL

APPS.ASO_I_CURRENCIES_V is not referenced by any database object