Advertisement
Guest User

Perbaikan Script Category WSC

a guest
Nov 9th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO m_product_ctgr_tree(tenant_id, product_ctgr_tree_code, product_ctgr_tree_name,
  2.             ctgr_parent_id, flg_use_attr, flg_serial_number, flg_warranty,
  3.             flg_lot, flg_barcode, flg_expired, flg_weight, flg_dimension,
  4.             flg_spec, flg_cust_info, flg_supp_info, flg_parts, flg_year_made,
  5.             flg_attr_confirmed, create_datetime, create_user_id, update_datetime,
  6.             update_user_id, version, active, active_datetime, non_active_datetime,
  7.             group_product_id)
  8.     VALUES (11,'A0315','TAS PINGGANG',(SELECT COALESCE(product_ctgr_tree_id, -99) FROM m_product_ctgr_tree WHERE product_ctgr_tree_code = 'A03'),'Y','N','N','N','Y','N','Y','Y','N','Y','Y','N','N','Y','20181108171500',-1,'20181108171500',-1,0,'Y','20181108171500','',-99),
  9.        (11,'I0212','BLUETOOTH HEADSET',(SELECT COALESCE(product_ctgr_tree_id, -99) FROM m_product_ctgr_tree WHERE product_ctgr_tree_code = 'I02'),'Y','N','N','N','Y','N','Y','Y','N','Y','Y','N','N','Y','20181108171500',-1,'20181108171500',-1,0,'Y','20181108171500','',-99);
  10. INSERT INTO m_product_ctgr_tree_code_size(
  11.             product_ctgr_tree_code, size,
  12.             create_datetime, create_user_id, update_datetime, update_user_id,
  13.             version, active, active_datetime, non_active_datetime)
  14.     VALUES ('A0315','NONE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700',''),
  15.        ('A0315','ALL SIZE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700',''),
  16.        ('I0212','ALL SIZE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700',''),
  17.        ('I0212','NONE','20181108172700',-1,'20181108172700',-1,0,'Y','20181108172700','');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement