Evra70

eo

Dec 7th, 2021
769
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. select
  3.     A.product_id,
  4.     f_get_product_code(A.product_id) code,f_get_product_name(A.product_id) nama ,
  5. f_get_warehouse_name(A.warehouse_id) warehouse,
  6.     A.warehouse_id,
  7.     SUM(A.qty) qty
  8. from in_log_product_balance_stock A
  9. inner join m_product B On A.product_id = B.product_id
  10. WHERE  A.warehouse_id = 22 AND A.ou_id = 17
  11. AND b.product_code IN (
  12. 'BST 251',
  13. 'DLP 002',
  14. 'DLP 081',
  15. 'DLP 169',
  16. 'DLP 172',
  17. 'DLP 173',
  18. 'DLP 174',
  19. 'EFO 003',
  20. 'FAL 011',
  21. 'FIL 042',
  22. 'GTL 002',
  23. 'GTL 003',
  24. 'GTL 005',
  25. 'GTR 164',
  26. 'HKK 061',
  27. 'OLI 070'
  28. )
  29. group by A.product_id,A.warehouse_id
  30. order by code asc
RAW Paste Data