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: TableFV.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: TablespaceAPPS_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:

SchemaAPPS
SynonymFV_FACTS_RUN