-- century_emember.sp_SelectCartDetail (PROCEDURE)
begin
	SELECT 	d.*, p.Pro_Name, Pro_SellPrice,
		CASE WHEN SalePrice != Pro_SellPrice THEN 'Y'
		ELSE 'N' END AS flagHargaGanti,
		ifnull((d.Qty*DiscCen),0) as DiscCen, 
		ifnull((d.Qty * DiscMember),0) as DiscMember, 
		ifnull((d.Qty * DiscSup),0) as DiscSup,
		ifnull(d.Qty * (d.SalePrice - DiscCen - DiscMember - DiscSup), 0) as SubTotalPrice,
		ifnull((d.Qty *(DiscCen + DiscMember + DiscSup)) , 0)AS TotalDiscount
	FROM century_emember.Cart_Detail d 
	LEFT JOIN Master_centuryApp.MH_Product p ON p.Pro_Code = d.Procod
	LEFT JOIN Master_centuryApp.MD_Product dp ON dp.Pro_Code = p.Pro_Code
	WHERE CartNo = cartNo
	group by d.Procod;
end