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

TABLE: BIM.BIM_I_BUDGETS_DENORM

Object Details
Object Name: BIM_I_BUDGETS_DENORM
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


Table contains denorm data for budget heirarchy


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_I_BUDGETS_DENORM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

Object ID
OBJECT_TYPE VARCHAR2 (30)
Object Type
PARENT_OBJECT_ID NUMBER

Parent Object ID
OBJECT_LEVEL NUMBER

Object Level
CHILD_DENORM_ID NUMBER

Child Denorm ID
CHILD_DENORM_TYPE VARCHAR2 (30)
Child Denorm Type
IMMEDIATE_CHILD_FLAG VARCHAR2 (1)
Immediate Child Flag
OBJECT_SUB_TYPE VARCHAR2 (30)
Object Sub Type
OBJECT_SUB_CAT NUMBER

Object Sub Category
LEAF_NODE_FLAG VARCHAR2 (1)
Leaf Node Flag
SECURITY_GROUP_ID NUMBER

Security Group ID
CREATION_DATE DATE

Who column
CREATED_BY NUMBER

Who column
LAST_UPDATE_DATE DATE

Who column
LAST_UPDATED_BY NUMBER

Who column
LAST_UPDATE_LOGIN NUMBER

Who column
Query Text

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


SELECT OBJECT_ID
,      OBJECT_TYPE
,      PARENT_OBJECT_ID
,      OBJECT_LEVEL
,      CHILD_DENORM_ID
,      CHILD_DENORM_TYPE
,      IMMEDIATE_CHILD_FLAG
,      OBJECT_SUB_TYPE
,      OBJECT_SUB_CAT
,      LEAF_NODE_FLAG
,      SECURITY_GROUP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM BIM.BIM_I_BUDGETS_DENORM;

Dependencies

[top of page]

BIM.BIM_I_BUDGETS_DENORM does not reference any database object

BIM.BIM_I_BUDGETS_DENORM is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_BGT_CAB_MV
Materialized ViewBIM_I_BGT_FCT_MV
SynonymBIM_I_BUDGETS_DENORM