[Home] [Help] [Dependency Information]
Object Name: | MSD_SERVICE_PART_RETURN_DS_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 olap engine to download data which is received from CRM Service Modules representing Return History.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEMAND_PLAN_ID | NUMBER | Yes | Demand Plan Id | |
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 | |
PRD_PARENT_LEVEL_ID | VARCHAR2 | (255) | Product Parent Level | |
PRD_PARENT_SR_LEVEL_VALUE_PK | VARCHAR2 | (255) | Product Parent Level Source Pk | |
PRD_PARENT_LEVEL_VALUE | VARCHAR2 | (255) | Product Parent Level Value | |
PRD_PARENT_LEVEL_VALUE_PK | VARCHAR2 | (255) | Product Parent Level Primary key | |
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 | |
END_DATE | DATE | End 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 |
Cut, paste (and edit) the following text to query this object:
SELECT DEMAND_PLAN_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
, END_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
FROM APPS.MSD_SERVICE_PART_RETURN_DS_V;
APPS.MSD_SERVICE_PART_RETURN_DS_V is not referenced by any database object
|
|
|