-- apps_transaction.getListConfirmation (PROCEDURE)
begin
SELECT dplo.Qty, mp.ProductName, mp.ProductID FROM apps_transaction.detail_packing_list_owner dplo
LEFT JOIN apps_master.m_product1 mp ON mp.ProductID = dplo.ProductID
WHERE PLNumber = plNumber1;
end