Untitled

-- jsamdm_dev.mdm_downstream_record_view source

CREATE OR REPLACE
ALGORITHM = UNDEFINED VIEW `mdm_downstream_record_view` AS
select
    `mdp`.`MDM_ID` AS `MDM_ID_2`,
    max(if((`mdp`.`DWN_STRM_ID` = '7'), 'Y', NULL)) AS `DWN_7`,
    max(if((`mdp`.`DWN_STRM_ID` = '8'), 'Y', NULL)) AS `DWN_8`
from
    `mdm_downstream_product` `mdp`
group by
    `mdp`.`MDM_ID`;