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: FV.FV_FACTS_RUN

Object Details

Object Name:	FV_FACTS_RUN
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_FACTS_RUN
Subobject Name:
Status:	VALID

FV_FACTS_RUN stores the counter information for FACTS file submission. It also stores the MAF Sequence Number for the FACTS Bulk file.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TREASURY_SYMBOL	VARCHAR2	(35)	Yes	Treasury symbol for which process is run
FACTS_RUN_QUARTER	NUMBER	(1)	Yes	Quarter for which FACTS process is run
FACTS_RUN_YEAR	NUMBER	(4)	Yes	Year for which FACTS process is run.
MAF_SEQ_NUM	NUMBER	(15)	Yes	MAF sequence number
LAST_RUN_DATE	DATE			Last date FACTS process was run
TREASURY_SYMBOL_ID	NUMBER	(15)	Yes	Treasury symbol identifier
FACTS_RUN_PERIOD	NUMBER	(15)		Oracle Internal use only - reserved for future use

Query Text

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


SELECT TREASURY_SYMBOL
,      FACTS_RUN_QUARTER
,      FACTS_RUN_YEAR
,      MAF_SEQ_NUM
,      LAST_RUN_DATE
,      TREASURY_SYMBOL_ID
,      FACTS_RUN_PERIOD
FROM FV.FV_FACTS_RUN;

Dependencies

[top of page]

FV.FV_FACTS_RUN does not reference any database object

FV.FV_FACTS_RUN is referenced by following:

APPS: FV_FACTS_RUN