DROP VIEW LD0V0PROCESSSTEPCOMPONENTMAPPINGDETAILS
;
CREATE VIEW LD0V0PROCESSSTEPCOMPONENTMAPPINGDETAILS AS 
SELECT CM.*,DM.DOCUMENTTYPEOID,DM.DOCUMENTTYPEDESCRIPTION FROM LD0P0PROCESSSTEPCOMPONENTMAPPING CM 
LEFT JOIN LD0P0STEPDOCUMENTTYPEMAPPING DM ON CM.ID = DM.STEPCOMPONENTMAPPINGID
;