Advertisement
tko_pb

risyal

Jun 1st, 2022
2,595
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select
  2.     value as FG, kst_part, componentvalue, qtybom,  
  3.     cu.name as uom, ispiping, m_product_category_value_fp,
  4.     '2021-01-01' as validFrom,
  5.     'ID' as countryCode,
  6.     '' as bpKey,
  7.     '' as "size",
  8.     '' as po_buyer,
  9.     'INDONESIA' as countryGroup,
  10.     case
  11.         when (m_product_category_value_fp = 'FB' or m_product_category_value_fp = 'WIP')  then 'SP-DM-515'
  12.         else 'SP-DM-516'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement