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

VIEW: APPS.MSD_OPPORTUNITY_DATA_CS_V

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

View Type

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


This view Specifies the Opportunity History. This view is based on Flexible data stream entity MSD_CS_DATA.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CS_DEFINITION_ID NUMBER (15) Yes Foreign Key to MSD_CS_DEFINITIONS.
CS_NAME VARCHAR2 (255) Yes Opportunity Name. For Sales Opportunity it's always defaulted.
PRD_LEVEL_ID VARCHAR2 (255)
Product Level Id.
PRD_LEVEL_VALUE_PK VARCHAR2 (255)
Product Level Value Primary Key.
GEO_LEVEL_ID VARCHAR2 (255)
Geography Dimension Level ID.
GEO_LEVEL_VALUE_PK VARCHAR2 (255)
Geography Level Value Primary Key.
ORG_LEVEL_ID VARCHAR2 (255)
Organization Level ID.
ORG_LEVEL_VALUE_PK VARCHAR2 (255)
Organization Level Value Primary Key.
REP_LEVEL_ID VARCHAR2 (255)
Sales Rep Level ID.
REP_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Rep Level Value Primary Key.
CHN_LEVEL_ID VARCHAR2 (255)
Sales Channel Level ID.
CHN_LEVEL_VALUE_PK VARCHAR2 (255)
Sales Channel Level Value Primary Key.
UD1_LEVEL_ID VARCHAR2 (255)
User Define Dimension 1 Level ID.
UD1_LEVEL_VALUE_PK VARCHAR2 (255)
User Define Dimension 1 Level Value Primary Key.
UD2_LEVEL_ID VARCHAR2 (255)
User Define Dimension 2 Level ID.
UD2_LEVEL_VALUE_PK VARCHAR2 (255)
User Define Dimension 2 Level Value Primary Key.
TIME_LEVEL_ID VARCHAR2 (255)
Time Level ID.
QUANTITY VARCHAR2 (255)
Quantity.
AMOUNT VARCHAR2 (255)
Amount
END_DATE DATE

Opportunity Date
CREATION_DATE DATE
Yes Standard Who Columns.
CREATED_BY NUMBER
Yes Standard Who Columns.
LAST_UPDATE_DATE DATE
Yes Standard Who Columns.
LAST_UPDATED_BY NUMBER
Yes Standard Who Columns.
LAST_UPDATE_LOGIN NUMBER

Standard 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
PRD_PARENT_LEVEL_ID VARCHAR2 (0)
Product Parent Level Id
PRD_PARENT_LEVEL_VALUE_PK VARCHAR2 (0)
Product Parent Level value Pk
Query Text

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


SELECT CS_DEFINITION_ID
,      CS_NAME
,      PRD_LEVEL_ID
,      PRD_LEVEL_VALUE_PK
,      GEO_LEVEL_ID
,      GEO_LEVEL_VALUE_PK
,      ORG_LEVEL_ID
,      ORG_LEVEL_VALUE_PK
,      REP_LEVEL_ID
,      REP_LEVEL_VALUE_PK
,      CHN_LEVEL_ID
,      CHN_LEVEL_VALUE_PK
,      UD1_LEVEL_ID
,      UD1_LEVEL_VALUE_PK
,      UD2_LEVEL_ID
,      UD2_LEVEL_VALUE_PK
,      TIME_LEVEL_ID
,      QUANTITY
,      AMOUNT
,      END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_REFRESH_NUM
,      CREATED_BY_REFRESH_NUM
,      ACTION_CODE
,      PRD_PARENT_LEVEL_ID
,      PRD_PARENT_LEVEL_VALUE_PK
FROM APPS.MSD_OPPORTUNITY_DATA_CS_V;

Dependencies

[top of page]

APPS.MSD_OPPORTUNITY_DATA_CS_V references the following:

SchemaAPPS
SynonymMSD_CS_DATA
SynonymMSD_CS_DEFINITIONS

APPS.MSD_OPPORTUNITY_DATA_CS_V is not referenced by any database object