[Home] [Help] [Dependency Information]
Object Name: | CSF_M_CURRENCIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A public view which may be useful for custom reporting or other data
requirements.
This view holds information about the currencies
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCESS_ID | NUMBER | Yes | The Unique Access Identifier | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
SYMBOL | VARCHAR2 | (12) | Symbol | |
NAME | VARCHAR2 | (80) | Yes | Name |
CURRENCY_FLAG | VARCHAR2 | (1) | Yes | A flag to indicate if the currency is a statistical unit or a currency |
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 | ||
ISSUING_TERRITORY_CODE | VARCHAR2 | (2) | ||
PRECISION | NUMBER | (1) | ||
EXTENDED_PRECISION | NUMBER | (2) | ||
MINIMUM_ACCOUNTABLE_UNIT | NUMBER | |||
ISO_FLAG | VARCHAR2 | (1) | Yes | |
DERIVE_EFFECTIVE | DATE | |||
DERIVE_TYPE | VARCHAR2 | (8) | ||
DERIVE_FACTOR | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCESS_ID
, CURRENCY_CODE
, SYMBOL
, NAME
, CURRENCY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ISSUING_TERRITORY_CODE
, PRECISION
, EXTENDED_PRECISION
, MINIMUM_ACCOUNTABLE_UNIT
, ISO_FLAG
, DERIVE_EFFECTIVE
, DERIVE_TYPE
, DERIVE_FACTOR
, DESCRIPTION
FROM APPS.CSF_M_CURRENCIES_V;
APPS.CSF_M_CURRENCIES_V is not referenced by any database object
|
|
|