VIEW: MSD.MSD_DP_SCENARIO_ENTRIES#

Source

View Text - Preformatted

select DEMAND_PLAN_ID DEMAND_PLAN_ID, SCENARIO_ID SCENARIO_ID, ENTRY_ID ENTRY_ID, QUANTITY QUANTITY, AMOUNT AMOUNT, BASELINE_QUANTITY BASELINE_QUANTITY, BASELINE_AMOUNT BASELINE_AMOUNT, TIME_LVL_ID TIME_LVL_ID, TIME_LVL_VAL_FROM TIME_LVL_VAL_FROM, TIME_LVL_VAL_TO TIME_LVL_VAL_TO, PRODUCT_LVL_ID PRODUCT_LVL_ID, PRODUCT_LVL_VAL PRODUCT_LVL_VAL, GEOGRAPHY_LVL_ID GEOGRAPHY_LVL_ID, GEOGRAPHY_LVL_VAL GEOGRAPHY_LVL_VAL, CUSTOMER_LVL_ID CUSTOMER_LVL_ID, CUSTOMER_LVL_VAL CUSTOMER_LVL_VAL, SALESCHANNEL_LVL_ID SALESCHANNEL_LVL_ID, SALESCHANNEL_LVL_VAL SALESCHANNEL_LVL_VAL, SALES_REP_LVL_ID SALES_REP_LVL_ID, SALES_REP_LVL_VAL SALES_REP_LVL_VAL, ORGANIZATION_LVL_ID ORGANIZATION_LVL_ID, ORGANIZATION_LVL_VAL ORGANIZATION_LVL_VAL, USER_DEFINED1_LVL_ID USER_DEFINED1_LVL_ID, USER_DEFINED1_LVL_VAL USER_DEFINED1_LVL_VAL, USER_DEFINED2_LVL_ID USER_DEFINED2_LVL_ID, USER_DEFINED2_LVL_VAL USER_DEFINED2_LVL_VAL, PRIORITY PRIORITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PRODUCT_LVL_PK PRODUCT_LVL_PK, GEOGRAPHY_LVL_PK GEOGRAPHY_LVL_PK, CUSTOMER_LVL_PK CUSTOMER_LVL_PK, SALESCHANNEL_LVL_PK SALESCHANNEL_LVL_PK, SALES_REP_LVL_PK SALES_REP_LVL_PK, ORGANIZATION_LVL_PK ORGANIZATION_LVL_PK, USER_DEFINED1_LVL_PK USER_DEFINED1_LVL_PK, USER_DEFINED2_LVL_PK USER_DEFINED2_LVL_PK, REVISION REVISION, PARENT_REVISION PARENT_REVISION, COMMENTS COMMENTS, ADJUSTMENT_REASON ADJUSTMENT_REASON, DEPENDENT_QUANTITY DEPENDENT_QUANTITY, TOTAL_QUANTITY TOTAL_QUANTITY, BASELINE_DEPENDENT_QTY BASELINE_DEPENDENT_QTY, BASELINE_TOTAL_QTY BASELINE_TOTAL_QTY, SR_PRODUCT_LVL_PK SR_PRODUCT_LVL_PK, SR_GEOGRAPHY_LVL_PK SR_GEOGRAPHY_LVL_PK, SR_CUSTOMER_LVL_PK SR_CUSTOMER_LVL_PK, SR_SALESCHANNEL_LVL_PK SR_SALESCHANNEL_LVL_PK, SR_SALES_REP_LVL_PK SR_SALES_REP_LVL_PK, SR_ORGANIZATION_LVL_PK SR_ORGANIZATION_LVL_PK, SR_USER_DEFINED1_LVL_PK SR_USER_DEFINED1_LVL_PK, SR_USER_DEFINED2_LVL_PK SR_USER_DEFINED2_LVL_PK, INSTANCE INSTANCE, FORECAST_PRIORITY FORECAST_PRIORITY, TOTAL_QUANTITY_UOM TOTAL_QUANTITY_UOM, FORECAST_ERROR FORECAST_ERROR, DEMAND_CLASS DEMAND_CLASS, DEMAND_CLASS_LVL_ID DEMAND_CLASS_LVL_ID, DEMAND_CLASS_LVL_PK DEMAND_CLASS_LVL_PK, SCENARIO_NAME SCENARIO_NAME from "MSD"."MSD_DP_SCENARIO_ENTRIES"

View Text - HTML Formatted

