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

TABLE: MSD.MSD_CS_DATA

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


This is fact table for Custom Data Stream.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_CS_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCS_DATA_ID
MSD_CS_DATA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTRIBUTE_43
ColumnCS_NAME
ColumnCS_DEFINITION_ID
ColumnATTRIBUTE_1
MSD_CS_DATA_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCS_DEFINITION_ID
MSD_CS_DATA_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTRIBUTE_2
ColumnCS_DEFINITION_ID
ColumnATTRIBUTE_10
Columns
Name Datatype Length Mandatory Comments
CS_DATA_ID NUMBER (15) Yes Primary Key.
CS_DEFINITION_ID NUMBER (15) Yes Foreign Key to MSD_CS_DEFINITIONS.
CS_NAME VARCHAR2 (255) Yes Custom Stream Name.
ATTRIBUTE_1 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_2 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_3 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_4 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_5 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_6 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_7 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_8 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_9 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_10 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_11 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_12 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_13 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_14 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_15 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_16 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_17 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_18 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_19 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_20 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_21 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_22 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_23 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_24 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_25 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_26 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_27 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_28 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_29 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_30 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_31 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_32 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_33 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_34 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_35 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_36 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_37 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_38 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_39 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_40 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_41 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_42 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_43 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_44 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_45 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_46 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_47 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_48 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_49 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_50 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_51 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_52 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_53 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_54 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_55 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_56 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_57 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_58 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_59 VARCHAR2 (255)
Generic Attribute
ATTRIBUTE_60 VARCHAR2 (255)
Generic Attribute
CREATION_DATE DATE
Yes Who columns
CREATED_BY NUMBER
Yes Who columns
LAST_UPDATE_DATE DATE
Yes Who columns
LAST_UPDATED_BY NUMBER
Yes Who columns
LAST_UPDATE_LOGIN NUMBER

Who columns
REQUEST_ID NUMBER

Enhanced Who Columns
PROGRAM_APPLICATION_ID NUMBER

Enhanced Who Columns
PROGRAM_ID NUMBER

Enhanced Who Columns
PROGRAM_UPDATE_DATE DATE

Enhanced Who Columns
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
LAST_REFRESH_NUM NUMBER

Last refresh number
ACTION_CODE VARCHAR2 (30)
DML action code
LIABILITY_USER_FLAG VARCHAR2 (15)
Indicates that only streams with this flag as 'Y' can be selected as Input Parameter in a Liability Plan
Query Text

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


SELECT CS_DATA_ID
,      CS_DEFINITION_ID
,      CS_NAME
,      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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY_REFRESH_NUM
,      LAST_REFRESH_NUM
,      ACTION_CODE
,      LIABILITY_USER_FLAG
FROM MSD.MSD_CS_DATA;

Dependencies

[top of page]

MSD.MSD_CS_DATA does not reference any database object

MSD.MSD_CS_DATA is referenced by following:

SchemaMSD
ViewMSD_CS_DATA#