Skip to content

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

TABLE: BIS.EDW_VBH_ROOTS

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


This is the setup table used by accounting flexfield dimensions. This stores the roots for each consolidated set of books. This table corresponds to VBH Hierarchy Root 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)
Warehouse accounting books defining column
SEGMENT_NAME VARCHAR2 (30)
Segment name
ROOT_VALUE1 VARCHAR2 (240)
Root of hierarchy 1
ROOT_VALUE2 VARCHAR2 (240)
Root of hierarchy 2
ROOT_VALUE3 VARCHAR2 (240)
Root of hierarchy 3
ROOT_VALUE4 VARCHAR2 (240)
Root of hierarchy 4
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
,      SEGMENT_NAME
,      ROOT_VALUE1
,      ROOT_VALUE2
,      ROOT_VALUE3
,      ROOT_VALUE4
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.EDW_VBH_ROOTS;

Dependencies

[top of page]

BIS.EDW_VBH_ROOTS does not reference any database object

BIS.EDW_VBH_ROOTS is referenced by following:

SchemaAPPS
SynonymEDW_VBH_ROOTS