Skip to content

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

TABLE: BIM.BIM_I_SOURCE_DENORM

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


This table stores source code hierarchy data


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_I_SOURCE_DENORM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_CODE_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_CODE_ID NUMBER

source code id
PARENT_SOURCE_CODE_ID NUMBER (30)
parent source code id
PRIOR_ID NUMBER

parent of parent source code id
IMMEDIATE_PARENT_FLAG VARCHAR2 (30)
immediate parent id
IMMEDIATE_PARENT_ID NUMBER

immediate parent flag
OBJECT_LEVEL NUMBER

object level in the hierarchy
ROLLUP_TYPE VARCHAR2 (30)
Rollup Type
PARENT_SOURCE_CODE_TYPE VARCHAR2 (30)
Parent Source Code Type
TOP_NODE_FLAG VARCHAR2 (30)
Top Node Flag
LEAF_NODE_FLAG VARCHAR2 (30)
Leaf Node Flag
CREATION_DATE DATE
Yes who column
LAST_UPDATE_DATE DATE
Yes who column
CREATED_BY NUMBER
Yes who column
LAST_UPDATED_BY NUMBER
Yes who column
LAST_UPDATE_LOGIN NUMBER

who column
SECURITY_GROUP_ID NUMBER

Security group id
Query Text

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


SELECT SOURCE_CODE_ID
,      PARENT_SOURCE_CODE_ID
,      PRIOR_ID
,      IMMEDIATE_PARENT_FLAG
,      IMMEDIATE_PARENT_ID
,      OBJECT_LEVEL
,      ROLLUP_TYPE
,      PARENT_SOURCE_CODE_TYPE
,      TOP_NODE_FLAG
,      LEAF_NODE_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM BIM.BIM_I_SOURCE_DENORM;

Dependencies

[top of page]

BIM.BIM_I_SOURCE_DENORM does not reference any database object

BIM.BIM_I_SOURCE_DENORM is referenced by following:

SchemaBIM
ViewBIM_I_SOURCE_DENORM#