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_FACTS1_RUN

Object Details

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

Stores the periods and status for which the FACTS I report was run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_FACTS1_RUN_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID FISCAL_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of books identifier
FISCAL_YEAR	NUMBER	(15)	Yes	Fiscal year
PROCESS_DATE	DATE			Processed date
RUN_FED_FLAG	VARCHAR2	(1)		Flag to denote whether Federal Accounts Creation process was run
STATUS	VARCHAR2	(1)		Status of the process
TABLE_INDICATOR	VARCHAR2	(1)		Indicates whether new tables or old tables are used
JC_RUN_MONTH	NUMBER			Month the Journal Creation process was run
PERIOD_NUM	NUMBER	(15)		Period number
JE_HEADER_ID	NUMBER			Journal header identifier
BEGIN_BAL_DIFF_FLAG	VARCHAR2	(1)		Beginning balance difference flag
POSTED_DATE	DATE			Journal posted date

Query Text

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


SELECT SET_OF_BOOKS_ID
,      FISCAL_YEAR
,      PROCESS_DATE
,      RUN_FED_FLAG
,      STATUS
,      TABLE_INDICATOR
,      JC_RUN_MONTH
,      PERIOD_NUM
,      JE_HEADER_ID
,      BEGIN_BAL_DIFF_FLAG
,      POSTED_DATE
FROM FV.FV_FACTS1_RUN;

Dependencies

[top of page]

FV.FV_FACTS1_RUN does not reference any database object

FV.FV_FACTS1_RUN is referenced by following:

APPS: FV_FACTS1_RUN