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

VIEW: APPS.BIL_DIMV_CURRENCIES

Object Details
Object Name: BIL_DIMV_CURRENCIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_CURRENCIES
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIL_DIMV_CURRENCIES - Dimension view used to provide descriptive information related to
currency codes.
.
Source is Oracle Applications Foundation schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code identifier
CURRENCY_NAME VARCHAR2 (80) Yes Currency Code name
CURRENCY_DESCRIPTION VARCHAR2 (240)
Currency Code description
COUNTRY_SHORT_NAME VARCHAR2 (2)
Territory short name
COUNTRY_FULL_NAME VARCHAR2 (0)
Territory description
ENABLED_FLAG VARCHAR2 (1) Yes Currency Code enabled flag
START_DATE_ACTIVE DATE

Currency Code start date active
END_DATE_ACTIVE DATE

Currency Code end date active
ID VARCHAR2 (30) Yes Currency Code identifier
VALUE VARCHAR2 (80) Yes Currency Code name
Query Text

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


SELECT CURRENCY_CODE
,      CURRENCY_NAME
,      CURRENCY_DESCRIPTION
,      COUNTRY_SHORT_NAME
,      COUNTRY_FULL_NAME
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ID
,      VALUE
FROM APPS.BIL_DIMV_CURRENCIES;

Dependencies

[top of page]

APPS.BIL_DIMV_CURRENCIES references the following:

SchemaAPPS
ViewFND_LOOKUP_VALUES_VL

APPS.BIL_DIMV_CURRENCIES is not referenced by any database object