SELECT DEMAND_PLAN_ID DEMAND_PLAN_ID
, SCENARIO_ID SCENARIO_ID
, ENTRY_ID ENTRY_ID
, QUANTITY QUANTITY
, AMOUNT AMOUNT
, BASELINE_QUANTITY BASELINE_QUANTITY
, BASELINE_AMOUNT BASELINE_AMOUNT
, TIME_LVL_ID TIME_LVL_ID
, TIME_LVL_VAL_FROM TIME_LVL_VAL_FROM
, TIME_LVL_VAL_TO TIME_LVL_VAL_TO
, PRODUCT_LVL_ID PRODUCT_LVL_ID
, PRODUCT_LVL_VAL PRODUCT_LVL_VAL
, GEOGRAPHY_LVL_ID GEOGRAPHY_LVL_ID
, GEOGRAPHY_LVL_VAL GEOGRAPHY_LVL_VAL
, CUSTOMER_LVL_ID CUSTOMER_LVL_ID
, CUSTOMER_LVL_VAL CUSTOMER_LVL_VAL
, SALESCHANNEL_LVL_ID SALESCHANNEL_LVL_ID
, SALESCHANNEL_LVL_VAL SALESCHANNEL_LVL_VAL
, SALES_REP_LVL_ID SALES_REP_LVL_ID
, SALES_REP_LVL_VAL SALES_REP_LVL_VAL
, ORGANIZATION_LVL_ID ORGANIZATION_LVL_ID
, ORGANIZATION_LVL_VAL ORGANIZATION_LVL_VAL
, USER_DEFINED1_LVL_ID USER_DEFINED1_LVL_ID
, USER_DEFINED1_LVL_VAL USER_DEFINED1_LVL_VAL
, USER_DEFINED2_LVL_ID USER_DEFINED2_LVL_ID
, USER_DEFINED2_LVL_VAL USER_DEFINED2_LVL_VAL
, PRIORITY PRIORITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PRODUCT_LVL_PK PRODUCT_LVL_PK
, GEOGRAPHY_LVL_PK GEOGRAPHY_LVL_PK
, CUSTOMER_LVL_PK CUSTOMER_LVL_PK
, SALESCHANNEL_LVL_PK SALESCHANNEL_LVL_PK
, SALES_REP_LVL_PK SALES_REP_LVL_PK
, ORGANIZATION_LVL_PK ORGANIZATION_LVL_PK
, USER_DEFINED1_LVL_PK USER_DEFINED1_LVL_PK
, USER_DEFINED2_LVL_PK USER_DEFINED2_LVL_PK
, REVISION REVISION
, PARENT_REVISION PARENT_REVISION
, COMMENTS COMMENTS
, ADJUSTMENT_REASON ADJUSTMENT_REASON
, DEPENDENT_QUANTITY DEPENDENT_QUANTITY
, TOTAL_QUANTITY TOTAL_QUANTITY
, BASELINE_DEPENDENT_QTY BASELINE_DEPENDENT_QTY
, BASELINE_TOTAL_QTY BASELINE_TOTAL_QTY
, SR_PRODUCT_LVL_PK SR_PRODUCT_LVL_PK
, SR_GEOGRAPHY_LVL_PK SR_GEOGRAPHY_LVL_PK
, SR_CUSTOMER_LVL_PK SR_CUSTOMER_LVL_PK
, SR_SALESCHANNEL_LVL_PK SR_SALESCHANNEL_LVL_PK
, SR_SALES_REP_LVL_PK SR_SALES_REP_LVL_PK
, SR_ORGANIZATION_LVL_PK SR_ORGANIZATION_LVL_PK
, SR_USER_DEFINED1_LVL_PK SR_USER_DEFINED1_LVL_PK
, SR_USER_DEFINED2_LVL_PK SR_USER_DEFINED2_LVL_PK
, INSTANCE INSTANCE
, FORECAST_PRIORITY FORECAST_PRIORITY
, TOTAL_QUANTITY_UOM TOTAL_QUANTITY_UOM
, FORECAST_ERROR FORECAST_ERROR
, DEMAND_CLASS DEMAND_CLASS
, DEMAND_CLASS_LVL_ID DEMAND_CLASS_LVL_ID
, DEMAND_CLASS_LVL_PK DEMAND_CLASS_LVL_PK
, SCENARIO_NAME SCENARIO_NAME
FROM "MSD"."MSD_DP_SCENARIO_ENTRIES"