[Home] [Help] [Dependency Information]
Object Name: | MSD_CMRO_FCST_MTLREQ_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 express to download data which is received from CMRO to DP. This view is striped by demand plan.
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 | |
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 | |
REQUESTED_DATE | DATE | Requested 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 |
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
, 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
, REQUESTED_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
FROM APPS.MSD_CMRO_FCST_MTLREQ_DS_V;
APPS.MSD_CMRO_FCST_MTLREQ_DS_V is not referenced by any database object
|
|
|