Product: | MSD - Demand Planning |
---|---|
Description: | This view to display Scenario Entries comments |
Implementation/DBA Data: | APPS.MSD_SCN_ENTRY_COMMENTS_V |
SELECT SC.DEMAND_PLAN_ID
, SC.SCENARIO_ID
, SC.REVISION
, SC.COMMENT_ID
, CM.COMMENT_TEXT
, CM.REASON_ID
, RS.REASON_CODE
, SC.TIM_LVL_ID
, SC.TIM_LVL_VAL
, SC.PRD_LVL_PK
, SC.GEO_LVL_PK
, SC.CHN_LVL_PK
, SC.REP_LVL_PK
, SC.ORG_LVL_PK
, SC.UD1_LVL_PK
, SC.UD2_LVL_PK
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
, SC.CREATION_DATE
, SC.CREATED_BY
FROM MSD_COMMENTS CM
, MSD_REASON_CODES RS
, MSD_SCN_ENTRY_COMMENTS SC
WHERE SC.DEMAND_PLAN_ID = CM.DEMAND_PLAN_ID
AND SC.SCENARIO_ID = CM.SCENARIO_ID
AND SC.REVISION = CM.REVISION
AND SC.COMMENT_ID = CM.COMMENT_ID
AND SC.DEMAND_PLAN_ID = RS.DEMAND_PLAN_ID
AND SC.SCENARIO_ID = RS.SCENARIO_ID
AND SC.REVISION = RS.REVISION
AND RS.REASON_ID = CM.REASON_ID