VIEW: APPS.MSD_DP_SCE_SCN_ENTRIES_V

Source

View Text - Preformatted

SELECT mdse.demand_plan_id, mdse.scenario_id, mdse.time_lvl_id, mdse.time_lvl_val_from, mdse.time_lvl_val_to, mdse.total_quantity, to_number(decode(ltrim(mdse.sr_organization_lvl_pk, '.0123456789'), null, mdse.sr_organization_lvl_pk, -1)) sr_organization_lvl_pk, to_number(decode(ltrim(mdse.sr_geography_lvl_pk, '.0123456789'), null, mdse.sr_geography_lvl_pk, -1)) sr_geography_lvl_pk, to_number(decode(ltrim(mdse.sr_product_lvl_pk, '.0123456789'), null, mdse.sr_product_lvl_pk, -1)) sr_product_lvl_pk, to_number(mdse.instance), mdse.total_quantity_uom FROM msd_dp_scenario_entries mdse, msd_dp_scenarios ds WHERE mdse.demand_plan_id = ds.demand_plan_id and mdse.scenario_id = ds.scenario_id and mdse.ORGANIZATION_LVL_ID = 7 and mdse.PRODUCT_LVL_ID = 1 and mdse.GEOGRAPHY_LVL_ID = 11 and mdse.revision = ds.last_revision

View Text - HTML Formatted

SELECT MDSE.DEMAND_PLAN_ID
, MDSE.SCENARIO_ID
, MDSE.TIME_LVL_ID
, MDSE.TIME_LVL_VAL_FROM
, MDSE.TIME_LVL_VAL_TO
, MDSE.TOTAL_QUANTITY
, TO_NUMBER(DECODE(LTRIM(MDSE.SR_ORGANIZATION_LVL_PK
, '.0123456789')
, NULL
, MDSE.SR_ORGANIZATION_LVL_PK
, -1)) SR_ORGANIZATION_LVL_PK
, TO_NUMBER(DECODE(LTRIM(MDSE.SR_GEOGRAPHY_LVL_PK
, '.0123456789')
, NULL
, MDSE.SR_GEOGRAPHY_LVL_PK
, -1)) SR_GEOGRAPHY_LVL_PK
, TO_NUMBER(DECODE(LTRIM(MDSE.SR_PRODUCT_LVL_PK
, '.0123456789')
, NULL
, MDSE.SR_PRODUCT_LVL_PK
, -1)) SR_PRODUCT_LVL_PK
, TO_NUMBER(MDSE.INSTANCE)
, MDSE.TOTAL_QUANTITY_UOM
FROM MSD_DP_SCENARIO_ENTRIES MDSE
, MSD_DP_SCENARIOS DS
WHERE MDSE.DEMAND_PLAN_ID = DS.DEMAND_PLAN_ID
AND MDSE.SCENARIO_ID = DS.SCENARIO_ID
AND MDSE.ORGANIZATION_LVL_ID = 7
AND MDSE.PRODUCT_LVL_ID = 1
AND MDSE.GEOGRAPHY_LVL_ID = 11
AND MDSE.REVISION = DS.LAST_REVISION