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

TABLE: BIM.BIM_R_SOURCE_CODES

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


This table stores information about objects and source codes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_SOURCE_CODES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
BIM_R_SOURCE_CODES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_ID
BIM_R_SOURCE_CODES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_CODE
BIM_R_SOURCE_CODES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_CODE_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_CODE_ID NUMBER

source code unique identifier
SOURCE_CODE VARCHAR2 (30)
source code
PARENT_OBJECT_TYPE VARCHAR2 (30)
type of the parent of the object
PARENT_OBJECT_ID NUMBER

ideatifier of the parent object
OBJECT_TYPE VARCHAR2 (30)
object type
OBJECT_ID NUMBER

object identifier
BUSINESS_UNIT_ID NUMBER

business unit id
STATUS VARCHAR2 (30)
status
COUNTRY_CODE VARCHAR2 (30)
country code
START_DATE DATE

start date
END_DATE DATE

end date
SECURITY_GROUP_ID NUMBER

used in hosting environment
Query Text

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


SELECT SOURCE_CODE_ID
,      SOURCE_CODE
,      PARENT_OBJECT_TYPE
,      PARENT_OBJECT_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      BUSINESS_UNIT_ID
,      STATUS
,      COUNTRY_CODE
,      START_DATE
,      END_DATE
,      SECURITY_GROUP_ID
FROM BIM.BIM_R_SOURCE_CODES;

Dependencies

[top of page]

BIM.BIM_R_SOURCE_CODES does not reference any database object

BIM.BIM_R_SOURCE_CODES is referenced by following:

SchemaAPPS
SynonymBIM_R_SOURCE_CODES