Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- 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
- INNER JOIN pu_po c ON b.tenant_id = c.tenant_id AND b.po_id = c.po_id
- INNER JOIN m_product d ON d.tenant_id = b.tenant_id AND d.product_id = b.product_id
- INNER JOIN t_user_role e ON e.user_id = :userLoginId AND e.role_id = :roleLoginId
- 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
- WHERE a.tenant_id = :tenantId
- AND c.ou_id = :ouId
- AND c.po_id = :poId
- AND a.status_item = :RELEASED
- AND a.qty_po - a.qty_rcv - a.qty_cancel + a.qty_add > 0
- GROUP BY b.po_item_id , c.po_id, d.product_id
- ORDER BY b.line_no
Advertisement
Add Comment
Please, Sign In to add comment