widana

GetPurchaseOrderItemListForKonsinyasiManual

Jan 20th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT b.po_item_id, b.line_no, b.product_id, c.po_id, c.remark, d.product_code, d.product_name, COALESCE(SUM(f.qty_so),0) AS qty_so , COALESCE(SUM(f.qty_posted),0) AS qty_posted
  2. FROM pu_po_balance_item a INNER JOIN pu_po_item b ON a.tenant_id = b.tenant_id AND a.po_item_id = b.po_item_id
  3. INNER JOIN pu_po c ON b.tenant_id = c.tenant_id AND b.po_id = c.po_id
  4. INNER JOIN m_product d ON d.tenant_id = b.tenant_id AND d.product_id = b.product_id
  5. INNER JOIN t_user_role e ON e.user_id = :userLoginId AND e.role_id = :roleLoginId
  6. LEFT JOIN pu_po_balance_item_consignment_sold_manual f ON b.tenant_id = f.tenant_id AND b.po_item_id = f.po_item_id
  7. WHERE a.tenant_id = :tenantId
  8. AND c.ou_id = :ouId
  9. AND c.po_id = :poId
  10. AND a.status_item = :RELEASED
  11. AND a.qty_po - a.qty_rcv - a.qty_cancel + a.qty_add > 0
  12. GROUP BY b.po_item_id , c.po_id, d.product_id
  13. ORDER BY b.line_no
Advertisement
Add Comment
Please, Sign In to add comment