[Home] [Help] [Dependency Information]
Object Name: | MSD_CUST_HIST_SALES_CS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used by express to download customer historical sales data which is received from SCE to DP
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) | Product 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) | 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 | |
CUS_LEVEL_ID | VARCHAR2 | (255) | customer Level Id | |
CUS_SR_LEVEL_VALUE_PK | VARCHAR2 | (255) | customer source Level Pk | |
CUS_LEVEL_VALUE | VARCHAR2 | (255) | customer Level Value | |
CUS_LEVEL_VALUE_PK | VARCHAR2 | (255) | customer 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 | |
SHIPPED_DATE | DATE | Shipped Date | ||
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 | |
PRD_PARENT_LEVEL_ID | VARCHAR2 | (0) | Product Parent Level Id | |
PRD_PARENT_SR_LEVEL_VALUE_PK | VARCHAR2 | (0) | Product Parent Source Level Value Pk | |
PRD_PARENT_LEVEL_VALUE_PK | VARCHAR2 | (0) | Product Parent Level Value Pk | |
PRD_PARENT_LEVEL_VALUE | VARCHAR2 | (0) | Product Parent Level Value | |
DCS_LEVEL_ID | VARCHAR2 | (255) | Demand class level ID | |
DCS_SR_LEVEL_VALUE_PK | VARCHAR2 | (255) | Demand class level value pk in source | |
DCS_LEVEL_VALUE | VARCHAR2 | (255) | Demand class level value | |
DCS_LEVEL_VALUE_PK | VARCHAR2 | (255) | Demand class level value pk |
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
, 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
, TIME_LEVEL_ID
, QUANTITY
, SHIPPED_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_SR_LEVEL_VALUE_PK
, PRD_PARENT_LEVEL_VALUE_PK
, PRD_PARENT_LEVEL_VALUE
, DCS_LEVEL_ID
, DCS_SR_LEVEL_VALUE_PK
, DCS_LEVEL_VALUE
, DCS_LEVEL_VALUE_PK
FROM APPS.MSD_CUST_HIST_SALES_CS_V;
APPS.MSD_CUST_HIST_SALES_CS_V is not referenced by any database object
|
|
|