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

TABLE: MSD.MSD_ST_CS_DATA

Object Details
Object Name: MSD_ST_CS_DATA
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_ST_CS_DATA
Subobject Name:
Status: VALID


This is staging table for Custom Stream Data.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_ST_CS_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnCS_ST_DATA_ID
Columns
Name Datatype Length Mandatory Comments
CS_ST_DATA_ID NUMBER (15) Yes Primary Key
CS_DEFINITION_ID NUMBER (15) Yes Definition ID.
CS_NAME VARCHAR2 (255) Yes Stream Name
DELETE_FLAG VARCHAR2 (30)
Reserved for Future Use.
ATTRIBUTE_1 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_2 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_3 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_4 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_5 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_6 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_7 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_8 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_9 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_10 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_11 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_12 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_13 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_14 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_15 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_16 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_17 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_18 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_19 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_20 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_21 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_22 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_23 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_24 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_25 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_26 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_27 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_28 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_29 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_30 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_31 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_32 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_33 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_34 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_35 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_36 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_37 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_38 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_39 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_40 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_41 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_42 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_43 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_44 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_45 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_46 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_47 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_48 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_49 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_50 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_51 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_52 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_53 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_54 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_55 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_56 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_57 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_58 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_59 VARCHAR2 (255)
Generic Atttribute.
ATTRIBUTE_60 VARCHAR2 (255)
Generic Atttribute.
PROCESS_STATUS VARCHAR2 (30)
Status of the row. This is used by Custom Data Stream Collection process.
ERROR_DESC VARCHAR2 (2000)
Error description. This is populated by Custom Data Stream Collection Process.
CREATION_DATE DATE

Standard Who Column.
CREATED_BY NUMBER

Standard Who Column.
LAST_UPDATE_DATE DATE

Standard Who Column.
LAST_UPDATED_BY NUMBER

Standard Who Column.
LAST_UPDATE_LOGIN NUMBER

Standard Who Column.
REQUEST_ID NUMBER

Concurrent Who Column.
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who Column.
PROGRAM_ID NUMBER

Concurrent Who Column.
PROGRAM_UPDATE_DATE DATE

Concurrent Who Column.
CS_DEFINITION_NAME VARCHAR2 (30)
Custom Stream Definition Name. This is used by legacy collection.
ATTRIBUTE_2_VAL VARCHAR2 (255)
Level Value of Attribute_2
ATTRIBUTE_6_VAL VARCHAR2 (255)
Level Value of Attribute_6
ATTRIBUTE_10_VAL VARCHAR2 (255)
Level Value of Attribute_10
ATTRIBUTE_14_VAL VARCHAR2 (255)
Level Value of Attribute_14
ATTRIBUTE_18_VAL VARCHAR2 (255)
Level Value of Attribute_18
ATTRIBUTE_22_VAL VARCHAR2 (255)
Level Value of Attribute_22
ATTRIBUTE_26_VAL VARCHAR2 (255)
Level Value of Attribute_26
ATTRIBUTE_30_VAL VARCHAR2 (255)
Level Value of Attribute_30
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code.
PROCESS_FLAG NUMBER

Process Flag.
DATA_SOURCE_TYPE VARCHAR2 (15)
This is an internal column is and is populated and used by Legacy Collection process.
BATCH_ID NUMBER

This is an internal column is and is populated and used by Legacy Collection process.
ST_TRANSACTION_ID NUMBER

This is an internal column is and is populated and used by Legacy Collection process.
ERROR_TEXT VARCHAR2 (2000)
This is an internal column is and is populated and used by Legacy Collection process.
MESSAGE_ID NUMBER

This is an internal column is and is populated and used by Legacy Collection process.
ATTRIBUTE_50_VAL VARCHAR2 (240)
Demand Class Level Value
Query Text

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


SELECT CS_ST_DATA_ID
,      CS_DEFINITION_ID
,      CS_NAME
,      DELETE_FLAG
,      ATTRIBUTE_1
,      ATTRIBUTE_2
,      ATTRIBUTE_3
,      ATTRIBUTE_4
,      ATTRIBUTE_5
,      ATTRIBUTE_6
,      ATTRIBUTE_7
,      ATTRIBUTE_8
,      ATTRIBUTE_9
,      ATTRIBUTE_10
,      ATTRIBUTE_11
,      ATTRIBUTE_12
,      ATTRIBUTE_13
,      ATTRIBUTE_14
,      ATTRIBUTE_15
,      ATTRIBUTE_16
,      ATTRIBUTE_17
,      ATTRIBUTE_18
,      ATTRIBUTE_19
,      ATTRIBUTE_20
,      ATTRIBUTE_21
,      ATTRIBUTE_22
,      ATTRIBUTE_23
,      ATTRIBUTE_24
,      ATTRIBUTE_25
,      ATTRIBUTE_26
,      ATTRIBUTE_27
,      ATTRIBUTE_28
,      ATTRIBUTE_29
,      ATTRIBUTE_30
,      ATTRIBUTE_31
,      ATTRIBUTE_32
,      ATTRIBUTE_33
,      ATTRIBUTE_34
,      ATTRIBUTE_35
,      ATTRIBUTE_36
,      ATTRIBUTE_37
,      ATTRIBUTE_38
,      ATTRIBUTE_39
,      ATTRIBUTE_40
,      ATTRIBUTE_41
,      ATTRIBUTE_42
,      ATTRIBUTE_43
,      ATTRIBUTE_44
,      ATTRIBUTE_45
,      ATTRIBUTE_46
,      ATTRIBUTE_47
,      ATTRIBUTE_48
,      ATTRIBUTE_49
,      ATTRIBUTE_50
,      ATTRIBUTE_51
,      ATTRIBUTE_52
,      ATTRIBUTE_53
,      ATTRIBUTE_54
,      ATTRIBUTE_55
,      ATTRIBUTE_56
,      ATTRIBUTE_57
,      ATTRIBUTE_58
,      ATTRIBUTE_59
,      ATTRIBUTE_60
,      PROCESS_STATUS
,      ERROR_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CS_DEFINITION_NAME
,      ATTRIBUTE_2_VAL
,      ATTRIBUTE_6_VAL
,      ATTRIBUTE_10_VAL
,      ATTRIBUTE_14_VAL
,      ATTRIBUTE_18_VAL
,      ATTRIBUTE_22_VAL
,      ATTRIBUTE_26_VAL
,      ATTRIBUTE_30_VAL
,      SR_INSTANCE_CODE
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      BATCH_ID
,      ST_TRANSACTION_ID
,      ERROR_TEXT
,      MESSAGE_ID
,      ATTRIBUTE_50_VAL
FROM MSD.MSD_ST_CS_DATA;

Dependencies

[top of page]

MSD.MSD_ST_CS_DATA does not reference any database object

MSD.MSD_ST_CS_DATA is referenced by following:

SchemaAPPS
SynonymMSD_ST_CS_DATA