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

TABLE: BIM.BIM_I_SOURCE_CODES

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


This table stores information about objects (like Campaigns and Event) and their child_objects (like Campaign Schedules etc)


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_I_SOURCE_CODES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
BIM_I_SOURCE_CODES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE
BIM_I_SOURCE_CODES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_SOURCE_CODE_ID
BIM_I_SOURCE_CODES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHILD_OBJECT_ID
BIM_I_SOURCE_CODES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_ID
BIM_I_SOURCE_CODES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHILD_OBJECT_TYPE
ColumnCHILD_OBJECT_ID
BIM_I_SOURCE_CODES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_CODE
BIM_I_SOURCE_CODES_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_CODE_ID
BIM_I_SOURCE_CODES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJ_LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
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
OBJ_LAST_UPDATE_DATE DATE

This will store last update date of the object
SOURCE_CODE_ID NUMBER

Source Code ID of the Object or the Child Object
SOURCE_CODE VARCHAR2 (30)
Source Code of the Object or the Child Object
OBJECT_ID NUMBER

ID of the Object
OBJECT_TYPE VARCHAR2 (30)
Type of the Object
OBJECT_STATUS VARCHAR2 (30)
Status of the Object
OBJECT_PURPOSE VARCHAR2 (240)
Purpose of the Object
OBJECT_COUNTRY VARCHAR2 (30)
Country of the Object
OBJECT_REGION VARCHAR2 (30)
Region of the Object
BUSINESS_UNIT_ID NUMBER

Business Unit ID
OWNER_USER_ID NUMBER

Owner of the Object or Child Object
START_DATE DATE

Start Date of the Object or Child Object
END_DATE DATE

End Date of the Object or Child Object
CATEGORY_ID NUMBER

Product Category ID
CHILD_OBJECT_ID NUMBER

ID of Child Object
CHILD_OBJECT_TYPE VARCHAR2 (30)
Type of Child Object
CHILD_OBJECT_STATUS VARCHAR2 (30)
Status of Child Object
CHILD_OBJECT_PURPOSE VARCHAR2 (240)
Purpose of Child Object
CHILD_OBJECT_COUNTRY VARCHAR2 (30)
Country of Child Object
CHILD_OBJECT_REGION VARCHAR2 (30)
Region of Child Object
CHILD_OBJECT_USAGE VARCHAR2 (30)
Fat or Lite
ACTIVITY_ID NUMBER

Activity ID
ACTIVITY_TYPE VARCHAR2 (30)
Activity Type
ADJ_START_DATE DATE

Adjusted Start Date
ADJ_END_DATE DATE

Adjusted End Date
METRIC1 NUMBER

Currently Not Used
METRIC2 NUMBER

Currently Not Used
METRIC3 NUMBER

Currently Not Used
METRIC4 NUMBER

Currently Not Used
METRIC5 NUMBER

Currently Not Used
METRIC6 NUMBER

Currently Not Used
METRIC7 NUMBER

Currently Not Used
METRIC8 NUMBER

Currently Not Used
METRIC9 NUMBER

Currently Not Used
METRIC10 NUMBER

Currently Not Used
METRIC11 NUMBER

Currently Not Used
METRIC12 NUMBER

Currently Not Used
METRIC13 NUMBER

Currently Not Used
METRIC14 NUMBER

Currently Not Used
METRIC15 NUMBER

Currently Not Used
SECURITY_GROUP_ID NUMBER

Security Group ID
PARENT_SOURCE_CODE_ID NUMBER

Parent Source Code Id
ROLLUP_TYPE VARCHAR2 (30)
Rollup Type
Query Text

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


SELECT CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJ_LAST_UPDATE_DATE
,      SOURCE_CODE_ID
,      SOURCE_CODE
,      OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_STATUS
,      OBJECT_PURPOSE
,      OBJECT_COUNTRY
,      OBJECT_REGION
,      BUSINESS_UNIT_ID
,      OWNER_USER_ID
,      START_DATE
,      END_DATE
,      CATEGORY_ID
,      CHILD_OBJECT_ID
,      CHILD_OBJECT_TYPE
,      CHILD_OBJECT_STATUS
,      CHILD_OBJECT_PURPOSE
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_REGION
,      CHILD_OBJECT_USAGE
,      ACTIVITY_ID
,      ACTIVITY_TYPE
,      ADJ_START_DATE
,      ADJ_END_DATE
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      SECURITY_GROUP_ID
,      PARENT_SOURCE_CODE_ID
,      ROLLUP_TYPE
FROM BIM.BIM_I_SOURCE_CODES;

Dependencies

[top of page]

BIM.BIM_I_SOURCE_CODES does not reference any database object

BIM.BIM_I_SOURCE_CODES is referenced by following:

SchemaBIM
ViewBIM_I_SOURCE_CODES#