-- apps_transaction.sp_GetVariationProdPerOutletB2B_PerformanceHA (PROCEDURE)
begin
select ht.OutletID, ProductTypeClass, count(dt.ProductID) as TotalProduct
from apps_transaction.header_transaction_owner1 ht 
left join apps_transaction.detail_transaction_owner dt on ht.OrderID = dt.OrderID
left join apps_master.m_product1 p on dt.ProductID = p.ProductID
WHERE ht.OutletID = OutID 
AND MONTH(OrderDate) = MONTH(CURRENT_DATE()) AND YEAR(OrderDate) = YEAR(CURRENT_DATE()) AND ProductTypeClass IS NOT NULL
GROUP BY p.ProductTypeClass
order by ProductTypeClass asc;
end