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

TABLE: FV.FV_FACTS_REPORT_T2

Object Details
Object Name: FV_FACTS_REPORT_T2
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_FACTS_REPORT_T2
Subobject Name:
Status: VALID


FV_FACTS_REPORT_T2 is a temporary work table populated with summary data used in FACTS report generation.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_FACTS_REPORT_T2_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCCID
FV_FACTS_REPORT_T2_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSET_OF_BOOKS_ID
ColumnFISCAL_YEAR
ColumnREPORTED_STATUS
ColumnFUND_GROUP
ColumnDEPT_ID
ColumnBUREAU_ID
ColumnD_C_INDICATOR
Columns
Name Datatype Length Mandatory Comments
FUND_GROUP NUMBER (4) Yes Fund group
ACCOUNT_NUMBER VARCHAR2 (30) Yes Account number
DEPT_ID VARCHAR2 (2) Yes Department identifier
BUREAU_ID VARCHAR2 (2) Yes Bureau identifier
D_C_INDICATOR VARCHAR2 (1) Yes Debit or Credit indicator
AMOUNT NUMBER
Yes Net amount for General Ledger account
BUSINESS_LINE NUMBER (2)
Business line type including program, substantial commercial activity, bureau, agency, corporation, department, or group of unrelated small entities
ELIMINATIONS_DEPT VARCHAR2 (6)
Eliminations department
G_NG_INDICATOR VARCHAR2 (1)
Government or Nongovernment indicator
SET_OF_BOOKS_ID NUMBER
Yes Set of Books identifier
RECORD_CATEGORY VARCHAR2 (25)
Record category
FISCAL_YEAR NUMBER (4)
Fiscal year
REPORTED_STATUS VARCHAR2 (1)
Reported status
USSGL_ACCOUNT VARCHAR2 (4)
USSGL account
EXCH_NON_EXCH VARCHAR2 (1)
Exchange or nonexchange
CUST_NON_CUST VARCHAR2 (1)
Custodial or noncustodial
BUDGET_SUBFUNCTION VARCHAR2 (3)
Budget subfunction
FUND_VALUE VARCHAR2 (30)
Fund value
CCID NUMBER (15)
Not currently used
BEGINNING_BALANCE NUMBER

Not currently used
ACCOUNT_TYPE VARCHAR2 (1)
Not currently used
RECIPIENT_NAME VARCHAR2 (360)
Not currently used
SEGMENT1 VARCHAR2 (30)
Key flexfield segment
SEGMENT2 VARCHAR2 (30)
Key flexfield segment
SEGMENT3 VARCHAR2 (30)
Key flexfield segment
SEGMENT4 VARCHAR2 (30)
Key flexfield segment
SEGMENT5 VARCHAR2 (30)
Key flexfield segment
SEGMENT6 VARCHAR2 (30)
Key flexfield segment
SEGMENT7 VARCHAR2 (30)
Key flexfield segment
SEGMENT8 VARCHAR2 (30)
Key flexfield segment
SEGMENT9 VARCHAR2 (30)
Key flexfield segment
SEGMENT10 VARCHAR2 (30)
Key flexfield segment
SEGMENT11 VARCHAR2 (30)
Key flexfield segment
SEGMENT12 VARCHAR2 (30)
Key flexfield segment
SEGMENT13 VARCHAR2 (30)
Key flexfield segment
SEGMENT14 VARCHAR2 (30)
Key flexfield segment
SEGMENT15 VARCHAR2 (30)
Key flexfield segment
SEGMENT16 VARCHAR2 (30)
Key flexfield segment
SEGMENT17 VARCHAR2 (30)
Key flexfield segment
SEGMENT18 VARCHAR2 (30)
Key flexfield segment
SEGMENT19 VARCHAR2 (30)
Key flexfield segment
SEGMENT20 VARCHAR2 (30)
Key flexfield segment
SEGMENT21 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT22 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT23 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT24 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT25 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT26 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT27 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT28 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT29 VARCHAR2 (30)
Accounting Flexfield segment
SEGMENT30 VARCHAR2 (30)
Accounting Flexfield segment
DR_AMOUNT NUMBER

DR amount used in FACTS I Trial Balance
CR_AMOUNT NUMBER

CR amount used in FACTS I Trial Balance
JE_SOURCE VARCHAR2 (25)
Journal source
JE_CATEGORY VARCHAR2 (25)
Journal Category
GOVT_NON_GOVT VARCHAR2 (1)
Government Non Government Indicator
FACTS_ATTRIBUTE VARCHAR2 (150)
Facts Attribute
REFERENCE_1 VARCHAR2 (240)
Reference_1 from Journal Line
REFERENCE_2 VARCHAR2 (240)
Reference_2 from Journal Line
REFERENCE_3 VARCHAR2 (240)
Reference_3 from Journal Line
REFERENCE_5 VARCHAR2 (240)
Reference_5 from Journal Line
REFERENCE_7 VARCHAR2 (240)
Reference_7 from Journal Line
Query Text

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


SELECT FUND_GROUP
,      ACCOUNT_NUMBER
,      DEPT_ID
,      BUREAU_ID
,      D_C_INDICATOR
,      AMOUNT
,      BUSINESS_LINE
,      ELIMINATIONS_DEPT
,      G_NG_INDICATOR
,      SET_OF_BOOKS_ID
,      RECORD_CATEGORY
,      FISCAL_YEAR
,      REPORTED_STATUS
,      USSGL_ACCOUNT
,      EXCH_NON_EXCH
,      CUST_NON_CUST
,      BUDGET_SUBFUNCTION
,      FUND_VALUE
,      CCID
,      BEGINNING_BALANCE
,      ACCOUNT_TYPE
,      RECIPIENT_NAME
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      DR_AMOUNT
,      CR_AMOUNT
,      JE_SOURCE
,      JE_CATEGORY
,      GOVT_NON_GOVT
,      FACTS_ATTRIBUTE
,      REFERENCE_1
,      REFERENCE_2
,      REFERENCE_3
,      REFERENCE_5
,      REFERENCE_7
FROM FV.FV_FACTS_REPORT_T2;

Dependencies

[top of page]

FV.FV_FACTS_REPORT_T2 does not reference any database object

FV.FV_FACTS_REPORT_T2 is referenced by following:

SchemaAPPS
SynonymFV_FACTS_REPORT_T2