eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.FIIBV_CURR_CURRENCY_LCV

Object Details

Object Name:	FIIBV_CURR_CURRENCY_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FIIBV_CURR_CURRENCY_LCV
Subobject Name:
Status:	VALID

View Type

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

FIIBV_CURR_CURRENCY_LCV is the base view for currency level of currency dimension

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CURRENCY_PK	VARCHAR2	(15)	Yes	The unique identifier for currency
ALL_FK	CHAR	(3)		Foreign key to the top level of the currency dimension
CURRENCY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the currency is a statistical unit or a currency
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 specialrelationship) are possible values.
DESCRIPTION	VARCHAR2	(240)		Currency description
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled Flag
INSTANCE	VARCHAR2	(40)		Instance identifier
ISO_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether or not the currency is defined in ISO-4217
NAME	VARCHAR2	(80)	Yes	Currency Name
CURRENCY	VARCHAR2	(15)	Yes	Currency code
SYMBOL	VARCHAR2	(12)		The symbol denoting the currency
DATE_EFFECTIVE	DATE			The date when the currency code becomes active
DATE_END	DATE			The date when currency code expires
DERIVE_EFFT_DATE	DATE			The date from which this currency's value becomes derived from the related currency. If thisvalue is null or later than the computation date, then the other derive_ columns are undefined.
DERIVE_FACTOR	NUMBER			Multiple applied to the base currency to derive this currency. Only used for the derived currency in a relationship.
EXT_PRECISION	NUMBER	(2)		Extended precision of the currency
MIN_ACCOUNT_UNIT	NUMBER			Minimum accountable unit for the currency
PRECISION	NUMBER	(1)		Maximum number of digits to the right of decimal point
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
_DF:FCU:_EDW	CHAR	(26)		This column is for internal use only
_DF:JFU:_EDW	CHAR	(28)		This column is for internal use only

Query Text

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


SELECT CURRENCY_PK
,      ALL_FK
,      CURRENCY_FLAG
,      DERIVE_TYPE
,      DESCRIPTION
,      ENABLED_FLAG
,      INSTANCE
,      ISO_FLAG
,      NAME
,      CURRENCY
,      SYMBOL
,      DATE_EFFECTIVE
,      DATE_END
,      DERIVE_EFFT_DATE
,      DERIVE_FACTOR
,      EXT_PRECISION
,      MIN_ACCOUNT_UNIT
,      PRECISION
,      LAST_UPDATE_DATE
,      _DF:FCU:_EDW
,      _DF:JFU:_EDW
FROM APPS.FIIBV_CURR_CURRENCY_LCV;

Dependencies

[top of page]

APPS.FIIBV_CURR_CURRENCY_LCV references the following:

APPS: EDW_INSTANCE - show dependent code; FND_CURRENCIES; FND_CURRENCIES_TL

APPS.FIIBV_CURR_CURRENCY_LCV is referenced by following:

APPS: FII_CURR_CURRENCY_LCV