View: MSD_DP_ASCP_SCENARIOS_V

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

View Text

SELECT DS.DEMAND_PLAN_ID
, DP.DEMAND_PLAN_NAME
, DS.SCENARIO_ID
, DS.SCENARIO_NAME
, DP.ORGANIZATION_ID
, DP.SR_INSTANCE_ID
, MDSR.ERROR_TYPE
, DS.CONSUME_FLAG
FROM MSD_DP_SCENARIOS DS
, MSD_DEMAND_PLANS DP
, MSD_DP_SCENARIO_REVISIONS MDSR
WHERE DS.DEMAND_PLAN_ID = DP.DEMAND_PLAN_ID
AND DS.PUBLISH_FLAG = 'Y'
AND MDSR.SCENARIO_ID = DS.SCENARIO_ID
AND MDSR.REVISION = DS.LAST_REVISION
AND DS.LAST_REVISION IS NOT NULL /* ITEM OR PRODUCT FAMILY LEVEL */
AND EXISTS(SELECT 1
FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL
WHERE OL.DEMAND_PLAN_ID = DS.DEMAND_PLAN_ID
AND OL.SCENARIO_ID = DS.SCENARIO_ID
AND OL.LEVEL_ID IN (1
, 3)) /* ORGANIZATION LEVEL */
AND EXISTS(SELECT 1
FROM MSD_DP_SCENARIO_OUTPUT_LEVELS OL
WHERE OL.DEMAND_PLAN_ID = DS.DEMAND_PLAN_ID
AND OL.SCENARIO_ID = DS.SCENARIO_ID
AND OL.LEVEL_ID = 7)

Columns