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

VIEW: APPS.MSD_ST_CS_DATA_V

Object Details
Object Name: MSD_ST_CS_DATA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_ST_CS_DATA_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view provides data stream staged data.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique Row ID.
CS_ST_DATA_ID NUMBER (15) Yes Primary Key.
CS_DEFINITION_ID NUMBER (15) Yes Data Definition Id.
CS_NAME VARCHAR2 (255) Yes Stream Name
INSTANCE VARCHAR2 (255)
Instance.
PRD_LEVEL_ID VARCHAR2 (255)
Product Dimension Level ID.
PRD_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Product Dimension Source Primary Key.
PRD_LEVEL_VALUE VARCHAR2 (255)
Product Dimension Level Value.
PRD_LEVEL_VALUE_PK VARCHAR2 (255)
Product Dimension LEVEL_PK.
GEO_LEVEL_ID VARCHAR2 (255)
Geography Dimension Level ID.
GEO_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Geography Dimension Source Primary Key.
GEO_LEVEL_VALUE VARCHAR2 (255)
Geography Dimension Level Value.
GEO_LEVEL_VALUE_PK VARCHAR2 (255)
Geography Dimension LEVEL_PK.
ORG_LEVEL_ID VARCHAR2 (255)
Organization Dimension Level ID.
ORG_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Organization Dimension Source Primary Key.
ORG_LEVEL_VALUE VARCHAR2 (255)
Organization Dimension Level Value.
ORG_LEVEL_VALUE_PK VARCHAR2 (255)
Organization Dimension LEVEL_PK.
CUS_LEVEL_ID VARCHAR2 (255)
Reserved for future use.
CUS_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Reserved for future use.
CUS_LEVEL_VALUE VARCHAR2 (255)
Reserved for future use.
CUS_LEVEL_VALUE_PK VARCHAR2 (255)
Reserved for future use.
REP_LEVEL_ID VARCHAR2 (255)
Sales Rep Dimension Level ID.
REP_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Rep Dimension Source Primary Key.
REP_LEVEL_VALUE VARCHAR2 (255)
Sales Rep Dimension Level Value.
REP_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Rep Dimension LEVEL_PK.
CHN_LEVEL_ID VARCHAR2 (255)
Sales Channel Dimension Level ID.
CHN_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Channel Dimension Source Primary Key.
CHN_LEVEL_VALUE VARCHAR2 (255)
Sales Channel Dimension Level Value.
CHN_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Channel Dimension LEVEL_PK.
UD1_LEVEL_ID VARCHAR2 (255)
User Dimension 1 Level ID.
UD1_SR_LEVEL_VALUE_PK VARCHAR2 (255)
User Dimension 1 Source Primary Key.
UD1_LEVEL_VALUE VARCHAR2 (255)
User Dimension 1 Level Value.
UD1_LEVEL_VALUE_PK VARCHAR2 (255)
User Dimension 1 LEVEL_PK.
UD2_LEVEL_ID VARCHAR2 (255)
User Dimension 2 Level ID.
UD2_SR_LEVEL_VALUE_PK VARCHAR2 (255)
User Dimension 2 Source Primary Key.
UD2_LEVEL_VALUE VARCHAR2 (255)
User Dimension 2 Level Value.
UD2_LEVEL_VALUE_PK VARCHAR2 (255)
User Dimension 2 LEVEL_PK.
ATTRIBUTE_34 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_35 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_36 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_37 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_38 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_39 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_40 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
QUANTITY VARCHAR2 (255)
Quantity
AMOUNT VARCHAR2 (255)
Amount
END_DATE VARCHAR2 (255)
End Date
PRICE VARCHAR2 (255)
Price
ATTRIBUTE_45 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_46 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_47 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_48 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_49 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_50 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_51 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_52 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_53 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_54 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_55 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_56 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_57 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_58 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_59 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
ATTRIBUTE_60 VARCHAR2 (255)
Generic Attribute. Reserved for future use.
PROCESS_STATUS VARCHAR2 (30)
Process Status
ERROR_DESC VARCHAR2 (2000)
Error Description
Query Text

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


SELECT ROW_ID
,      CS_ST_DATA_ID
,      CS_DEFINITION_ID
,      CS_NAME
,      INSTANCE
,      PRD_LEVEL_ID
,      PRD_SR_LEVEL_VALUE_PK
,      PRD_LEVEL_VALUE
,      PRD_LEVEL_VALUE_PK
,      GEO_LEVEL_ID
,      GEO_SR_LEVEL_VALUE_PK
,      GEO_LEVEL_VALUE
,      GEO_LEVEL_VALUE_PK
,      ORG_LEVEL_ID
,      ORG_SR_LEVEL_VALUE_PK
,      ORG_LEVEL_VALUE
,      ORG_LEVEL_VALUE_PK
,      CUS_LEVEL_ID
,      CUS_SR_LEVEL_VALUE_PK
,      CUS_LEVEL_VALUE
,      CUS_LEVEL_VALUE_PK
,      REP_LEVEL_ID
,      REP_SR_LEVEL_VALUE_PK
,      REP_LEVEL_VALUE
,      REP_LEVEL_VALUE_PK
,      CHN_LEVEL_ID
,      CHN_SR_LEVEL_VALUE_PK
,      CHN_LEVEL_VALUE
,      CHN_LEVEL_VALUE_PK
,      UD1_LEVEL_ID
,      UD1_SR_LEVEL_VALUE_PK
,      UD1_LEVEL_VALUE
,      UD1_LEVEL_VALUE_PK
,      UD2_LEVEL_ID
,      UD2_SR_LEVEL_VALUE_PK
,      UD2_LEVEL_VALUE
,      UD2_LEVEL_VALUE_PK
,      ATTRIBUTE_34
,      ATTRIBUTE_35
,      ATTRIBUTE_36
,      ATTRIBUTE_37
,      ATTRIBUTE_38
,      ATTRIBUTE_39
,      ATTRIBUTE_40
,      QUANTITY
,      AMOUNT
,      END_DATE
,      PRICE
,      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
FROM APPS.MSD_ST_CS_DATA_V;

Dependencies

[top of page]

APPS.MSD_ST_CS_DATA_V references the following:

SchemaAPPS
SynonymMSD_ST_CS_DATA

APPS.MSD_ST_CS_DATA_V is not referenced by any database object