View: MSD_DP_SCE_SCN_ENTRIES_V

Product:	MSD - Demand Planning
Description:	This view provides the integration api with ASCP for scenario entries
Implementation/DBA Data:	APPS.MSD_DP_SCE_SCN_ENTRIES_V

View Text

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

Columns