-- apps_master.inRecommendationProductNeverBought (PROCEDURE)
begin
INSERT INTO recommendation_product_outlet_showed(ProductID, OutletID, UpdatedBy, QtyPurchased, SalesProduct, ActiveYN)
VALUES (productID1, outletID1 , updatedBy1, qtyPurchased, productSales,'Y');
end