VIEW: APPS.MSD_SCN_ENTRY_COMMENTS_V

Source

View Text - Preformatted

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.DCS_LVL_PK, sc.UD1_LVL_PK, sc.UD2_LVL_PK, sc.LAST_UPDATE_DATE, sc.LAST_UPDATED_BY, sc.CREATION_DATE, sc.CREATED_BY, cm.OWNER, cm.DUE_DATE, cm.STATUS, cm.TYPE 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

View Text - HTML Formatted

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.DCS_LVL_PK
, SC.UD1_LVL_PK
, SC.UD2_LVL_PK
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATED_BY
, SC.CREATION_DATE
, SC.CREATED_BY
, CM.OWNER
, CM.DUE_DATE
, CM.STATUS
, CM.TYPE
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