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

TABLE: BIS.EDW_EQUI_SET_OF_BOOKS

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


This is the setup table used by accounting flexfield dimensions. This stores the same sets of books sitting in different instances. This table corresponds to the the Equivalent Set of Books Setup form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EDW_SET_OF_BOOKS_ID NUMBER (15)
Subsidiary accounting books defining column
EQUI_SET_OF_BOOKS_ID NUMBER (15)
Equivalent accounting books defining column
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 EDW_SET_OF_BOOKS_ID
,      EQUI_SET_OF_BOOKS_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.EDW_EQUI_SET_OF_BOOKS;

Dependencies

[top of page]

BIS.EDW_EQUI_SET_OF_BOOKS does not reference any database object

BIS.EDW_EQUI_SET_OF_BOOKS is referenced by following:

SchemaAPPS
SynonymEDW_EQUI_SET_OF_BOOKS