summaryrefslogtreecommitdiff
path: root/fixco_custom
diff options
context:
space:
mode:
Diffstat (limited to 'fixco_custom')
-rw-r--r--fixco_custom/models/purchasing_job.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/fixco_custom/models/purchasing_job.py b/fixco_custom/models/purchasing_job.py
index 5d37c8c..360beba 100644
--- a/fixco_custom/models/purchasing_job.py
+++ b/fixco_custom/models/purchasing_job.py
@@ -106,7 +106,7 @@ class PurchasingJob(models.Model):
pmp.product_id,
pmp.brand_id,
pmp.vendor_id
- FROM v_procurement_monitoring_by_product pmp
+ FROM v_procurement_monitoring_by_product_v2 pmp
WHERE pmp.action = 'kurang'::text
GROUP BY pmp.product_id, pmp.item_code, pmp.action, pmp.brand_id, pmp.vendor_id;
""" % self._table)