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

TABLE: BIS.EDW_CONS_SET_OF_BOOKS

Object Details
Object Name: EDW_CONS_SET_OF_BOOKS
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.EDW_CONS_SET_OF_BOOKS
TableFII.EDW_CONS_SET_OF_BOOKS
Subobject Name:
Status: VALID


This is the setup table used by accounting flexfield dimensions. This stores information about your consolidation mappings.This table corresponds to the Consolidation Set of Books Setup form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CHILD_EDW_SET_OF_BOOKS_ID NUMBER (15)
Subsidiary accounting books defining column
PARENT_EDW_SET_OF_BOOKS_ID NUMBER (15)
Parent accounting books defining column
CONSOLIDATION_ID NUMBER (15)
Consolidation defining column
CONSOLIDATION_NAME VARCHAR2 (80)
Consolidation name
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

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


SELECT CHILD_EDW_SET_OF_BOOKS_ID
,      PARENT_EDW_SET_OF_BOOKS_ID
,      CONSOLIDATION_ID
,      CONSOLIDATION_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.EDW_CONS_SET_OF_BOOKS;

Dependencies

[top of page]

BIS.EDW_CONS_SET_OF_BOOKS does not reference any database object

BIS.EDW_CONS_SET_OF_BOOKS is referenced by following:

SchemaAPPS
SynonymEDW_CONS_SET_OF_BOOKS