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]

TABLE: FII.EDW_CURR_CURRENCY_LSTG

Object Details

Object Name:	EDW_CURR_CURRENCY_LSTG
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.EDW_CURR_CURRENCY_LSTG
Subobject Name:
Status:	VALID

This is the staging table for the currency level. Before currency information is loaded into the warehouse, data is temporarily held in the staging table for verification and cleansing.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_CURR_CURRENCY_LSTG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	CURRENCY_PK

Columns

Name	Datatype	Length	Comments
ALL_FK_KEY	NUMBER		System generated foreign key to the top level of the currency dimension
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		Extended precision of the currency
MIN_ACCOUNT_UNIT	NUMBER		Minimum accountable unit for the currency
PRECISION	NUMBER		Maximum number of digits to the right of decimal point
REQUEST_ID	NUMBER		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ALL_FK	VARCHAR2	(40)	Foreign key to the top level of the currency dimension
COLLECTION_STATUS	VARCHAR2	(30)	Collection status code for the record
CURRENCY	VARCHAR2	(2000)	Currency code
CURRENCY_FLAG	VARCHAR2	(20)	Flag to indicate if the currency is a statistical unit or a currency
CURRENCY_PK	VARCHAR2	(20)	The unique identifier for currency
DERIVE_TYPE	VARCHAR2	(20)	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	(20)	Enabled Flag
ERROR_CODE	VARCHAR2	(2000)	Code used to store error messages
INSTANCE	VARCHAR2	(40)	Instance identifier
ISO_FLAG	VARCHAR2	(20)	Flag to indicate whether or not the currency is defined in ISO-4217
NAME	VARCHAR2	(2000)	Currency Name
OPERATION_CODE	VARCHAR2	(30)	Code used during warehouse collection
ROW_ID	ROWID	(10)	User defined attribute
SYMBOL	VARCHAR2	(20)	The symbol denoting the currency
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute
DATE_EFFECTIVE	DATE		The date when the currency code becomes active
DATE_END	DATE		The date when currency code expires
DELETION_DATE	DATE		Deletion date of the record
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.

Query Text

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


SELECT ALL_FK_KEY
,      DERIVE_FACTOR
,      EXT_PRECISION
,      MIN_ACCOUNT_UNIT
,      PRECISION
,      REQUEST_ID
,      ALL_FK
,      COLLECTION_STATUS
,      CURRENCY
,      CURRENCY_FLAG
,      CURRENCY_PK
,      DERIVE_TYPE
,      DESCRIPTION
,      ENABLED_FLAG
,      ERROR_CODE
,      INSTANCE
,      ISO_FLAG
,      NAME
,      OPERATION_CODE
,      ROW_ID
,      SYMBOL
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      DATE_EFFECTIVE
,      DATE_END
,      DELETION_DATE
,      DERIVE_EFFT_DATE
FROM FII.EDW_CURR_CURRENCY_LSTG;

Dependencies

[top of page]

FII.EDW_CURR_CURRENCY_LSTG does not reference any database object

FII.EDW_CURR_CURRENCY_LSTG is referenced by following:

APPS: EDW_CURR_CURRENCY_LSTG