[Home] [Help]
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
Name |
DEMAND_PLAN_ID |
SCENARIO_ID |
BUCKET_TYPE |
START_DATE |
END_DATE |
QUANTITY |
SR_ORGANIZATION_ID |
SR_GEOGRAPHY_ID |
SR_INVENTORY_ITEM_ID |
SR_INSTANCE_ID |
UOM_CODE |