Evra70

aaaaa

Dec 7th, 2021
862
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
  7. date_year_month = '202111'
  8. AND warehouse_id = 22
  9. AND b.product_code IN (
  10. 'BST 251',
  11. 'DLP 002',
  12. 'DLP 081',
  13. 'DLP 169',
  14. 'DLP 172',
  15. 'DLP 173',
  16. 'DLP 174',
  17. 'EFO 003',
  18. 'FAL 011',
  19. 'FIL 042',
  20. 'GTL 002',
  21. 'GTL 003',
  22. 'GTL 005',
  23. 'GTR 164',
  24. 'HKK 061',
  25. 'OLI 070'
  26. )
  27. ORDER BY code asc
  28.  
  29.  
RAW Paste Data