COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

[ Date: 2023-12-02 09:08:13 ]

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

[ Date: 2023-12-02 09:02:53 ]

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

[ Date: 2023-12-02 09:04:25 ]

COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;

[ Date: 2023-12-02 09:11:27 ]

DELETE FROM account_move_line WHERE id IN (3702577, 3702578, 3702579, 3702580, 3702581, 3702582, 3702583, 3702584, 3702585, 3702586, 3702587, 3702588, 3702589, 3702590, 3702591, 3702592, 3702593, 3702594, 3702595, 3702596, 3702597, 3702598, 3702599, 3702600, 3702601, 3717575, 3717576);

[ Date: 2023-12-02 06:08:47 ]

COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;

[ Date: 2023-12-02 09:10:36 ]

COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile) TO stdout;

[ Date: 2023-12-02 09:00:37 ]

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id) TO stdout;

[ Date: 2023-12-02 09:09:33 ]

DELETE FROM account_move_line WHERE id IN (3691814, 3691815, 3691816, 3691817, 3691818, 3691819, 3691820, 3691821, 3691822, 3691823, 3691824, 3691825, 3709842, 3709843);

[ Date: 2023-12-02 06:07:09 ]

with data as ( select distinct shl.id as record, 3808, shl.id as ref, 'Sales History' as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_history_line as shl LEFT JOIN stock_warehouse as st ON st.branch_id = shl.selling_branch LEFT JOIN product_product as pp ON pp.id = shl.product_id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id where shl.selling_branch = 45 and shl.sales_obtain != 'direct' and shl.product_id is not null and shl.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and shl.invoice_date >= '2017-12-02 00:00:00' and shl.invoice_date <= '2023-12-02 00:00:00' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150, 3291) and pp.id not in (189318, 173241, 202632, 202640, 209210, 183363, 202635, 193055, 193528, 193529, 202477, 193565, 187918, 202653, 209518, 209382, 209267, 209269, 209281, 209329, 209339, 209199, 209182, 209201, 209219, 209413, 209414, 209457, 209466, 209482, 209488, 177924, 177926, 209344, 209561, 193359, 193405, 209318, 209225, 209305, 209559, 193620, 188461, 183353, 209203, 209418, 209357, 189042, 248827, 209255, 209176, 209513, 183350, 209470, 209282, 209332, 209189, 209202, 209427, 209471, 209479, 209519, 209521, 216289, 177872, 177949, 209390, 209256, 209254, 216830, 206656, 209421, 209517, 209356, 187791, 177876, 177890, 209379, 183351, 209268, 209190, 209562, 244119, 177743, 192904, 209261, 209259, 215693, 209227, 209352, 209370, 209392, 209415, 209537, 209456, 193698, 209187, 209235, 209319, 209193, 209195, 177947, 177894, 177886, 177948, 209333, 190764, 209233, 203674, 213509, 209188, 189041, 209226, 209253, 209503, 209526, 209569, 172604, 177899, 177887, 239388, 177896, 209374, 209469, 176822, 209308, 177747, 209312, 209243, 209323, 209228, 213768, 209179, 209265, 209271, 209316, 209322, 209325, 209416, 209462, 186294, 193666, 215733, 209241, 209250, 209206, 209468, 209326, 209207, 209220, 209358, 209425, 209422, 177882, 209331, 209360, 209398, 209538, 209563, 204056, 209232, 209270, 209277, 209284, 209298, 209307, 209309, 209180, 209194, 209183, 209177, 209186, 209396, 209412, 209434, 209440, 209441, 209459, 209484, 209497, 209510, 209512, 209520, 209935, 209475, 209327, 209181, 209315, 177900, 213767, 209560, 209278, 209279, 209314, 209423, 209452, 209460, 209365, 209435, 188924, 245930, 177853, 209380, 193113, 202577, 209334, 183364, 209200, 203690, 209335, 177893, 186845, 193508, 209372, 209362, 209320, 209381, 209299, 187848, 209491, 209507, 258629, 253947, 259262, 249176, 209566, 209487, 190979, 209244, 209247, 209280, 209317, 209342, 209172, 209173, 209174, 209185, 209192, 209197, 209393, 209424, 209436, 209451, 209464, 209480, 209485, 209494, 209509, 209514, 209571, 177861, 177873, 250980, 186233, 186232, 209573, 209378, 209234, 209506, 209554, 209346, 209258, 193625, 204975, 177891, 209565, 177927, 209236, 209328, 209330, 190984, 209238, 209239, 209178, 209472, 209433, 209473, 209493, 209515, 209209, 238976, 177917, 215132, 203681, 209528, 209495, 209501, 209524, 192957, 209242, 209273, 209214, 218167, 209389, 193109, 216288, 193209, 177880, 177884, 209313, 193509, 217801, 202634, 188425, 209570, 209545, 209384, 209221, 209257, 209198, 209211, 209216, 209394, 209505, 209546, 209567, 202687, 209502, 202652, 253188, 209251, 209311, 209347, 209361, 209366, 209516, 209527, 209529, 209572, 186298, 209184, 186295, 209245, 177892, 217925, 176416, 210627, 219448, 209266, 209303, 209304, 209306, 209310, 209338, 209343, 209345, 209175, 209196, 209367, 209437, 209438, 209442, 209446, 209474, 209483, 209492, 209568, 209340, 234379, 176679, 197918, 177885, 209359, 209391, 209556, 209558, 193110, 177878, 177908, 209302, 209403, 190710, 214111, 209262, 209229, 209230, 209252, 209263, 209286, 209324, 209212, 193111, 209439, 209511, 209525, 209555, 209246, 209321, 177922, 193569, 189018, 209191, 209496, 209447, 240858, 177857, 223745, 188430, 258628, 209354, 209272, 193114, 193215, 209231, 209276, 209260, 208831, 219982, 209264, 209430) UNION ALL ( select distinct sol.id as record, 3808, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 45 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and so.date_order >= '2017-12-02 00:00:00' and so.date_order <= '2023-12-02 00:00:00' and so.state in ('permanent_order') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150, 3291) and pp.id not in (189318, 173241, 202632, 202640, 209210, 183363, 202635, 193055, 193528, 193529, 202477, 193565, 187918, 202653, 209518, 209382, 209267, 209269, 209281, 209329, 209339, 209199, 209182, 209201, 209219, 209413, 209414, 209457, 209466, 209482, 209488, 177924, 177926, 209344, 209561, 193359, 193405, 209318, 209225, 209305, 209559, 193620, 188461, 183353, 209203, 209418, 209357, 189042, 248827, 209255, 209176, 209513, 183350, 209470, 209282, 209332, 209189, 209202, 209427, 209471, 209479, 209519, 209521, 216289, 177872, 177949, 209390, 209256, 209254, 216830, 206656, 209421, 209517, 209356, 187791, 177876, 177890, 209379, 183351, 209268, 209190, 209562, 244119, 177743, 192904, 209261, 209259, 215693, 209227, 209352, 209370, 209392, 209415, 209537, 209456, 193698, 209187, 209235, 209319, 209193, 209195, 177947, 177894, 177886, 177948, 209333, 190764, 209233, 203674, 213509, 209188, 189041, 209226, 209253, 209503, 209526, 209569, 172604, 177899, 177887, 239388, 177896, 209374, 209469, 176822, 209308, 177747, 209312, 209243, 209323, 209228, 213768, 209179, 209265, 209271, 209316, 209322, 209325, 209416, 209462, 186294, 193666, 215733, 209241, 209250, 209206, 209468, 209326, 209207, 209220, 209358, 209425, 209422, 177882, 209331, 209360, 209398, 209538, 209563, 204056, 209232, 209270, 209277, 209284, 209298, 209307, 209309, 209180, 209194, 209183, 209177, 209186, 209396, 209412, 209434, 209440, 209441, 209459, 209484, 209497, 209510, 209512, 209520, 209935, 209475, 209327, 209181, 209315, 177900, 213767, 209560, 209278, 209279, 209314, 209423, 209452, 209460, 209365, 209435, 188924, 245930, 177853, 209380, 193113, 202577, 209334, 183364, 209200, 203690, 209335, 177893, 186845, 193508, 209372, 209362, 209320, 209381, 209299, 187848, 209491, 209507, 258629, 253947, 259262, 249176, 209566, 209487, 190979, 209244, 209247, 209280, 209317, 209342, 209172, 209173, 209174, 209185, 209192, 209197, 209393, 209424, 209436, 209451, 209464, 209480, 209485, 209494, 209509, 209514, 209571, 177861, 177873, 250980, 186233, 186232, 209573, 209378, 209234, 209506, 209554, 209346, 209258, 193625, 204975, 177891, 209565, 177927, 209236, 209328, 209330, 190984, 209238, 209239, 209178, 209472, 209433, 209473, 209493, 209515, 209209, 238976, 177917, 215132, 203681, 209528, 209495, 209501, 209524, 192957, 209242, 209273, 209214, 218167, 209389, 193109, 216288, 193209, 177880, 177884, 209313, 193509, 217801, 202634, 188425, 209570, 209545, 209384, 209221, 209257, 209198, 209211, 209216, 209394, 209505, 209546, 209567, 202687, 209502, 202652, 253188, 209251, 209311, 209347, 209361, 209366, 209516, 209527, 209529, 209572, 186298, 209184, 186295, 209245, 177892, 217925, 176416, 210627, 219448, 209266, 209303, 209304, 209306, 209310, 209338, 209343, 209345, 209175, 209196, 209367, 209437, 209438, 209442, 209446, 209474, 209483, 209492, 209568, 209340, 234379, 176679, 197918, 177885, 209359, 209391, 209556, 209558, 193110, 177878, 177908, 209302, 209403, 190710, 214111, 209262, 209229, 209230, 209252, 209263, 209286, 209324, 209212, 193111, 209439, 209511, 209525, 209555, 209246, 209321, 177922, 193569, 189018, 209191, 209496, 209447, 240858, 177857, 223745, 188430, 258628, 209354, 209272, 193114, 193215, 209231, 209276, 209260, 208831, 219982, 209264, 209430)) UNION ALL ( select distinct sm.id as record, 3808, mrp.id as ref, 'Manufacturing Orders' as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from mrp_production mrp LEFT JOIN stock_move as sm ON sm.raw_material_production_id = mrp.id LEFT JOIN product_product as pp ON sm.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where mrp.state = 'done' and mrp.branch_id = 45 and sm.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and mrp.create_date >= '2017-12-02 00:00:00' and mrp.create_date <= '2023-12-02 00:00:00' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150, 3291) and pp.id not in (189318, 173241, 202632, 202640, 209210, 183363, 202635, 193055, 193528, 193529, 202477, 193565, 187918, 202653, 209518, 209382, 209267, 209269, 209281, 209329, 209339, 209199, 209182, 209201, 209219, 209413, 209414, 209457, 209466, 209482, 209488, 177924, 177926, 209344, 209561, 193359, 193405, 209318, 209225, 209305, 209559, 193620, 188461, 183353, 209203, 209418, 209357, 189042, 248827, 209255, 209176, 209513, 183350, 209470, 209282, 209332, 209189, 209202, 209427, 209471, 209479, 209519, 209521, 216289, 177872, 177949, 209390, 209256, 209254, 216830, 206656, 209421, 209517, 209356, 187791, 177876, 177890, 209379, 183351, 209268, 209190, 209562, 244119, 177743, 192904, 209261, 209259, 215693, 209227, 209352, 209370, 209392, 209415, 209537, 209456, 193698, 209187, 209235, 209319, 209193, 209195, 177947, 177894, 177886, 177948, 209333, 190764, 209233, 203674, 213509, 209188, 189041, 209226, 209253, 209503, 209526, 209569, 172604, 177899, 177887, 239388, 177896, 209374, 209469, 176822, 209308, 177747, 209312, 209243, 209323, 209228, 213768, 209179, 209265, 209271, 209316, 209322, 209325, 209416, 209462, 186294, 193666, 215733, 209241, 209250, 209206, 209468, 209326, 209207, 209220, 209358, 209425, 209422, 177882, 209331, 209360, 209398, 209538, 209563, 204056, 209232, 209270, 209277, 209284, 209298, 209307, 209309, 209180, 209194, 209183, 209177, 209186, 209396, 209412, 209434, 209440, 209441, 209459, 209484, 209497, 209510, 209512, 209520, 209935, 209475, 209327, 209181, 209315, 177900, 213767, 209560, 209278, 209279, 209314, 209423, 209452, 209460, 209365, 209435, 188924, 245930, 177853, 209380, 193113, 202577, 209334, 183364, 209200, 203690, 209335, 177893, 186845, 193508, 209372, 209362, 209320, 209381, 209299, 187848, 209491, 209507, 258629, 253947, 259262, 249176, 209566, 209487, 190979, 209244, 209247, 209280, 209317, 209342, 209172, 209173, 209174, 209185, 209192, 209197, 209393, 209424, 209436, 209451, 209464, 209480, 209485, 209494, 209509, 209514, 209571, 177861, 177873, 250980, 186233, 186232, 209573, 209378, 209234, 209506, 209554, 209346, 209258, 193625, 204975, 177891, 209565, 177927, 209236, 209328, 209330, 190984, 209238, 209239, 209178, 209472, 209433, 209473, 209493, 209515, 209209, 238976, 177917, 215132, 203681, 209528, 209495, 209501, 209524, 192957, 209242, 209273, 209214, 218167, 209389, 193109, 216288, 193209, 177880, 177884, 209313, 193509, 217801, 202634, 188425, 209570, 209545, 209384, 209221, 209257, 209198, 209211, 209216, 209394, 209505, 209546, 209567, 202687, 209502, 202652, 253188, 209251, 209311, 209347, 209361, 209366, 209516, 209527, 209529, 209572, 186298, 209184, 186295, 209245, 177892, 217925, 176416, 210627, 219448, 209266, 209303, 209304, 209306, 209310, 209338, 209343, 209345, 209175, 209196, 209367, 209437, 209438, 209442, 209446, 209474, 209483, 209492, 209568, 209340, 234379, 176679, 197918, 177885, 209359, 209391, 209556, 209558, 193110, 177878, 177908, 209302, 209403, 190710, 214111, 209262, 209229, 209230, 209252, 209263, 209286, 209324, 209212, 193111, 209439, 209511, 209525, 209555, 209246, 209321, 177922, 193569, 189018, 209191, 209496, 209447, 240858, 177857, 223745, 188430, 258628, 209354, 209272, 193114, 193215, 209231, 209276, 209260, 208831, 219982, 209264, 209430))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select 3808, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone 'UTC', True from data LEFT JOIN branch_product_method as brpm ON brpm.product_id = data.product_id and brpm.branch_id = 45);

[ Date: 2023-12-02 01:05:37 ]

with data as ( select distinct shl.id as record, 3801, shl.id as ref, 'Sales History' as ref_code, shl.product_id as product_id, shl.invoice_date as invoice_date, shl.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, shl.selling_branch as selling_branch, st.id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_history_line as shl LEFT JOIN stock_warehouse as st ON st.branch_id = shl.selling_branch LEFT JOIN product_product as pp ON pp.id = shl.product_id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id where shl.selling_branch = 37 and shl.sales_obtain != 'direct' and shl.product_id is not null and shl.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and shl.invoice_date >= '2017-12-02 00:00:00' and shl.invoice_date <= '2023-12-02 00:00:00' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150, 3291) and pp.id not in (209380, 173241, 184675, 190567, 198387, 209518, 209232, 209206, 209177, 209358, 209398, 209440, 209441, 209452, 209459, 209460, 209462, 209532, 209309, 209425, 209250, 209271, 209277, 209422, 209323, 209193, 209308, 209270, 209183, 209265, 209475, 209456, 209241, 188456, 209186, 209316, 209195, 209374, 209326, 175893, 175890, 173771, 209235, 209243, 209260, 209278, 209307, 209314, 209331, 209188, 209181, 209179, 209510, 209180, 209327, 209194, 209360, 209365, 209563, 179979, 209228, 209259, 209279, 209284, 209298, 209312, 209322, 209325, 209220, 209396, 209412, 209484, 209497, 209520, 209549, 193529, 209469, 209254, 178710, 209233, 209333, 209416, 209435, 209512, 209538, 239268, 209225, 209226, 209256, 209190, 209332, 209561, 209562, 209503, 209471, 209315, 189098, 209423, 209468, 177173, 209379, 209305, 209370, 178705, 209227, 209329, 209344, 209210, 209352, 209569, 228221, 209513, 209207, 175876, 209253, 209264, 209267, 209269, 209272, 209276, 209282, 209189, 209199, 209182, 209176, 209203, 209413, 209414, 209415, 209457, 209479, 209482, 209526, 209537, 209201, 209219, 209390, 209392, 209427, 209470, 209517, 209519, 209521, 209261, 209268, 209339, 209391, 209231, 209255, 209318, 209356, 209357, 209418, 209354, 209421, 209466, 209559, 209245, 209384, 209437, 209447, 209555, 209198, 209216, 209505, 209567, 209572, 209367, 209347, 209430, 209251, 209324, 209361, 209366, 209474, 209511, 186099, 209229, 209359, 209496, 209527, 209558, 209211, 209439, 209477, 209478, 209498, 209257, 209382, 209545, 239344, 209311, 209338, 222244, 209628, 209246, 209262, 209263, 209266, 209302, 209303, 209304, 209306, 209310, 209343, 209345, 209175, 209184, 209191, 209212, 209403, 209438, 209442, 209446, 209483, 209492, 209528, 209529, 209568, 209321, 209340, 209221, 209230, 209252, 209275, 209286, 209313, 209205, 209196, 209389, 209502, 209516, 209525, 209546, 209556, 209570, 209372, 204971, 239141, 209200, 209334, 209473, 209506, 209565, 209480, 209209, 209424, 245930, 209247, 209258, 209393, 209464, 209493, 209494, 209514, 209515, 209566, 209571, 222245, 209342, 209330, 209239, 209244, 209299, 209317, 209346, 209185, 209192, 209178, 209362, 209433, 209436, 209451, 209491, 209499, 209501, 209507, 209531, 209554, 209560, 209234, 209320, 209328, 209381, 209487, 209509, 185856, 209573, 209378, 209187, 209242, 209495, 209524, 238911, 209236, 209238, 209335, 209172, 209173, 209174, 209197, 197240, 209445, 209434, 209281, 209202, 209488, 209319, 209273, 209280, 209214, 209472, 209485) UNION ALL ( select distinct sol.id as record, 3801, so.id as ref, 'Sale Order' as ref_code, sol.product_id as product_id, so.date_order as invoice_date, sol.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, so.branch_id as selling_branch, so.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from sale_order_line sol LEFT JOIN product_product as pp ON sol.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN sale_order as so ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where sol.branch_id = 37 and sol.product_id is not null and sol.exception_sale IS NOT TRUE and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and so.date_order >= '2017-12-02 00:00:00' and so.date_order <= '2023-12-02 00:00:00' and so.state in ('permanent_order') and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150, 3291) and pp.id not in (209380, 173241, 184675, 190567, 198387, 209518, 209232, 209206, 209177, 209358, 209398, 209440, 209441, 209452, 209459, 209460, 209462, 209532, 209309, 209425, 209250, 209271, 209277, 209422, 209323, 209193, 209308, 209270, 209183, 209265, 209475, 209456, 209241, 188456, 209186, 209316, 209195, 209374, 209326, 175893, 175890, 173771, 209235, 209243, 209260, 209278, 209307, 209314, 209331, 209188, 209181, 209179, 209510, 209180, 209327, 209194, 209360, 209365, 209563, 179979, 209228, 209259, 209279, 209284, 209298, 209312, 209322, 209325, 209220, 209396, 209412, 209484, 209497, 209520, 209549, 193529, 209469, 209254, 178710, 209233, 209333, 209416, 209435, 209512, 209538, 239268, 209225, 209226, 209256, 209190, 209332, 209561, 209562, 209503, 209471, 209315, 189098, 209423, 209468, 177173, 209379, 209305, 209370, 178705, 209227, 209329, 209344, 209210, 209352, 209569, 228221, 209513, 209207, 175876, 209253, 209264, 209267, 209269, 209272, 209276, 209282, 209189, 209199, 209182, 209176, 209203, 209413, 209414, 209415, 209457, 209479, 209482, 209526, 209537, 209201, 209219, 209390, 209392, 209427, 209470, 209517, 209519, 209521, 209261, 209268, 209339, 209391, 209231, 209255, 209318, 209356, 209357, 209418, 209354, 209421, 209466, 209559, 209245, 209384, 209437, 209447, 209555, 209198, 209216, 209505, 209567, 209572, 209367, 209347, 209430, 209251, 209324, 209361, 209366, 209474, 209511, 186099, 209229, 209359, 209496, 209527, 209558, 209211, 209439, 209477, 209478, 209498, 209257, 209382, 209545, 239344, 209311, 209338, 222244, 209628, 209246, 209262, 209263, 209266, 209302, 209303, 209304, 209306, 209310, 209343, 209345, 209175, 209184, 209191, 209212, 209403, 209438, 209442, 209446, 209483, 209492, 209528, 209529, 209568, 209321, 209340, 209221, 209230, 209252, 209275, 209286, 209313, 209205, 209196, 209389, 209502, 209516, 209525, 209546, 209556, 209570, 209372, 204971, 239141, 209200, 209334, 209473, 209506, 209565, 209480, 209209, 209424, 245930, 209247, 209258, 209393, 209464, 209493, 209494, 209514, 209515, 209566, 209571, 222245, 209342, 209330, 209239, 209244, 209299, 209317, 209346, 209185, 209192, 209178, 209362, 209433, 209436, 209451, 209491, 209499, 209501, 209507, 209531, 209554, 209560, 209234, 209320, 209328, 209381, 209487, 209509, 185856, 209573, 209378, 209187, 209242, 209495, 209524, 238911, 209236, 209238, 209335, 209172, 209173, 209174, 209197, 197240, 209445, 209434, 209281, 209202, 209488, 209319, 209273, 209280, 209214, 209472, 209485)) UNION ALL ( select distinct sm.id as record, 3801, mrp.id as ref, 'Manufacturing Orders' as ref_code, sm.product_id as product_id, mrp.create_date as invoice_date, sm.product_uom_qty as product_uom_qty, inv.id as inventory_vendor_id, mrp.branch_id as selling_branch, sm.warehouse_id as warehouse_id, pt.method as method, now() at time zone 'UTC', True from mrp_production mrp LEFT JOIN stock_move as sm ON sm.raw_material_production_id = mrp.id LEFT JOIN product_product as pp ON sm.product_id = pp.id LEFT JOIN product_template as pt ON pp.product_tmpl_id = pt.id LEFT JOIN psd_custom_inventory_vendor as inv ON inv.id = pt.inventory_vendor_id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = pp.id where mrp.state = 'done' and mrp.branch_id = 37 and sm.product_id is not null and pt.never_stock = False and pt.discontinued = False and pt.is_core = False and mrp.create_date >= '2017-12-02 00:00:00' and mrp.create_date <= '2023-12-02 00:00:00' and pt.inventory_vendor_id not in (2911, 2931, 2932, 2993, 3000, 3007, 3008, 3010, 3011, 3012, 3013, 3014, 3015, 3049, 3063, 3064, 3065, 3079, 3087, 3097, 3099, 3114, 3124, 3127, 3150, 3291) and pp.id not in (209380, 173241, 184675, 190567, 198387, 209518, 209232, 209206, 209177, 209358, 209398, 209440, 209441, 209452, 209459, 209460, 209462, 209532, 209309, 209425, 209250, 209271, 209277, 209422, 209323, 209193, 209308, 209270, 209183, 209265, 209475, 209456, 209241, 188456, 209186, 209316, 209195, 209374, 209326, 175893, 175890, 173771, 209235, 209243, 209260, 209278, 209307, 209314, 209331, 209188, 209181, 209179, 209510, 209180, 209327, 209194, 209360, 209365, 209563, 179979, 209228, 209259, 209279, 209284, 209298, 209312, 209322, 209325, 209220, 209396, 209412, 209484, 209497, 209520, 209549, 193529, 209469, 209254, 178710, 209233, 209333, 209416, 209435, 209512, 209538, 239268, 209225, 209226, 209256, 209190, 209332, 209561, 209562, 209503, 209471, 209315, 189098, 209423, 209468, 177173, 209379, 209305, 209370, 178705, 209227, 209329, 209344, 209210, 209352, 209569, 228221, 209513, 209207, 175876, 209253, 209264, 209267, 209269, 209272, 209276, 209282, 209189, 209199, 209182, 209176, 209203, 209413, 209414, 209415, 209457, 209479, 209482, 209526, 209537, 209201, 209219, 209390, 209392, 209427, 209470, 209517, 209519, 209521, 209261, 209268, 209339, 209391, 209231, 209255, 209318, 209356, 209357, 209418, 209354, 209421, 209466, 209559, 209245, 209384, 209437, 209447, 209555, 209198, 209216, 209505, 209567, 209572, 209367, 209347, 209430, 209251, 209324, 209361, 209366, 209474, 209511, 186099, 209229, 209359, 209496, 209527, 209558, 209211, 209439, 209477, 209478, 209498, 209257, 209382, 209545, 239344, 209311, 209338, 222244, 209628, 209246, 209262, 209263, 209266, 209302, 209303, 209304, 209306, 209310, 209343, 209345, 209175, 209184, 209191, 209212, 209403, 209438, 209442, 209446, 209483, 209492, 209528, 209529, 209568, 209321, 209340, 209221, 209230, 209252, 209275, 209286, 209313, 209205, 209196, 209389, 209502, 209516, 209525, 209546, 209556, 209570, 209372, 204971, 239141, 209200, 209334, 209473, 209506, 209565, 209480, 209209, 209424, 245930, 209247, 209258, 209393, 209464, 209493, 209494, 209514, 209515, 209566, 209571, 222245, 209342, 209330, 209239, 209244, 209299, 209317, 209346, 209185, 209192, 209178, 209362, 209433, 209436, 209451, 209491, 209499, 209501, 209507, 209531, 209554, 209560, 209234, 209320, 209328, 209381, 209487, 209509, 185856, 209573, 209378, 209187, 209242, 209495, 209524, 238911, 209236, 209238, 209335, 209172, 209173, 209174, 209197, 197240, 209445, 209434, 209281, 209202, 209488, 209319, 209273, 209280, 209214, 209472, 209485))) insert into item_list_line (item_demand_plan_id, product_id, invoice_date, product_uom_qty, inventory_vendor_id, selling_branch, warehouse_id, method, ref_id, ref, create_date, active) ( select 3801, data.product_id as product_id, data.invoice_date as invoice_date, data.product_uom_qty as product_uom_qty, data.inventory_vendor_id as inventory_vendor_id, data.selling_branch as selling_branch, data.warehouse_id as warehouse_id, brpm.method as method, data.ref as ref_id, data.ref_code as ref, now() at time zone 'UTC', True from data LEFT JOIN branch_product_method as brpm ON brpm.product_id = data.product_id and brpm.branch_id = 37);