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

VIEW: APPS.MSD_CS_DATA_V

Object Details
Object Name: MSD_CS_DATA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_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 is used by express to download custom data stream


[View Source]

Columns
Name Datatype Length Mandatory Comments
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 Source Level Value Pk
PRD_LEVEL_VALUE VARCHAR2 (255)
Product Level Value
PRD_LEVEL_VALUE_PK VARCHAR2 (255)
Prd Level Value Pk
GEO_LEVEL_ID VARCHAR2 (255)
Geo Level Id
GEO_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Geography Source Level Value Pk
GEO_LEVEL_VALUE VARCHAR2 (255)
Geo Level Value
GEO_LEVEL_VALUE_PK VARCHAR2 (255)
Geo Level Value Pk
ORG_LEVEL_ID VARCHAR2 (255)
Org Level Id
ORG_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Org Sr 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 Channel Level Id
CHN_SR_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Channal Source Level Value Pk
CHN_LEVEL_VALUE VARCHAR2 (255)
Sales Channal Level Value
CHN_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Channal 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 NUMBER

Quantity
AMOUNT NUMBER

Amount
END_DATE DATE

Forecast End Date
PRICE NUMBER

Price
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
LAST_REFRESH_NUM NUMBER

last refresh number
CREATED_BY_REFRESH_NUM NUMBER

created by refresh number
ACTION_CODE VARCHAR2 (30)
DML action code
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_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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
,      DCS_LEVEL_ID
,      DCS_SR_LEVEL_VALUE_PK
,      DCS_LEVEL_VALUE
,      DCS_LEVEL_VALUE_PK
FROM APPS.MSD_CS_DATA_V;

Dependencies

[top of page]

APPS.MSD_CS_DATA_V references the following:

SchemaAPPS
SynonymMSD_CS_DATA

APPS.MSD_CS_DATA_V is not referenced by any database object