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

VIEW: APPS.MSD_CS_DATA_V1

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

View Type

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


This view is for Audit report


[View Source]

Columns
Name Datatype Length Mandatory Comments
CS_DATA_ID NUMBER (15) Yes System generated primary key for custom stream fact data.
CS_DEFINITION_ID NUMBER (15) Yes Cs Definition Id
CS_NAME VARCHAR2 (255) Yes Cs Name
INSTANCE VARCHAR2 (255)
Instance
PRD_LEVEL_ID VARCHAR2 (255)
Product Level Id
PRD_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Product Sr Level Value Pk
PRD_LEVEL_VALUE VARCHAR2 (255)
Product Level Value
PRD_LEVEL_VALUE_PK VARCHAR2 (255)
Product Level Value Pk
GEO_LEVEL_ID VARCHAR2 (255)
Geography Level Id
GEO_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Geography Source Level Pk
GEO_LEVEL_VALUE VARCHAR2 (255)
Geography Level Value
GEO_LEVEL_VALUE_PK VARCHAR2 (255)
Geography Level Value Pk
ORG_LEVEL_ID VARCHAR2 (255)
Org Level Id
ORG_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Org Source Level Value Pk
ORG_LEVEL_VALUE VARCHAR2 (255)
Org Level Value
ORG_LEVEL_VALUE_PK VARCHAR2 (255)
Org Level Value Pk
PRD_PARENT_LEVEL_ID VARCHAR2 (255)
Product Parent Level Id
PRD_PARENT_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Product Parent Source Level Value Pk
PRD_PARENT_LEVEL_VALUE VARCHAR2 (255)
Product Parent Level Value
PRD_PARENT_LEVEL_VALUE_PK VARCHAR2 (255)
Product Parent Level Value Pk
REP_LEVEL_ID VARCHAR2 (255)
Sales Rep Level Id
REP_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Rep source Level value Pk
REP_LEVEL_VALUE VARCHAR2 (255)
Sales Rep Level value
REP_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Rep Level value Pk
CHN_LEVEL_ID VARCHAR2 (255)
Sales Chennal Level Id
CHN_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Chennal source Level Value Pk
CHN_LEVEL_VALUE VARCHAR2 (255)
Sales Chennal Level Value
CHN_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Chennal Level Value Pk
UD1_LEVEL_ID VARCHAR2 (255)
User Defined Level Id
UD1_SR_LEVEL_VALUE_PK VARCHAR2 (255)
User Defined Source Level Value Pk
UD1_LEVEL_VALUE VARCHAR2 (255)
User Defined Level Value
UD1_LEVEL_VALUE_PK VARCHAR2 (255)
User Defined Level Value Pk
UD2_LEVEL_ID VARCHAR2 (255)
User Defined Level Id
UD2_SR_LEVEL_VALUE_PK VARCHAR2 (255)
User Defined Source Level Value Pk
UD2_LEVEL_VALUE VARCHAR2 (255)
User Defined Level Value
UD2_LEVEL_VALUE_PK VARCHAR2 (255)
User Defined Level Value Pk
TIME_LEVEL_ID VARCHAR2 (255)
Time Level Id
QUANTITY VARCHAR2 (255)
Quantity
AMOUNT VARCHAR2 (255)
Amount
END_DATE DATE

End Date
PRICE VARCHAR2 (255)
Price
LAST_REFRESH_NUM NUMBER

Last refresh number
CREATED_BY_REFRESH_NUM NUMBER

Created By Refresh Number
DCS_LEVEL_ID VARCHAR2 (255)
DCS Level Id
DCS_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Demand Class SR Level Value Pk
DCS_LEVEL_VALUE VARCHAR2 (255)
DCS Level Value
DCS_LEVEL_VALUE_PK VARCHAR2 (255)
DCS Level Value Pk
Query Text

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


SELECT CS_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
,      PRD_PARENT_LEVEL_ID
,      PRD_PARENT_SR_LEVEL_VALUE_PK
,      PRD_PARENT_LEVEL_VALUE
,      PRD_PARENT_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
,      TIME_LEVEL_ID
,      QUANTITY
,      AMOUNT
,      END_DATE
,      PRICE
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      DCS_LEVEL_ID
,      DCS_SR_LEVEL_VALUE_PK
,      DCS_LEVEL_VALUE
,      DCS_LEVEL_VALUE_PK
FROM APPS.MSD_CS_DATA_V1;

Dependencies

[top of page]

APPS.MSD_CS_DATA_V1 references the following:

SchemaAPPS
SynonymMSD_CS_DATA

APPS.MSD_CS_DATA_V1 is not referenced by any database object