[Home] [Help] [Dependency Information]
Object Name: | MSD_DP_SCENARIO_ENTRIES# |
---|---|
Object Type: | VIEW |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEMAND_PLAN_ID | NUMBER | Yes | ||
SCENARIO_ID | NUMBER | Yes | ||
ENTRY_ID | NUMBER | Yes | ||
QUANTITY | NUMBER | |||
AMOUNT | NUMBER | |||
BASELINE_QUANTITY | NUMBER | |||
BASELINE_AMOUNT | NUMBER | |||
TIME_LVL_ID | NUMBER | |||
TIME_LVL_VAL_FROM | DATE | Yes | ||
TIME_LVL_VAL_TO | DATE | Yes | ||
PRODUCT_LVL_ID | NUMBER | |||
PRODUCT_LVL_VAL | VARCHAR2 | (240) | ||
GEOGRAPHY_LVL_ID | NUMBER | |||
GEOGRAPHY_LVL_VAL | VARCHAR2 | (240) | ||
CUSTOMER_LVL_ID | NUMBER | |||
CUSTOMER_LVL_VAL | VARCHAR2 | (240) | ||
SALESCHANNEL_LVL_ID | NUMBER | |||
SALESCHANNEL_LVL_VAL | VARCHAR2 | (240) | ||
SALES_REP_LVL_ID | NUMBER | |||
SALES_REP_LVL_VAL | VARCHAR2 | (240) | ||
ORGANIZATION_LVL_ID | NUMBER | |||
ORGANIZATION_LVL_VAL | VARCHAR2 | (240) | ||
USER_DEFINED1_LVL_ID | NUMBER | |||
USER_DEFINED1_LVL_VAL | VARCHAR2 | (240) | ||
USER_DEFINED2_LVL_ID | NUMBER | |||
USER_DEFINED2_LVL_VAL | VARCHAR2 | (240) | ||
PRIORITY | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
PRODUCT_LVL_PK | NUMBER | |||
GEOGRAPHY_LVL_PK | NUMBER | Yes | ||
CUSTOMER_LVL_PK | NUMBER | |||
SALESCHANNEL_LVL_PK | NUMBER | Yes | ||
SALES_REP_LVL_PK | NUMBER | Yes | ||
ORGANIZATION_LVL_PK | NUMBER | Yes | ||
USER_DEFINED1_LVL_PK | NUMBER | Yes | ||
USER_DEFINED2_LVL_PK | NUMBER | Yes | ||
REVISION | VARCHAR2 | (40) | Yes | |
PARENT_REVISION | VARCHAR2 | (40) | ||
COMMENTS | VARCHAR2 | (240) | ||
ADJUSTMENT_REASON | VARCHAR2 | (3) | ||
DEPENDENT_QUANTITY | NUMBER | |||
TOTAL_QUANTITY | NUMBER | |||
BASELINE_DEPENDENT_QTY | NUMBER | |||
BASELINE_TOTAL_QTY | NUMBER | |||
SR_PRODUCT_LVL_PK | VARCHAR2 | (240) | ||
SR_GEOGRAPHY_LVL_PK | VARCHAR2 | (240) | ||
SR_CUSTOMER_LVL_PK | VARCHAR2 | (240) | ||
SR_SALESCHANNEL_LVL_PK | VARCHAR2 | (240) | ||
SR_SALES_REP_LVL_PK | VARCHAR2 | (240) | ||
SR_ORGANIZATION_LVL_PK | VARCHAR2 | (240) | ||
SR_USER_DEFINED1_LVL_PK | VARCHAR2 | (240) | ||
SR_USER_DEFINED2_LVL_PK | VARCHAR2 | (240) | ||
INSTANCE | VARCHAR2 | (40) | ||
FORECAST_PRIORITY | NUMBER | |||
TOTAL_QUANTITY_UOM | VARCHAR2 | (40) | ||
FORECAST_ERROR | NUMBER | |||
DEMAND_CLASS | VARCHAR2 | (240) | ||
DEMAND_CLASS_LVL_ID | NUMBER | |||
DEMAND_CLASS_LVL_PK | NUMBER | Yes | ||
SCENARIO_NAME | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT DEMAND_PLAN_ID
, SCENARIO_ID
, ENTRY_ID
, QUANTITY
, AMOUNT
, BASELINE_QUANTITY
, BASELINE_AMOUNT
, TIME_LVL_ID
, TIME_LVL_VAL_FROM
, TIME_LVL_VAL_TO
, PRODUCT_LVL_ID
, PRODUCT_LVL_VAL
, GEOGRAPHY_LVL_ID
, GEOGRAPHY_LVL_VAL
, CUSTOMER_LVL_ID
, CUSTOMER_LVL_VAL
, SALESCHANNEL_LVL_ID
, SALESCHANNEL_LVL_VAL
, SALES_REP_LVL_ID
, SALES_REP_LVL_VAL
, ORGANIZATION_LVL_ID
, ORGANIZATION_LVL_VAL
, USER_DEFINED1_LVL_ID
, USER_DEFINED1_LVL_VAL
, USER_DEFINED2_LVL_ID
, USER_DEFINED2_LVL_VAL
, PRIORITY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PRODUCT_LVL_PK
, GEOGRAPHY_LVL_PK
, CUSTOMER_LVL_PK
, SALESCHANNEL_LVL_PK
, SALES_REP_LVL_PK
, ORGANIZATION_LVL_PK
, USER_DEFINED1_LVL_PK
, USER_DEFINED2_LVL_PK
, REVISION
, PARENT_REVISION
, COMMENTS
, ADJUSTMENT_REASON
, DEPENDENT_QUANTITY
, TOTAL_QUANTITY
, BASELINE_DEPENDENT_QTY
, BASELINE_TOTAL_QTY
, SR_PRODUCT_LVL_PK
, SR_GEOGRAPHY_LVL_PK
, SR_CUSTOMER_LVL_PK
, SR_SALESCHANNEL_LVL_PK
, SR_SALES_REP_LVL_PK
, SR_ORGANIZATION_LVL_PK
, SR_USER_DEFINED1_LVL_PK
, SR_USER_DEFINED2_LVL_PK
, INSTANCE
, FORECAST_PRIORITY
, TOTAL_QUANTITY_UOM
, FORECAST_ERROR
, DEMAND_CLASS
, DEMAND_CLASS_LVL_ID
, DEMAND_CLASS_LVL_PK
, SCENARIO_NAME
FROM MSD.MSD_DP_SCENARIO_ENTRIES#;
|
|
|