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

TABLE: FV.FV_CFS_REP_LINE_DTL

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FV_CFS_REP_LINE_DTL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
ColumnLINE_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER
Yes Line ID
LINE_DETAIL_ID NUMBER
Yes Line Deatil ID
SEGMENT1 VARCHAR2 (25)
Key flexfield segment
SEGMENT2 VARCHAR2 (25)
Key flexfield segment
SEGMENT3 VARCHAR2 (25)
Key flexfield segment
SEGMENT4 VARCHAR2 (25)
Key flexfield segment
SEGMENT5 VARCHAR2 (25)
Key flexfield segment
SEGMENT6 VARCHAR2 (25)
Key flexfield segment
SEGMENT7 VARCHAR2 (25)
Key flexfield segment
SEGMENT8 VARCHAR2 (25)
Key flexfield segment
SEGMENT9 VARCHAR2 (25)
Key flexfield segment
SEGMENT10 VARCHAR2 (25)
Key flexfield segment
SEGMENT11 VARCHAR2 (25)
Key flexfield segment
SEGMENT12 VARCHAR2 (25)
Key flexfield segment
SEGMENT13 VARCHAR2 (25)
Key flexfield segment
SEGMENT14 VARCHAR2 (25)
Key flexfield segment
SEGMENT15 VARCHAR2 (25)
Key flexfield segment
SEGMENT16 VARCHAR2 (25)
Key flexfield segment
SEGMENT17 VARCHAR2 (25)
Key flexfield segment
SEGMENT18 VARCHAR2 (25)
Key flexfield segment
SEGMENT19 VARCHAR2 (25)
Key flexfield segment
SEGMENT20 VARCHAR2 (25)
Key flexfield segment
SEGMENT21 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT22 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT23 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT24 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT25 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT26 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT27 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT28 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT29 VARCHAR2 (25)
Accounting Flexfield segment
SEGMENT30 VARCHAR2 (25)
Accounting Flexfield segment
BALANCE_TYPE VARCHAR2 (1) Yes Natural Balance Type
FED_NON_FED VARCHAR2 (2)
Federal/Nnon-Federal Flag
CUST_NON_CUST VARCHAR2 (2)
Exchange/Non-Exchange Flag
EXCH_NON_EXCH VARCHAR2 (240)
Exchange/Non-Exchange Flag
CUM_RES VARCHAR2 (240)
Cumulative Resolution Flag
UNEXP_APPROP VARCHAR2 (240)
Unexpended Appropriations Flag
BUDGET_COL VARCHAR2 (240)
Budget Column Flag
NBFA_COL VARCHAR2 (240)
NBFA Column Flag
FUND_STATUS VARCHAR2 (1)
Fund Status
FUND_CATEGORY VARCHAR2 (1)
Fund Category
FLEX_FURTHER_DEF VARCHAR2 (1)
Flexfield Needs Further Definition Flag
SET_OF_BOOKS_ID NUMBER (15) Yes Set Of Books ID
ORG_ID NUMBER (15)
Organization identifier
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
COUNTER NUMBER

This column will be used by the consolidated financials table setup proces
Query Text

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


SELECT LINE_ID
,      LINE_DETAIL_ID
,      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
,      BALANCE_TYPE
,      FED_NON_FED
,      CUST_NON_CUST
,      EXCH_NON_EXCH
,      CUM_RES
,      UNEXP_APPROP
,      BUDGET_COL
,      NBFA_COL
,      FUND_STATUS
,      FUND_CATEGORY
,      FLEX_FURTHER_DEF
,      SET_OF_BOOKS_ID
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COUNTER
FROM FV.FV_CFS_REP_LINE_DTL;

Dependencies

[top of page]

FV.FV_CFS_REP_LINE_DTL does not reference any database object

FV.FV_CFS_REP_LINE_DTL is referenced by following:

SchemaAPPS
SynonymFV_CFS_REP_LINE_DTL