[Home] [Help] [Dependency Information]
Object Name: | MSD_BACKLOG_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 order backlog data stream. 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) | 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 | VARCHAR2 | (255) | Quantity | |
AMOUNT | VARCHAR2 | (255) | Amount | |
BOOKED_DATE | DATE | Forecast End Date | ||
REQUESTED_DATE | DATE | Forecast End Date | ||
SCHEDULED_DATE | DATE | 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 | |
SCHEDULED_ARRIVAL_DATE | DATE | Scheduled Arrival Date | ||
DCS_LEVEL_ID | VARCHAR2 | (255) | Demand Class 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) | Demand Class Level Value PK |
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
, AMOUNT
, BOOKED_DATE
, REQUESTED_DATE
, SCHEDULED_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, SCHEDULED_ARRIVAL_DATE
, DCS_LEVEL_ID
, DCS_SR_LEVEL_VALUE_PK
, DCS_LEVEL_VALUE
, DCS_LEVEL_VALUE_PK
FROM APPS.MSD_BACKLOG_DS_V;
APPS.MSD_BACKLOG_DS_V is not referenced by any database object
|
|
|