Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN;
- INSERT INTO tt_migrate_product (session_id,flg_validate,flg_migrate,record_owner_id,product_code,product_name,product_local_name,product_ctgr_code,part_no,brand_name,color,style_product,class_product,minimum_stock_level,image_url,weight,length,height,width,sell_price,supplier_code,supplier_product_code,supplier_product_name,supplier_price,previous_supplier_price,valid_since_date,active_date,create_datetime, create_username, update_datetime, update_username, version,message) values
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB2LAK6201APZ','BEARING ACELINE 6201-2RS POLOS','BEARING 2RS POLOS','BEARING','6203-2RS','','','','','0','','0','0','0','0','120000','182-CAR','FB2LAK6201APZ','BEARING ACELINE 6201-2RS POLOS','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4KBGA007SAZ','ACCELERATOR CABLE BU-30 SAIWA 78150-95448','ACCELERATOR CABLE BU-30 SAIWA','CABLE','78150-95448','SAIWA','','','','0','','0','0','0','0','120000','182-CAR','FB4KBGA007SAZ','ACCELERATOR CABLE BU-30 SAIWA 78150-95448','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4KBGA055SAZ','ACCELERATOR CABLE FE-111,PS-100 SAIWA MB-160040','ACCELERATOR CABLE FE-111PS-100 SAIWA','CABLE','MB-160040','SAIWA','','','','570','','0','0','0','0','120000','182-CAR','FB4KBGA055SAZ','ACCELERATOR CABLE FE-111,PS-100 SAIWA MB-160040','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ABTK03100Z','AIR BOOSTER KIT HINO TRONTON TW 9323-3512','AIR BOOSTER KIT HINO TRONTON TW','AIR BOOSTER KIT','9323-3512','TW','','','','0','','0','0','0','0','120000','182-CAR','FB4ABTK03100Z','AIR BOOSTER KIT HINO TRONTON TW 9323-3512','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB2AFIL930HTZ','AIR FILTER BEAT FI HTS 17210-K16-900','AIR FILTER BEAT FI HTS','AIR FILTER','17210-K16-900','HTS','','','','0','','0','0','0','0','120000','182-CAR','FB2AFIL930HTZ','AIR FILTER BEAT FI HTS 17210-K16-900','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ALTA153NCZ','ALTERNATOR ASSY S-89 12V 45A NEPCO 27060-87507','ALTERNATOR ASSY S-89 12V 45A NEPCO','ALTERNATOR ASSY','27060-87507','NEPCO','','','','0','','0','0','0','0','120000','182-CAR','FB4ALTA153NCZ','ALTERNATOR ASSY S-89 12V 45A NEPCO 27060-87507','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ALTA202NCZ','ALTERNATOR ASSY ST-100 12V 20A NEPCO 27060-78300-1','ALTERNATOR ASSY ST-100 12V 20A NEPCO','ALTERNATOR ASSY','27060-78300-1','NEPCO','','','','0','','0','0','0','0','120000','182-CAR','FB4ALTA202NCZ','ALTERNATOR ASSY ST-100 12V 20A NEPCO 27060-78300-1','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ANST054NCZ','ANGKER STATER (ARMATURE W/ BEARING) FE,PS-100 NEPCO M106X29371','ANGKER STATER (ARMATURE W/ BEARING) FE,PS-100 NEPCO','ARMATURE','M106X29371','NEPCO','','','','0','','0','0','0','0','120000','182-CAR','FB4ANST054NCZ','ANGKER STATER (ARMATURE W/ BEARING) FE,PS-100 NEPCO M106X29371','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ANSTL54NCZ','ANGKER STATER (ARMATURE W/ BEARING) FE-OLD/PS ENGKEL TURBO NEPCO IM3040','ANGKER STATER (ARMATURE W/ BEARING) FE-OLD/PS ENGKEL TURBO NEPCO','ARMATURE','IM3040','NEPCO','','','','0','','0','0','0','0','120000','182-CAR','FB4ANSTL54NCZ','ANGKER STATER (ARMATURE W/ BEARING) FE-OLD/PS ENGKEL TURBO NEPCO IM3040','100000','90000','22072012','22102018','20180622142310','herry','20180622142310','herry','0','')
- select fs_validate_product('035fdda6-f0b1-4475-af4d-09ac8865e79b',73,'Herry','20180622142310');
- select * from tt_migrate_product where create_datetime = '20180622142310' and create_username = 'herry'
- select fs_migrate_product('035fdda6-f0b1-4475-af4d-09ac8865e79b',73,'Herry','20180622142310');
- select * from mstr.m_product where product_code
- IN ('FB2LAK6201APZ','FB4KBGA007SAZ','FB4KBGA055SAZ','FB4ABTK03100Z','FB2AFIL930HTZ','FB4ALTA153NCZ','FB4ALTA202NCZ','FB4ANST054NCZ','FB4ANSTL54NCZ')
- select * from mstr.m_product_dimension where product_id IN ('56895','56896','56897','56898','56899','56900','56901','56902','56883')
- select * from mstr.m_product_supp_info where product_id IN ('56877','56878','56879','56880','56881','56882','56883','56884','56885')
- select * from mstr.m_sell_price_level where product_id IN ('56877','56878','56879','56880','56881','56882','56883','56884','56885')
- select * from batch.in_product_balance where product_id IN ('56895','56896','56897','56898','56899','56900','56901','56902','56883')
- INSERT INTO tt_migrate_product_stock(session_id,flg_validate,flg_migrate,record_owner_id,product_code,qty,ref_doc_no,ref_doc_date,create_datetime,create_username,update_datetime,update_username, version, message) VALUES
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB2LAK6201APZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4KBGA007SAZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4KBGA055SAZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ABTK03100Z','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB2AFIL930HTZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ALTA153NCZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ALTA202NCZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ANST054NCZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0',''),
- ('035fdda6-f0b1-4475-af4d-09ac8865e79b','I','N','73','FB4ANSTL54NCZ','100','SALDO AWAL','20180620','20180620172600','herry','20180620172600','herry','0','')
- SELECT fs_validate_product_stock('035fdda6-f0b1-4475-af4d-09ac8865e79b', 73, 'herry', '20180620172600');
- SELECT * FROM tt_migrate_product_stock where create_datetime = '20180620172600'
- SELECT fs_migrate_product_stock('035fdda6-f0b1-4475-af4d-09ac8865e79b', 73, 'herry', '20180620172600');
- SELECT * FROM batch.in_product_balance_stock where product_id = 56895
- -- Untuk cek ke table in_log_product_balance_stock
- SELECT * FROM batch.in_log_product_balance_stock where product_id = 56895
- -- Untuk cek ke table in_summary_monthly_qty
- SELECT * FROM batch.in_summary_monthly_qty where product_id = 56895
- ROLLBACK;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement