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

VIEW: APPS.GLBV_CURRENCIES

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

View Type

A Business Intelligence System view


Currencies include Oracle Application predefined ISO currencies, user-defined non-ISO currencies, and the statistical currency. Every set of books is defined by a currency.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY_CODE VARCHAR2 (15) Yes Currency code
_LA:ENABLED_FLAG CHAR (58)
PRECISION NUMBER (1)
EXTENDED_PRECISION NUMBER (2)
MINIMUM_ACCOUNTABLE_UNIT NUMBER

SYMBOL VARCHAR2 (12)
START_EFFECTIVE_DATE DATE

END_EFFECTIVE_DATE DATE

EURO_EFFECTIVE_DATE DATE

_LA:EURO_CURRENCY_TYPE CHAR (55)
EURO_CONVERSION_FACTOR NUMBER

Query Text

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


SELECT CURRENCY_CODE
,      _LA:ENABLED_FLAG
,      PRECISION
,      EXTENDED_PRECISION
,      MINIMUM_ACCOUNTABLE_UNIT
,      SYMBOL
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      EURO_EFFECTIVE_DATE
,      _LA:EURO_CURRENCY_TYPE
,      EURO_CONVERSION_FACTOR
FROM APPS.GLBV_CURRENCIES;

Dependencies

[top of page]

APPS.GLBV_CURRENCIES references the following:

SchemaAPPS
SynonymFND_CURRENCIES

APPS.GLBV_CURRENCIES is not referenced by any database object