Advertisement
Evra70

aaa

Dec 7th, 2021
1,166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT f_get_ou_code(A.ou_id) ou,f_get_warehouse_name(A.warehouse_id) warehouse,
  2. f_get_product_code(A.product_id) code,f_get_product_name(A.product_id) nama ,A.qty
  3. FROM in_summary_monthly_qty A
  4. INNER JOIN m_product B ON A.product_id = B.product_id
  5. WHERE doc_type_id <> -99
  6. AND date_year_month = '202111'
  7. AND warehouse_id = 22
  8. AND b.product_code IN (
  9. 'BST 251',
  10. 'DLP 002',
  11. 'DLP 081',
  12. 'DLP 169',
  13. 'DLP 172',
  14. 'DLP 173',
  15. 'DLP 174',
  16. 'EFO 003',
  17. 'FAL 011',
  18. 'FIL 042',
  19. 'GTL 002',
  20. 'GTL 003',
  21. 'GTL 005',
  22. 'GTR 164',
  23. 'HKK 061',
  24. 'OLI 070'
  25. )
  26. ORDER BY code asc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement