VIEW: APPS.MSD_INPUT_SCENARIO_DS_V

Source

View Text - Preformatted

SELECT mdse.DEMAND_PLAN_ID, mds.demand_plan_id, mdse.SCENARIO_ID, mdse.REVISION, mdse.ORGANIZATION_LVL_PK , mdse.PRODUCT_LVL_PK, mdse.CUSTOMER_LVL_PK, mdse.SALESCHANNEL_LVL_PK, mdse.SALES_REP_LVL_PK, mdse.GEOGRAPHY_LVL_PK, mdse.USER_DEFINED1_LVL_PK, mdse.USER_DEFINED2_LVL_PK, mdse.DEMAND_CLASS_LVL_PK, mdse.TIME_LVL_VAL_TO, mdse.ORGANIZATION_LVL_ID, mdse.PRODUCT_LVL_ID, mdse.CUSTOMER_LVL_ID, mdse.SALESCHANNEL_LVL_ID, mdse.SALES_REP_LVL_ID, mdse.GEOGRAPHY_LVL_ID, mdse.USER_DEFINED1_LVL_ID, mdse.USER_DEFINED2_LVL_ID, mdse.DEMAND_CLASS_LVL_ID, mdse.TIME_LVL_ID, mdse.QUANTITY, mdse.AMOUNT from MSD_DP_SCENARIO_ENTRIES mdse, msd_level_values_ds mlvd1, msd_level_values_ds mlvd2, msd_level_values_ds mlvd3, msd_level_values_ds mlvd4, msd_level_values_ds mlvd5, msd_level_values_ds mlvd6, msd_level_values_ds mlvd7, msd_level_values_ds mlvd8, msd_level_values_ds mlvd9, msd_dp_session mds WHERE mlvd1.demand_plan_id = mds.demand_plan_id and mlvd1.level_pk = mdse.ORGANIZATION_LVL_PK and mlvd2.demand_plan_id = mds.demand_plan_id and mlvd2.level_pk = mdse.PRODUCT_LVL_PK and mlvd3.demand_plan_id = mds.demand_plan_id and mlvd3.level_pk = mdse.CUSTOMER_LVL_PK and mlvd4.demand_plan_id = mds.demand_plan_id and mlvd4.level_pk = mdse.SALESCHANNEL_LVL_PK and mlvd5.demand_plan_id = mds.demand_plan_id and mlvd5.level_pk = mdse.SALES_REP_LVL_PK and mlvd6.demand_plan_id = mds.demand_plan_id and mlvd6.level_pk = mdse.GEOGRAPHY_LVL_PK and mlvd7.demand_plan_id = mds.demand_plan_id and mlvd7.level_pk = mdse.USER_DEFINED1_LVL_PK and mlvd8.demand_plan_id = mds.demand_plan_id and mlvd8.level_pk = mdse.USER_DEFINED2_LVL_PK and mlvd9.demand_plan_id = mds.demand_plan_id and mlvd9.level_pk = mdse.DEMAND_CLASS_LVL_PK

View Text - HTML Formatted

SELECT MDSE.DEMAND_PLAN_ID
, MDS.DEMAND_PLAN_ID
, MDSE.SCENARIO_ID
, MDSE.REVISION
, MDSE.ORGANIZATION_LVL_PK
, MDSE.PRODUCT_LVL_PK
, MDSE.CUSTOMER_LVL_PK
, MDSE.SALESCHANNEL_LVL_PK
, MDSE.SALES_REP_LVL_PK
, MDSE.GEOGRAPHY_LVL_PK
, MDSE.USER_DEFINED1_LVL_PK
, MDSE.USER_DEFINED2_LVL_PK
, MDSE.DEMAND_CLASS_LVL_PK
, MDSE.TIME_LVL_VAL_TO
, MDSE.ORGANIZATION_LVL_ID
, MDSE.PRODUCT_LVL_ID
, MDSE.CUSTOMER_LVL_ID
, MDSE.SALESCHANNEL_LVL_ID
, MDSE.SALES_REP_LVL_ID
, MDSE.GEOGRAPHY_LVL_ID
, MDSE.USER_DEFINED1_LVL_ID
, MDSE.USER_DEFINED2_LVL_ID
, MDSE.DEMAND_CLASS_LVL_ID
, MDSE.TIME_LVL_ID
, MDSE.QUANTITY
, MDSE.AMOUNT
FROM MSD_DP_SCENARIO_ENTRIES MDSE
, MSD_LEVEL_VALUES_DS MLVD1
, MSD_LEVEL_VALUES_DS MLVD2
, MSD_LEVEL_VALUES_DS MLVD3
, MSD_LEVEL_VALUES_DS MLVD4
, MSD_LEVEL_VALUES_DS MLVD5
, MSD_LEVEL_VALUES_DS MLVD6
, MSD_LEVEL_VALUES_DS MLVD7
, MSD_LEVEL_VALUES_DS MLVD8
, MSD_LEVEL_VALUES_DS MLVD9
, MSD_DP_SESSION MDS
WHERE MLVD1.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD1.LEVEL_PK = MDSE.ORGANIZATION_LVL_PK
AND MLVD2.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD2.LEVEL_PK = MDSE.PRODUCT_LVL_PK
AND MLVD3.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD3.LEVEL_PK = MDSE.CUSTOMER_LVL_PK
AND MLVD4.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD4.LEVEL_PK = MDSE.SALESCHANNEL_LVL_PK
AND MLVD5.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD5.LEVEL_PK = MDSE.SALES_REP_LVL_PK
AND MLVD6.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD6.LEVEL_PK = MDSE.GEOGRAPHY_LVL_PK
AND MLVD7.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD7.LEVEL_PK = MDSE.USER_DEFINED1_LVL_PK
AND MLVD8.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD8.LEVEL_PK = MDSE.USER_DEFINED2_LVL_PK
AND MLVD9.DEMAND_PLAN_ID = MDS.DEMAND_PLAN_ID
AND MLVD9.LEVEL_PK = MDSE.DEMAND_CLASS_LVL_PK