API tools faq
paste
Advertisement
cyecize

LOG 1.1

cyecize
Aug 23rd, 2021
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 71.52 KB | None | 0 0
raw download clone embed print report
  1. Hibernate: select usertti0_.id as id1_75_0_, userpermis2_.id as id1_72_1_, usertti0_.entity_tti as entity_t4_75_0_, usertti0_.branch_name as branch_n2_75_0_, usertti0_.email as email3_75_0_, usertti0_.is_cqm as is_cqm5_75_0_, usertti0_.mocking_object_id as mocking_6_75_0_, usertti0_.name as name7_75_0_, usertti0_.object_id as object_i8_75_0_, usertti0_.user_role_id as user_rol9_75_0_, userpermis2_.name as name2_72_1_, permission1_.user_tti_id as user_tti1_76_0__, permission1_.permissions_id as permissi2_76_0__ from user_tti usertti0_ left outer join user_tti_permissions permission1_ on usertti0_.id=permission1_.user_tti_id left outer join user_permission userpermis2_ on permission1_.permissions_id=userpermis2_.id where usertti0_.object_id=?
  2. Hibernate: select branch0_.entity_tti as entity_t1_6_0_, branch0_.name as name2_6_0_, branch0_.region_id as region_i3_6_0_ from branch branch0_ where branch0_.entity_tti=? and branch0_.name=?
  3. Hibernate: select userrole0_.id as id1_73_0_, userrole0_.ad_group_name as ad_group2_73_0_, userrole0_.name as name3_73_0_ from user_role userrole0_ where userrole0_.id=?
  4. Serving: POST /quote/130/cost_markup/gross_profit_update
  5. Hibernate: select quote0_.id as id1_28_0_, quote0_.account_id as account_2_28_0_, quote0_.api_submitted as api_subm3_28_0_, quote0_.apply_cut_tape_options as apply_cu4_28_0_, quote0_.apply_mil_options as apply_mi5_28_0_, quote0_.apply_special_pricing as apply_sp6_28_0_, quote0_.archive_reason as archive_7_28_0_, quote0_.archived_by as archived8_28_0_, quote0_.archived_date as archived9_28_0_, quote0_.avl_group_preference_id as avl_gro66_28_0_, quote0_.branch_name as branch_10_28_0_, quote0_.check_ndc_stock as check_n11_28_0_, quote0_.comments as comment12_28_0_, quote0_.corporate_id as corpora13_28_0_, quote0_.cost_completion as cost_co14_28_0_, quote0_.cpn_avl as cpn_avl15_28_0_, quote0_.cqm_id as cqm_id16_28_0_, quote0_.crosses_accepted as crosses17_28_0_, quote0_.currency as currenc18_28_0_, quote0_.customer_due_date as custome19_28_0_, quote0_.customer_last_quote_date as custome20_28_0_, quote0_.customer_last_shipment_date as custome21_28_0_, quote0_.customer_name as custome22_28_0_, quote0_.customer_reference_number as custome23_28_0_, quote0_.do_not_scrub as do_not_24_28_0_, quote0_.end_customer_id as end_cus25_28_0_, quote0_.end_customer_last_quote_date as end_cus26_28_0_, quote0_.end_customer_location as end_cus27_28_0_, quote0_.entity_tti as entity_28_28_0_, quote0_.external_cost as externa29_28_0_, quote0_.external_resale as externa30_28_0_, quote0_.file_type as file_ty31_28_0_, quote0_.fsr_id as fsr_id32_28_0_, quote0_.gross_profit as gross_p33_28_0_, quote0_.is_draft as is_draf34_28_0_, quote0_.is_strategic as is_stra35_28_0_, quote0_.isr_id as isr_id36_28_0_, quote0_.lines_to_work as lines_t37_28_0_, quote0_.original_quote_submitter_id as origina38_28_0_, quote0_.owner_close_date as owner_c39_28_0_, quote0_.owner_id as owner_i40_28_0_, quote0_.part_scrub_completed as part_sc41_28_0_, quote0_.part_scrub_completion as part_sc42_28_0_, quote0_.part_scrub_done_percent as part_sc43_28_0_, quote0_.previous_quote_roll_up_state as previou44_28_0_, quote0_.project_id as project46_28_0_, quote0_.project_director_id as project45_28_0_, quote0_.quote_administrator_id as quote_a47_28_0_, quote0_.quote_owner_id as quote_o48_28_0_, quote0_.quote_quantity_represents as quote_q49_28_0_, quote0_.quote_requestor_id as quote_r50_28_0_, quote0_.quote_roll_up_state as quote_r51_28_0_, quote0_.quote_status_id as quote_s52_28_0_, quote0_.quote_type as quote_t53_28_0_, quote0_.received_on as receive54_28_0_, quote0_.region_id as region_55_28_0_, quote0_.resale_completion as resale_56_28_0_, quote0_.site_location_mapped as site_lo57_28_0_, quote0_.support_requested as support58_28_0_, quote0_.system_id as system_59_28_0_, quote0_.total_completed_lines as total_c60_28_0_, quote0_.total_number_of_line_items as total_n61_28_0_, quote0_.total_number_of_lines as total_n62_28_0_, quote0_.use_account_currency as use_acc63_28_0_, quote0_.uuid as uuid64_28_0_, quote0_.valid_for as valid_f65_28_0_, usertti1_.id as id1_75_1_, usertti1_.entity_tti as entity_t4_75_1_, usertti1_.branch_name as branch_n2_75_1_, usertti1_.email as email3_75_1_, usertti1_.is_cqm as is_cqm5_75_1_, usertti1_.mocking_object_id as mocking_6_75_1_, usertti1_.name as name7_75_1_, usertti1_.object_id as object_i8_75_1_, usertti1_.user_role_id as user_rol9_75_1_, branch2_.entity_tti as entity_t1_6_2_, branch2_.name as name2_6_2_, branch2_.region_id as region_i3_6_2_, userrole3_.id as id1_73_3_, userrole3_.ad_group_name as ad_group2_73_3_, userrole3_.name as name3_73_3_, usertti4_.id as id1_75_4_, usertti4_.entity_tti as entity_t4_75_4_, usertti4_.branch_name as branch_n2_75_4_, usertti4_.email as email3_75_4_, usertti4_.is_cqm as is_cqm5_75_4_, usertti4_.mocking_object_id as mocking_6_75_4_, usertti4_.name as name7_75_4_, usertti4_.object_id as object_i8_75_4_, usertti4_.user_role_id as user_rol9_75_4_, usertti5_.id as id1_75_5_, usertti5_.entity_tti as entity_t4_75_5_, usertti5_.branch_name as branch_n2_75_5_, usertti5_.email as email3_75_5_, usertti5_.is_cqm as is_cqm5_75_5_, usertti5_.mocking_object_id as mocking_6_75_5_, usertti5_.name as name7_75_5_, usertti5_.object_id as object_i8_75_5_, usertti5_.user_role_id as user_rol9_75_5_, usertti6_.id as id1_75_6_, usertti6_.entity_tti as entity_t4_75_6_, usertti6_.branch_name as branch_n2_75_6_, usertti6_.email as email3_75_6_, usertti6_.is_cqm as is_cqm5_75_6_, usertti6_.mocking_object_id as mocking_6_75_6_, usertti6_.name as name7_75_6_, usertti6_.object_id as object_i8_75_6_, usertti6_.user_role_id as user_rol9_75_6_, usertti7_.id as id1_75_7_, usertti7_.entity_tti as entity_t4_75_7_, usertti7_.branch_name as branch_n2_75_7_, usertti7_.email as email3_75_7_, usertti7_.is_cqm as is_cqm5_75_7_, usertti7_.mocking_object_id as mocking_6_75_7_, usertti7_.name as name7_75_7_, usertti7_.object_id as object_i8_75_7_, usertti7_.user_role_id as user_rol9_75_7_, usertti8_.id as id1_75_8_, usertti8_.entity_tti as entity_t4_75_8_, usertti8_.branch_name as branch_n2_75_8_, usertti8_.email as email3_75_8_, usertti8_.is_cqm as is_cqm5_75_8_, usertti8_.mocking_object_id as mocking_6_75_8_, usertti8_.name as name7_75_8_, usertti8_.object_id as object_i8_75_8_, usertti8_.user_role_id as user_rol9_75_8_, usertti9_.id as id1_75_9_, usertti9_.entity_tti as entity_t4_75_9_, usertti9_.branch_name as branch_n2_75_9_, usertti9_.email as email3_75_9_, usertti9_.is_cqm as is_cqm5_75_9_, usertti9_.mocking_object_id as mocking_6_75_9_, usertti9_.name as name7_75_9_, usertti9_.object_id as object_i8_75_9_, usertti9_.user_role_id as user_rol9_75_9_, region10_.id as id1_55_10_, region10_.entity_tti as entity_t2_55_10_, region10_.name as name3_55_10_ from quote quote0_ left outer join user_tti usertti1_ on quote0_.cqm_id=usertti1_.id left outer join branch branch2_ on usertti1_.entity_tti=branch2_.entity_tti and usertti1_.branch_name=branch2_.name left outer join user_role userrole3_ on usertti1_.user_role_id=userrole3_.id left outer join user_tti usertti4_ on quote0_.fsr_id=usertti4_.id left outer join user_tti usertti5_ on quote0_.isr_id=usertti5_.id left outer join user_tti usertti6_ on quote0_.project_director_id=usertti6_.id left outer join user_tti usertti7_ on quote0_.quote_administrator_id=usertti7_.id left outer join user_tti usertti8_ on quote0_.quote_owner_id=usertti8_.id left outer join user_tti usertti9_ on quote0_.quote_requestor_id=usertti9_.id left outer join region region10_ on quote0_.region_id=region10_.id where quote0_.id=?
  6. Hibernate: select userrole0_.id as id1_73_0_, userrole0_.ad_group_name as ad_group2_73_0_, userrole0_.name as name3_73_0_ from user_role userrole0_ where userrole0_.id=?
  7. Hibernate: select account0_.account_id as account_1_0_, account0_.entity_tti as entity_t2_0_, account0_.system_id as system_i3_0_, account0_.branch_name as branch_20_0_, account0_.currency as currency4_0_, account0_.corporate_id as corpora21_0_, account0_.fsr_id as fsr_id5_0_, account0_.isr_id as isr_id6_0_, account0_.name as name7_0_, account0_.parent as parent8_0_, account0_.va_code_1 as va_code_9_0_, account0_.va_code_2 as va_code10_0_, account0_.va_code_3 as va_code11_0_, account0_.va_code_4 as va_code12_0_, account0_.va_code_5 as va_code13_0_, account0_.va_code_6 as va_code14_0_, account0_.warehouse_1 as warehou15_0_, account0_.warehouse_2 as warehou16_0_, account0_.warehouse_3 as warehou17_0_, account0_.warehouse_4 as warehou18_0_, account0_.warehouse_5 as warehou19_0_ from account account0_ where account0_.account_id=? and account0_.entity_tti=? order by account0_.name asc
  8. Hibernate: select branchsale0_.entity_tti as entity_t1_7_0_, branchsale0_.sales_branch_name as sales_br2_7_0_, branchsale0_.parent_branch_name as parent_b3_7_0_, branchsale0_.region_id as region_i4_7_0_ from branch_sales branchsale0_ where branchsale0_.entity_tti=? and branchsale0_.sales_branch_name=?
  9. Hibernate: select customer0_.corporate_id as corporat1_9_0_, customer0_.name as name2_9_0_, customer0_.system_id as system_i3_9_0_ from customer customer0_ where customer0_.corporate_id=?
  10. Hibernate: select quotegross0_.id as id1_38_, quotegross0_.apply_revert as apply_re2_38_, quotegross0_.gross_profit as gross_pr3_38_, quotegross0_.quote_id as quote_id4_38_ from quote_gross_profit_params quotegross0_ where quotegross0_.quote_id=?
  11. 2021-08-24 00:58:22.843 WARN 18592 --- [nio-8080-exec-9] o.h.h.internal.ast.QueryTranslatorImpl : HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!
  12. Hibernate: select quotelinei0_.id as id1_42_0_, quotelinei1_.id as id1_43_1_, assignees2_.quote_line_item_id as quote_li1_79_2_, assignees2_.user_id as user_id2_79_2_, quantities3_.id as id1_47_3_, valueaddmr5_.system_id as system_i1_81_4_, valueaddmr5_.va_code as va_code2_81_4_, valueaddmr5_.warehouse_location as warehous3_81_4_, valueaddcv7_.customer_number as customer1_80_5_, valueaddcv7_.va_code as va_code2_80_5_, quotelinei0_.all_mapped_columns_hash as all_mapp2_42_0_, quotelinei0_.approval_indicator as approval3_42_0_, quotelinei0_.assign_entity as assign_e4_42_0_, quotelinei0_.ats as ats5_42_0_, quotelinei0_.auto_scrubbed as auto_scr6_42_0_, quotelinei0_.avl_uuid as avl_uuid7_42_0_, quotelinei0_.branch_name as branch_n8_42_0_, quotelinei0_.branch_work_completed as branch_w9_42_0_, quotelinei0_.build_part_ind as build_p10_42_0_, quotelinei0_.bulk_updated_mfg as bulk_up11_42_0_, quotelinei0_.can_build as can_bui12_42_0_, quotelinei0_.category as categor13_42_0_, quotelinei0_.check_kros_file as check_k14_42_0_, quotelinei0_.client_id as client_15_42_0_, quotelinei0_.comments_to_customer as comment16_42_0_, quotelinei0_.contract_pricing_indicator as contrac17_42_0_, quotelinei0_.cost_labor as cost_la18_42_0_, quotelinei0_.cost_markup_unresolved as cost_ma19_42_0_, quotelinei0_.country_of_origin as country20_42_0_, quotelinei0_.cpn as cpn21_42_0_, quotelinei0_.currency as currenc22_42_0_, quotelinei0_.customer_comments as custome23_42_0_, quotelinei0_.date_completed as date_co24_42_0_, quotelinei0_.description as descrip25_42_0_, quotelinei0_.design_registrable as design_26_42_0_, quotelinei0_.fail_set_validation as fail_se27_42_0_, quotelinei0_.file_row_number as file_ro28_42_0_, quotelinei0_.from_ndc_stock as from_nd29_42_0_, quotelinei0_.has_comment as has_com30_42_0_, quotelinei0_.has_invalid_quantity as has_inv31_42_0_, quotelinei0_.has_multiple_choices as has_mul32_42_0_, quotelinei0_.has_previous_match as has_pre33_42_0_, quotelinei0_.in_history as in_hist34_42_0_, quotelinei0_.inventory as invento35_42_0_, quotelinei0_.isr_id as isr_id36_42_0_, quotelinei0_.lead_free as lead_fr37_42_0_, quotelinei0_.lead_time as lead_ti38_42_0_, quotelinei0_.manufacturer_alias as manufac39_42_0_, quotelinei0_.manufacturer_alias_order_number as manufac40_42_0_, quotelinei0_.mapped_columns_hash as mapped_41_42_0_, quotelinei0_.match_accuracy as match_a42_42_0_, quotelinei0_.mfg_updated as mfg_upd43_42_0_, quotelinei0_.is_modified_cost_markup as is_modi44_42_0_, quotelinei0_.movement_code as movemen45_42_0_, quotelinei0_.mult as mult46_42_0_, quotelinei0_.ncnr as ncnr47_42_0_, quotelinei0_.newly_added as newly_a48_42_0_, quotelinei0_.number_of_orders as number_49_42_0_, quotelinei0_.number_of_quotes as number_50_42_0_, quotelinei0_.on_hand as on_hand51_42_0_, quotelinei0_.on_order as on_orde52_42_0_, quotelinei0_.part_alias as part_al53_42_0_, quotelinei0_.part_alias_order_number as part_al54_42_0_, quotelinei0_.part_scrub_modified_by_id as part_sc55_42_0_, quotelinei0_.pkg_qty as pkg_qty56_42_0_, quotelinei0_.pkg_type as pkg_typ57_42_0_, quotelinei0_.preferred_line as preferr58_42_0_, quotelinei0_.product_class as product59_42_0_, quotelinei0_.quote_id as quote_i60_42_0_, quotelinei0_.quote_line_item_additional_id as quote_l70_42_0_, quotelinei0_.rohs as rohs61_42_0_, quotelinei0_.tti_description_part_scrub as tti_des62_42_0_, quotelinei0_.tti_manufacturer_cost_markup as tti_man63_42_0_, quotelinei0_.tti_manufacturer_part_scrub as tti_man64_42_0_, quotelinei0_.tti_part_number_cost_markup as tti_par65_42_0_, quotelinei0_.tti_part_number_part_scrub as tti_par66_42_0_, quotelinei0_.unresolved as unresol67_42_0_, quotelinei0_.updated as updated68_42_0_, quotelinei0_.validation as validat69_42_0_, quotelinei1_.add_date as add_date2_43_1_, quotelinei1_.alternative_tti_manufacturer as alternat3_43_1_, quotelinei1_.alternative_tti_part_number as alternat4_43_1_, quotelinei1_.available_on_order as availabl5_43_1_, quotelinei1_.available_on_order_date as availabl6_43_1_, quotelinei1_.average_cost as average_7_43_1_, quotelinei1_.buy_cost as buy_cost8_43_1_, quotelinei1_.cancellation_window as cancella9_43_1_, quotelinei1_.commodity as commodi10_43_1_, quotelinei1_.country_of_origin as country11_43_1_, quotelinei1_.delivery_terms as deliver12_43_1_, quotelinei1_.eccn as eccn13_43_1_, quotelinei1_.entity_tti as entity_14_43_1_, quotelinei1_.hts_code as hts_cod15_43_1_, quotelinei1_.inco_terms as inco_te16_43_1_, quotelinei1_.info1 as info17_43_1_, quotelinei1_.info2 as info18_43_1_, quotelinei1_.last_received_date as last_re19_43_1_, quotelinei1_.min_buy_quantity as min_buy20_43_1_, quotelinei1_.mrp_back_ordered as mrp_bac21_43_1_, quotelinei1_.no_bid_reason as no_bid_22_43_1_, quotelinei1_.no_of_customers as no_of_c23_43_1_, quotelinei1_.number_of_customers as number_24_43_1_, quotelinei1_.number_of_sales as number_25_43_1_, quotelinei1_.order_date as order_d26_43_1_, quotelinei1_.order_margin as order_m27_43_1_, quotelinei1_.order_resale as order_r28_43_1_, quotelinei1_.payment_terms as payment29_43_1_, quotelinei1_.pm_code as pm_code30_43_1_, quotelinei1_.product_description as product31_43_1_, quotelinei1_.quantity as quantit32_43_1_, quotelinei1_.quote_history_date as quote_h33_43_1_, quotelinei1_.quote_history_margin as quote_h34_43_1_, quotelinei1_.quote_history_resale as quote_h35_43_1_, quotelinei1_.replacement_cost as replace36_43_1_, quotelinei1_.resale_base_price_prm as resale_37_43_1_, quotelinei1_.resale_info as resale_38_43_1_, quotelinei1_.reschedule_window as resched39_43_1_, quotelinei1_.sales_cost as sales_c40_43_1_, quotelinei1_.sales_info as sales_i41_43_1_, quotelinei1_.shipping_point as shippin42_43_1_, quotelinei1_.so_approval_index as so_appr43_43_1_, quotelinei1_.special_cost as special44_43_1_, quotelinei1_.tariff_charge as tariff_45_43_1_, quotelinei1_.tariff_indicator as tariff_46_43_1_, quotelinei1_.tariff_rate as tariff_47_43_1_, quotelinei1_.tti_so_mult as tti_so_48_43_1_, quotelinei1_.warehouse_location as warehou49_43_1_, assignees2_.quote_line_item_comment_id as quote_li3_79_2_, assignees2_.quote_line_item_id as quote_li1_79_0__, assignees2_.user_id as user_id2_79_0__, quantities3_.call_pm as call_pm2_47_3_, quantities3_.conn_discount as conn_dis3_47_3_, quantities3_.cost as cost4_47_3_, quantities3_.cost_source as cost_sou5_47_3_, quantities3_.cost_source_entity as cost_sou6_47_3_, quantities3_.ext_cost as ext_cost7_47_3_, quantities3_.ext_resale as ext_resa8_47_3_, quantities3_.gp_dollar as gp_dolla9_47_3_, quantities3_.manually_updated_margin as manuall10_47_3_, quantities3_.margin as margin11_47_3_, quantities3_.min as min12_47_3_, quantities3_.order_number as order_n13_47_3_, quantities3_.quantity as quantit14_47_3_, quantities3_.quote_line_item_id as quote_l22_47_3_, quantities3_.quote_line_item_quantity_status as quote_l15_47_3_, quantities3_.quoted_quantity as quoted_16_47_3_, quantities3_.resale as resale17_47_3_, quantities3_.resale_precision as resale_18_47_3_, quantities3_.resale_source as resale_19_47_3_, quantities3_.va_charges as va_char20_47_3_, quantities3_.va_margin as va_marg21_47_3_, quantities3_.quote_line_item_id as quote_l22_47_1__, quantities3_.id as id1_47_1__, valueaddmr5_.distributors_number as distribu4_81_4_, valueaddmr5_.environment as environm5_81_4_, valueaddmr5_.max_cost_pieces as max_cost6_81_4_, valueaddmr5_.min_cost as min_cost7_81_4_, valueaddmr5_.unit_cost as unit_cos8_81_4_, valueaddmr4_.quote_line_item_quantity_id as quote_li1_31_2__, valueaddmr4_.system_id as system_i2_31_2__, valueaddmr4_.va_code as va_code3_31_2__, valueaddmr4_.warehouse_location as warehous4_31_2__, valueaddcv7_.distributors_number as distribu3_80_5_, valueaddcv7_.environment as environm4_80_5_, valueaddcv7_.max_cost_pieces as max_cost5_80_5_, valueaddcv7_.min_cost as min_cost6_80_5_, valueaddcv7_.system_id as system_i7_80_5_, valueaddcv7_.unit_cost as unit_cos8_80_5_, valueaddcv6_.quote_line_item_quantity_id as quote_li1_30_3__, valueaddcv6_.va_cva_customer_number as va_cva_c2_30_3__, valueaddcv6_.va_cva_code as va_cva_c3_30_3__ from quote_line_item quotelinei0_ left outer join quote_line_item_additional quotelinei1_ on quotelinei0_.quote_line_item_additional_id=quotelinei1_.id left outer join user_tti_quote_line_item assignees2_ on quotelinei0_.id=assignees2_.quote_line_item_id left outer join quote_line_item_quantity quantities3_ on quotelinei0_.id=quantities3_.quote_line_item_id left outer join quote_line_item_quantity_va_mrf valueaddmr4_ on quantities3_.id=valueaddmr4_.quote_line_item_quantity_id left outer join value_add_mrf valueaddmr5_ on valueaddmr4_.system_id=valueaddmr5_.system_id and valueaddmr4_.va_code=valueaddmr5_.va_code and valueaddmr4_.warehouse_location=valueaddmr5_.warehouse_location left outer join quote_line_item_quantity_va_cva valueaddcv6_ on quantities3_.id=valueaddcv6_.quote_line_item_quantity_id left outer join value_add_cva valueaddcv7_ on valueaddcv6_.va_cva_customer_number=valueaddcv7_.customer_number and valueaddcv6_.va_cva_code=valueaddcv7_.va_code where quotelinei0_.quote_id=?
  13. Hibernate: select quotegross0_.id as id1_39_, quotegross0_.apply_revert as apply_re2_39_, quotegross0_.cost as cost3_39_, quotegross0_.ext_cost as ext_cost4_39_, quotegross0_.ext_resale as ext_resa5_39_, quotegross0_.gross_profit as gross_pr6_39_, quotegross0_.margin as margin7_39_, quotegross0_.min as min8_39_, quotegross0_.qty as qty9_39_, quotegross0_.quote_id as quote_i10_39_, quotegross0_.quote_line_item_id as quote_l11_39_, quotegross0_.resale as resale12_39_, quotegross0_.resale_source as resale_13_39_ from quote_gross_profit_revert quotegross0_ where quotegross0_.quote_line_item_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)
  14. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  15. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  16. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  17. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  18. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  19. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  20. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  21. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  22. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  23. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  24. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  25. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  26. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  27. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  28. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  29. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  30. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  31. Hibernate: update quote_line_item_quantity set call_pm=?, conn_discount=?, cost=?, cost_source=?, cost_source_entity=?, ext_cost=?, ext_resale=?, gp_dollar=?, manually_updated_margin=?, margin=?, min=?, order_number=?, quantity=?, quote_line_item_id=?, quote_line_item_quantity_status=?, quoted_quantity=?, resale=?, resale_precision=?, resale_source=?, va_charges=?, va_margin=? where id=?
  32. 2021-08-24 00:58:22.886 DEBUG 18592 --- [nio-8080-exec-9] o.h.e.jdbc.batch.internal.BatchingBatch : Executing batch size: 18
  33. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  34. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  35. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  36. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  37. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  38. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  39. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  40. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  41. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  42. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  43. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  44. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  45. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  46. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  47. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  48. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  49. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  50. Hibernate: insert into quote_gross_profit_revert (apply_revert, cost, ext_cost, ext_resale, gross_profit, margin, min, qty, quote_id, quote_line_item_id, resale, resale_source, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  51. 2021-08-24 00:58:22.892 DEBUG 18592 --- [nio-8080-exec-9] o.h.e.jdbc.batch.internal.BatchingBatch : Executing batch size: 18
  52. Hibernate: select next value for seq_quote_line_item_event_log
  53. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  54. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  55. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  56. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  57. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  58. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  59. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  60. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  61. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  62. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  63. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  64. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  65. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  66. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  67. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  68. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  69. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  70. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  71. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  72. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  73. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  74. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  75. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  76. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  77. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  78. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  79. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  80. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  81. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  82. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  83. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  84. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  85. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  86. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  87. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  88. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  89. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  90. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  91. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  92. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  93. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  94. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  95. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  96. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  97. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  98. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  99. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  100. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  101. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  102. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  103. 2021-08-24 00:58:22.897 DEBUG 18592 --- [nio-8080-exec-9] o.h.e.jdbc.batch.internal.BatchingBatch : Executing batch size: 50
  104. Hibernate: select next value for seq_quote_line_item_event_log
  105. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  106. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  107. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  108. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  109. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  110. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  111. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  112. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  113. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  114. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  115. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  116. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  117. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  118. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  119. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  120. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  121. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  122. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  123. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  124. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  125. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  126. Hibernate: insert into quote_line_item_event_log (column_name, modified, quote_line_item_id, user_name, value, id) values (?, ?, ?, ?, ?, ?)
  127. 2021-08-24 00:58:22.901 DEBUG 18592 --- [nio-8080-exec-9] o.h.e.jdbc.batch.internal.BatchingBatch : Executing batch size: 22
  128. Hibernate: update quote set external_cost=external_cost+?, external_resale=external_resale+?, gross_profit=gross_profit+? where id=?
  129. Hibernate: insert into quote_gross_profit_params (apply_revert, gross_profit, quote_id, id) values (?, ?, ?, ?)
  130. 2021-08-24 00:58:22.906 DEBUG 18592 --- [nio-8080-exec-9] o.h.e.jdbc.batch.internal.BatchingBatch : Executing batch size: 1
  131. Hibernate: select usertti0_.id as id1_75_0_, userpermis2_.id as id1_72_1_, usertti0_.entity_tti as entity_t4_75_0_, usertti0_.branch_name as branch_n2_75_0_, usertti0_.email as email3_75_0_, usertti0_.is_cqm as is_cqm5_75_0_, usertti0_.mocking_object_id as mocking_6_75_0_, usertti0_.name as name7_75_0_, usertti0_.object_id as object_i8_75_0_, usertti0_.user_role_id as user_rol9_75_0_, userpermis2_.name as name2_72_1_, permission1_.user_tti_id as user_tti1_76_0__, permission1_.permissions_id as permissi2_76_0__ from user_tti usertti0_ left outer join user_tti_permissions permission1_ on usertti0_.id=permission1_.user_tti_id left outer join user_permission userpermis2_ on permission1_.permissions_id=userpermis2_.id where usertti0_.object_id=?
  132. Hibernate: select branch0_.entity_tti as entity_t1_6_0_, branch0_.name as name2_6_0_, branch0_.region_id as region_i3_6_0_ from branch branch0_ where branch0_.entity_tti=? and branch0_.name=?
  133. Hibernate: select userrole0_.id as id1_73_0_, userrole0_.ad_group_name as ad_group2_73_0_, userrole0_.name as name3_73_0_ from user_role userrole0_ where userrole0_.id=?
  134. Serving: POST /quote/line_item/cost_markup
  135. Hibernate: select quote0_.id as id1_28_0_, quote0_.account_id as account_2_28_0_, quote0_.api_submitted as api_subm3_28_0_, quote0_.apply_cut_tape_options as apply_cu4_28_0_, quote0_.apply_mil_options as apply_mi5_28_0_, quote0_.apply_special_pricing as apply_sp6_28_0_, quote0_.archive_reason as archive_7_28_0_, quote0_.archived_by as archived8_28_0_, quote0_.archived_date as archived9_28_0_, quote0_.avl_group_preference_id as avl_gro66_28_0_, quote0_.branch_name as branch_10_28_0_, quote0_.check_ndc_stock as check_n11_28_0_, quote0_.comments as comment12_28_0_, quote0_.corporate_id as corpora13_28_0_, quote0_.cost_completion as cost_co14_28_0_, quote0_.cpn_avl as cpn_avl15_28_0_, quote0_.cqm_id as cqm_id16_28_0_, quote0_.crosses_accepted as crosses17_28_0_, quote0_.currency as currenc18_28_0_, quote0_.customer_due_date as custome19_28_0_, quote0_.customer_last_quote_date as custome20_28_0_, quote0_.customer_last_shipment_date as custome21_28_0_, quote0_.customer_name as custome22_28_0_, quote0_.customer_reference_number as custome23_28_0_, quote0_.do_not_scrub as do_not_24_28_0_, quote0_.end_customer_id as end_cus25_28_0_, quote0_.end_customer_last_quote_date as end_cus26_28_0_, quote0_.end_customer_location as end_cus27_28_0_, quote0_.entity_tti as entity_28_28_0_, quote0_.external_cost as externa29_28_0_, quote0_.external_resale as externa30_28_0_, quote0_.file_type as file_ty31_28_0_, quote0_.fsr_id as fsr_id32_28_0_, quote0_.gross_profit as gross_p33_28_0_, quote0_.is_draft as is_draf34_28_0_, quote0_.is_strategic as is_stra35_28_0_, quote0_.isr_id as isr_id36_28_0_, quote0_.lines_to_work as lines_t37_28_0_, quote0_.original_quote_submitter_id as origina38_28_0_, quote0_.owner_close_date as owner_c39_28_0_, quote0_.owner_id as owner_i40_28_0_, quote0_.part_scrub_completed as part_sc41_28_0_, quote0_.part_scrub_completion as part_sc42_28_0_, quote0_.part_scrub_done_percent as part_sc43_28_0_, quote0_.previous_quote_roll_up_state as previou44_28_0_, quote0_.project_id as project46_28_0_, quote0_.project_director_id as project45_28_0_, quote0_.quote_administrator_id as quote_a47_28_0_, quote0_.quote_owner_id as quote_o48_28_0_, quote0_.quote_quantity_represents as quote_q49_28_0_, quote0_.quote_requestor_id as quote_r50_28_0_, quote0_.quote_roll_up_state as quote_r51_28_0_, quote0_.quote_status_id as quote_s52_28_0_, quote0_.quote_type as quote_t53_28_0_, quote0_.received_on as receive54_28_0_, quote0_.region_id as region_55_28_0_, quote0_.resale_completion as resale_56_28_0_, quote0_.site_location_mapped as site_lo57_28_0_, quote0_.support_requested as support58_28_0_, quote0_.system_id as system_59_28_0_, quote0_.total_completed_lines as total_c60_28_0_, quote0_.total_number_of_line_items as total_n61_28_0_, quote0_.total_number_of_lines as total_n62_28_0_, quote0_.use_account_currency as use_acc63_28_0_, quote0_.uuid as uuid64_28_0_, quote0_.valid_for as valid_f65_28_0_, usertti1_.id as id1_75_1_, usertti1_.entity_tti as entity_t4_75_1_, usertti1_.branch_name as branch_n2_75_1_, usertti1_.email as email3_75_1_, usertti1_.is_cqm as is_cqm5_75_1_, usertti1_.mocking_object_id as mocking_6_75_1_, usertti1_.name as name7_75_1_, usertti1_.object_id as object_i8_75_1_, usertti1_.user_role_id as user_rol9_75_1_, branch2_.entity_tti as entity_t1_6_2_, branch2_.name as name2_6_2_, branch2_.region_id as region_i3_6_2_, userrole3_.id as id1_73_3_, userrole3_.ad_group_name as ad_group2_73_3_, userrole3_.name as name3_73_3_, usertti4_.id as id1_75_4_, usertti4_.entity_tti as entity_t4_75_4_, usertti4_.branch_name as branch_n2_75_4_, usertti4_.email as email3_75_4_, usertti4_.is_cqm as is_cqm5_75_4_, usertti4_.mocking_object_id as mocking_6_75_4_, usertti4_.name as name7_75_4_, usertti4_.object_id as object_i8_75_4_, usertti4_.user_role_id as user_rol9_75_4_, usertti5_.id as id1_75_5_, usertti5_.entity_tti as entity_t4_75_5_, usertti5_.branch_name as branch_n2_75_5_, usertti5_.email as email3_75_5_, usertti5_.is_cqm as is_cqm5_75_5_, usertti5_.mocking_object_id as mocking_6_75_5_, usertti5_.name as name7_75_5_, usertti5_.object_id as object_i8_75_5_, usertti5_.user_role_id as user_rol9_75_5_, usertti6_.id as id1_75_6_, usertti6_.entity_tti as entity_t4_75_6_, usertti6_.branch_name as branch_n2_75_6_, usertti6_.email as email3_75_6_, usertti6_.is_cqm as is_cqm5_75_6_, usertti6_.mocking_object_id as mocking_6_75_6_, usertti6_.name as name7_75_6_, usertti6_.object_id as object_i8_75_6_, usertti6_.user_role_id as user_rol9_75_6_, usertti7_.id as id1_75_7_, usertti7_.entity_tti as entity_t4_75_7_, usertti7_.branch_name as branch_n2_75_7_, usertti7_.email as email3_75_7_, usertti7_.is_cqm as is_cqm5_75_7_, usertti7_.mocking_object_id as mocking_6_75_7_, usertti7_.name as name7_75_7_, usertti7_.object_id as object_i8_75_7_, usertti7_.user_role_id as user_rol9_75_7_, usertti8_.id as id1_75_8_, usertti8_.entity_tti as entity_t4_75_8_, usertti8_.branch_name as branch_n2_75_8_, usertti8_.email as email3_75_8_, usertti8_.is_cqm as is_cqm5_75_8_, usertti8_.mocking_object_id as mocking_6_75_8_, usertti8_.name as name7_75_8_, usertti8_.object_id as object_i8_75_8_, usertti8_.user_role_id as user_rol9_75_8_, usertti9_.id as id1_75_9_, usertti9_.entity_tti as entity_t4_75_9_, usertti9_.branch_name as branch_n2_75_9_, usertti9_.email as email3_75_9_, usertti9_.is_cqm as is_cqm5_75_9_, usertti9_.mocking_object_id as mocking_6_75_9_, usertti9_.name as name7_75_9_, usertti9_.object_id as object_i8_75_9_, usertti9_.user_role_id as user_rol9_75_9_, region10_.id as id1_55_10_, region10_.entity_tti as entity_t2_55_10_, region10_.name as name3_55_10_ from quote quote0_ left outer join user_tti usertti1_ on quote0_.cqm_id=usertti1_.id left outer join branch branch2_ on usertti1_.entity_tti=branch2_.entity_tti and usertti1_.branch_name=branch2_.name left outer join user_role userrole3_ on usertti1_.user_role_id=userrole3_.id left outer join user_tti usertti4_ on quote0_.fsr_id=usertti4_.id left outer join user_tti usertti5_ on quote0_.isr_id=usertti5_.id left outer join user_tti usertti6_ on quote0_.project_director_id=usertti6_.id left outer join user_tti usertti7_ on quote0_.quote_administrator_id=usertti7_.id left outer join user_tti usertti8_ on quote0_.quote_owner_id=usertti8_.id left outer join user_tti usertti9_ on quote0_.quote_requestor_id=usertti9_.id left outer join region region10_ on quote0_.region_id=region10_.id where quote0_.id=?
  136. Hibernate: select userrole0_.id as id1_73_0_, userrole0_.ad_group_name as ad_group2_73_0_, userrole0_.name as name3_73_0_ from user_role userrole0_ where userrole0_.id=?
  137. Hibernate: select account0_.account_id as account_1_0_, account0_.entity_tti as entity_t2_0_, account0_.system_id as system_i3_0_, account0_.branch_name as branch_20_0_, account0_.currency as currency4_0_, account0_.corporate_id as corpora21_0_, account0_.fsr_id as fsr_id5_0_, account0_.isr_id as isr_id6_0_, account0_.name as name7_0_, account0_.parent as parent8_0_, account0_.va_code_1 as va_code_9_0_, account0_.va_code_2 as va_code10_0_, account0_.va_code_3 as va_code11_0_, account0_.va_code_4 as va_code12_0_, account0_.va_code_5 as va_code13_0_, account0_.va_code_6 as va_code14_0_, account0_.warehouse_1 as warehou15_0_, account0_.warehouse_2 as warehou16_0_, account0_.warehouse_3 as warehou17_0_, account0_.warehouse_4 as warehou18_0_, account0_.warehouse_5 as warehou19_0_ from account account0_ where account0_.account_id=? and account0_.entity_tti=? order by account0_.name asc
  138. Hibernate: select branchsale0_.entity_tti as entity_t1_7_0_, branchsale0_.sales_branch_name as sales_br2_7_0_, branchsale0_.parent_branch_name as parent_b3_7_0_, branchsale0_.region_id as region_i4_7_0_ from branch_sales branchsale0_ where branchsale0_.entity_tti=? and branchsale0_.sales_branch_name=?
  139. Hibernate: select customer0_.corporate_id as corporat1_9_0_, customer0_.name as name2_9_0_, customer0_.system_id as system_i3_9_0_ from customer customer0_ where customer0_.corporate_id=?
  140. Hibernate: select quotelinei0_.id as col_0_0_ from quote_line_item quotelinei0_ left outer join quote_line_item_quantity quantities1_ on quotelinei0_.id=quantities1_.quote_line_item_id and (quantities1_.order_number=0) where quotelinei0_.quote_id=130 and (quotelinei0_.preferred_line is null or quotelinei0_.preferred_line=1) and 1=1 and (quotelinei0_.validation in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) or quotelinei0_.validation is null) and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 order by case when quantities1_.ext_cost is null then 1 else 0 end asc, quantities1_.ext_cost desc
  141. Hibernate: select quotelinei0_.id as id1_42_0_, quantities2_.id as id1_47_1_, valueaddcv4_.customer_number as customer1_80_2_, valueaddcv4_.va_code as va_code2_80_2_, valueaddmr6_.system_id as system_i1_81_3_, valueaddmr6_.va_code as va_code2_81_3_, valueaddmr6_.warehouse_location as warehous3_81_3_, tticolumn8_.id as id1_60_4_, internalco9_.id as id1_45_5_, assignees10_.quote_line_item_id as quote_li1_79_6_, assignees10_.user_id as user_id2_79_6_, quotelinei11_.id as id1_43_7_, quotelinei0_.all_mapped_columns_hash as all_mapp2_42_0_, quotelinei0_.approval_indicator as approval3_42_0_, quotelinei0_.assign_entity as assign_e4_42_0_, quotelinei0_.ats as ats5_42_0_, quotelinei0_.auto_scrubbed as auto_scr6_42_0_, quotelinei0_.avl_uuid as avl_uuid7_42_0_, quotelinei0_.branch_name as branch_n8_42_0_, quotelinei0_.branch_work_completed as branch_w9_42_0_, quotelinei0_.build_part_ind as build_p10_42_0_, quotelinei0_.bulk_updated_mfg as bulk_up11_42_0_, quotelinei0_.can_build as can_bui12_42_0_, quotelinei0_.category as categor13_42_0_, quotelinei0_.check_kros_file as check_k14_42_0_, quotelinei0_.client_id as client_15_42_0_, quotelinei0_.comments_to_customer as comment16_42_0_, quotelinei0_.contract_pricing_indicator as contrac17_42_0_, quotelinei0_.cost_labor as cost_la18_42_0_, quotelinei0_.cost_markup_unresolved as cost_ma19_42_0_, quotelinei0_.country_of_origin as country20_42_0_, quotelinei0_.cpn as cpn21_42_0_, quotelinei0_.currency as currenc22_42_0_, quotelinei0_.customer_comments as custome23_42_0_, quotelinei0_.date_completed as date_co24_42_0_, quotelinei0_.description as descrip25_42_0_, quotelinei0_.design_registrable as design_26_42_0_, quotelinei0_.fail_set_validation as fail_se27_42_0_, quotelinei0_.file_row_number as file_ro28_42_0_, quotelinei0_.from_ndc_stock as from_nd29_42_0_, quotelinei0_.has_comment as has_com30_42_0_, quotelinei0_.has_invalid_quantity as has_inv31_42_0_, quotelinei0_.has_multiple_choices as has_mul32_42_0_, quotelinei0_.has_previous_match as has_pre33_42_0_, quotelinei0_.in_history as in_hist34_42_0_, quotelinei0_.inventory as invento35_42_0_, quotelinei0_.isr_id as isr_id36_42_0_, quotelinei0_.lead_free as lead_fr37_42_0_, quotelinei0_.lead_time as lead_ti38_42_0_, quotelinei0_.manufacturer_alias as manufac39_42_0_, quotelinei0_.manufacturer_alias_order_number as manufac40_42_0_, quotelinei0_.mapped_columns_hash as mapped_41_42_0_, quotelinei0_.match_accuracy as match_a42_42_0_, quotelinei0_.mfg_updated as mfg_upd43_42_0_, quotelinei0_.is_modified_cost_markup as is_modi44_42_0_, quotelinei0_.movement_code as movemen45_42_0_, quotelinei0_.mult as mult46_42_0_, quotelinei0_.ncnr as ncnr47_42_0_, quotelinei0_.newly_added as newly_a48_42_0_, quotelinei0_.number_of_orders as number_49_42_0_, quotelinei0_.number_of_quotes as number_50_42_0_, quotelinei0_.on_hand as on_hand51_42_0_, quotelinei0_.on_order as on_orde52_42_0_, quotelinei0_.part_alias as part_al53_42_0_, quotelinei0_.part_alias_order_number as part_al54_42_0_, quotelinei0_.part_scrub_modified_by_id as part_sc55_42_0_, quotelinei0_.pkg_qty as pkg_qty56_42_0_, quotelinei0_.pkg_type as pkg_typ57_42_0_, quotelinei0_.preferred_line as preferr58_42_0_, quotelinei0_.product_class as product59_42_0_, quotelinei0_.quote_id as quote_i60_42_0_, quotelinei0_.quote_line_item_additional_id as quote_l70_42_0_, quotelinei0_.rohs as rohs61_42_0_, quotelinei0_.tti_description_part_scrub as tti_des62_42_0_, quotelinei0_.tti_manufacturer_cost_markup as tti_man63_42_0_, quotelinei0_.tti_manufacturer_part_scrub as tti_man64_42_0_, quotelinei0_.tti_part_number_cost_markup as tti_par65_42_0_, quotelinei0_.tti_part_number_part_scrub as tti_par66_42_0_, quotelinei0_.unresolved as unresol67_42_0_, quotelinei0_.updated as updated68_42_0_, quotelinei0_.validation as validat69_42_0_, quantities2_.call_pm as call_pm2_47_1_, quantities2_.conn_discount as conn_dis3_47_1_, quantities2_.cost as cost4_47_1_, quantities2_.cost_source as cost_sou5_47_1_, quantities2_.cost_source_entity as cost_sou6_47_1_, quantities2_.ext_cost as ext_cost7_47_1_, quantities2_.ext_resale as ext_resa8_47_1_, quantities2_.gp_dollar as gp_dolla9_47_1_, quantities2_.manually_updated_margin as manuall10_47_1_, quantities2_.margin as margin11_47_1_, quantities2_.min as min12_47_1_, quantities2_.order_number as order_n13_47_1_, quantities2_.quantity as quantit14_47_1_, quantities2_.quote_line_item_id as quote_l22_47_1_, quantities2_.quote_line_item_quantity_status as quote_l15_47_1_, quantities2_.quoted_quantity as quoted_16_47_1_, quantities2_.resale as resale17_47_1_, quantities2_.resale_precision as resale_18_47_1_, quantities2_.resale_source as resale_19_47_1_, quantities2_.va_charges as va_char20_47_1_, quantities2_.va_margin as va_marg21_47_1_, quantities2_.quote_line_item_id as quote_l22_47_0__, quantities2_.id as id1_47_0__, valueaddcv4_.distributors_number as distribu3_80_2_, valueaddcv4_.environment as environm4_80_2_, valueaddcv4_.max_cost_pieces as max_cost5_80_2_, valueaddcv4_.min_cost as min_cost6_80_2_, valueaddcv4_.system_id as system_i7_80_2_, valueaddcv4_.unit_cost as unit_cos8_80_2_, valueaddcv3_.quote_line_item_quantity_id as quote_li1_30_1__, valueaddcv3_.va_cva_customer_number as va_cva_c2_30_1__, valueaddcv3_.va_cva_code as va_cva_c3_30_1__, valueaddmr6_.distributors_number as distribu4_81_3_, valueaddmr6_.environment as environm5_81_3_, valueaddmr6_.max_cost_pieces as max_cost6_81_3_, valueaddmr6_.min_cost as min_cost7_81_3_, valueaddmr6_.unit_cost as unit_cos8_81_3_, valueaddmr5_.quote_line_item_quantity_id as quote_li1_31_2__, valueaddmr5_.system_id as system_i2_31_2__, valueaddmr5_.va_code as va_code3_31_2__, valueaddmr5_.warehouse_location as warehous4_31_2__, tticolumn8_.can_multi_map as can_mult2_60_4_, tticolumn8_.column_in_value as column_i3_60_4_, tticolumn8_.column_name as column_n4_60_4_, tticolumn8_.column_type as column_t5_60_4_, tticolumn8_.data_type as data_typ6_60_4_, mappedcolu7_.quote_line_item_id as quote_li1_29_3__, mappedcolu7_.mapped_column_id as mapped_c2_29_3__, internalco9_.comment as comment2_45_5_, internalco9_.comment_date as comment_3_45_5_, internalco9_.quote_line_item_id as quote_li5_45_5_, internalco9_.username as username4_45_5_, internalco9_.quote_line_item_id as quote_li5_45_4__, internalco9_.id as id1_45_4__, assignees10_.quote_line_item_comment_id as quote_li3_79_6_, assignees10_.quote_line_item_id as quote_li1_79_5__, assignees10_.user_id as user_id2_79_5__, quotelinei11_.add_date as add_date2_43_7_, quotelinei11_.alternative_tti_manufacturer as alternat3_43_7_, quotelinei11_.alternative_tti_part_number as alternat4_43_7_, quotelinei11_.available_on_order as availabl5_43_7_, quotelinei11_.available_on_order_date as availabl6_43_7_, quotelinei11_.average_cost as average_7_43_7_, quotelinei11_.buy_cost as buy_cost8_43_7_, quotelinei11_.cancellation_window as cancella9_43_7_, quotelinei11_.commodity as commodi10_43_7_, quotelinei11_.country_of_origin as country11_43_7_, quotelinei11_.delivery_terms as deliver12_43_7_, quotelinei11_.eccn as eccn13_43_7_, quotelinei11_.entity_tti as entity_14_43_7_, quotelinei11_.hts_code as hts_cod15_43_7_, quotelinei11_.inco_terms as inco_te16_43_7_, quotelinei11_.info1 as info17_43_7_, quotelinei11_.info2 as info18_43_7_, quotelinei11_.last_received_date as last_re19_43_7_, quotelinei11_.min_buy_quantity as min_buy20_43_7_, quotelinei11_.mrp_back_ordered as mrp_bac21_43_7_, quotelinei11_.no_bid_reason as no_bid_22_43_7_, quotelinei11_.no_of_customers as no_of_c23_43_7_, quotelinei11_.number_of_customers as number_24_43_7_, quotelinei11_.number_of_sales as number_25_43_7_, quotelinei11_.order_date as order_d26_43_7_, quotelinei11_.order_margin as order_m27_43_7_, quotelinei11_.order_resale as order_r28_43_7_, quotelinei11_.payment_terms as payment29_43_7_, quotelinei11_.pm_code as pm_code30_43_7_, quotelinei11_.product_description as product31_43_7_, quotelinei11_.quantity as quantit32_43_7_, quotelinei11_.quote_history_date as quote_h33_43_7_, quotelinei11_.quote_history_margin as quote_h34_43_7_, quotelinei11_.quote_history_resale as quote_h35_43_7_, quotelinei11_.replacement_cost as replace36_43_7_, quotelinei11_.resale_base_price_prm as resale_37_43_7_, quotelinei11_.resale_info as resale_38_43_7_, quotelinei11_.reschedule_window as resched39_43_7_, quotelinei11_.sales_cost as sales_c40_43_7_, quotelinei11_.sales_info as sales_i41_43_7_, quotelinei11_.shipping_point as shippin42_43_7_, quotelinei11_.so_approval_index as so_appr43_43_7_, quotelinei11_.special_cost as special44_43_7_, quotelinei11_.tariff_charge as tariff_45_43_7_, quotelinei11_.tariff_indicator as tariff_46_43_7_, quotelinei11_.tariff_rate as tariff_47_43_7_, quotelinei11_.tti_so_mult as tti_so_48_43_7_, quotelinei11_.warehouse_location as warehou49_43_7_ from quote_line_item quotelinei0_ left outer join quote_line_item_quantity quantities1_ on quotelinei0_.id=quantities1_.quote_line_item_id and (quantities1_.order_number=0) left outer join quote_line_item_quantity quantities2_ on quotelinei0_.id=quantities2_.quote_line_item_id left outer join quote_line_item_quantity_va_cva valueaddcv3_ on quantities2_.id=valueaddcv3_.quote_line_item_quantity_id left outer join value_add_cva valueaddcv4_ on valueaddcv3_.va_cva_customer_number=valueaddcv4_.customer_number and valueaddcv3_.va_cva_code=valueaddcv4_.va_code left outer join quote_line_item_quantity_va_mrf valueaddmr5_ on quantities2_.id=valueaddmr5_.quote_line_item_quantity_id left outer join value_add_mrf valueaddmr6_ on valueaddmr5_.system_id=valueaddmr6_.system_id and valueaddmr5_.va_code=valueaddmr6_.va_code and valueaddmr5_.warehouse_location=valueaddmr6_.warehouse_location left outer join quote_line_item_mapped_columns mappedcolu7_ on quotelinei0_.id=mappedcolu7_.quote_line_item_id left outer join tti_column tticolumn8_ on mappedcolu7_.mapped_column_id=tticolumn8_.id left outer join quote_line_item_comment internalco9_ on quotelinei0_.id=internalco9_.quote_line_item_id left outer join user_tti_quote_line_item assignees10_ on quotelinei0_.id=assignees10_.quote_line_item_id left outer join quote_line_item_additional quotelinei11_ on quotelinei0_.quote_line_item_additional_id=quotelinei11_.id where (quotelinei0_.id in (102665 , 102654 , 102655 , 102657 , 102663 , 102652 , 102667 , 102659 , 102661)) and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 and 1=1 order by case when quantities1_.ext_cost is null then 1 else 0 end asc, quantities1_.ext_cost desc
  142. Hibernate: select quotelinei0_.id as id1_42_0_, quotelinei1_.id as id1_43_1_, tticolumn3_.id as id1_60_2_, assignees4_.quote_line_item_id as quote_li1_79_3_, assignees4_.user_id as user_id2_79_3_, internalco5_.id as id1_45_4_, quantities6_.id as id1_47_5_, valueaddmr8_.system_id as system_i1_81_6_, valueaddmr8_.va_code as va_code2_81_6_, valueaddmr8_.warehouse_location as warehous3_81_6_, valueaddcv10_.customer_number as customer1_80_7_, valueaddcv10_.va_code as va_code2_80_7_, quotelinei0_.all_mapped_columns_hash as all_mapp2_42_0_, quotelinei0_.approval_indicator as approval3_42_0_, quotelinei0_.assign_entity as assign_e4_42_0_, quotelinei0_.ats as ats5_42_0_, quotelinei0_.auto_scrubbed as auto_scr6_42_0_, quotelinei0_.avl_uuid as avl_uuid7_42_0_, quotelinei0_.branch_name as branch_n8_42_0_, quotelinei0_.branch_work_completed as branch_w9_42_0_, quotelinei0_.build_part_ind as build_p10_42_0_, quotelinei0_.bulk_updated_mfg as bulk_up11_42_0_, quotelinei0_.can_build as can_bui12_42_0_, quotelinei0_.category as categor13_42_0_, quotelinei0_.check_kros_file as check_k14_42_0_, quotelinei0_.client_id as client_15_42_0_, quotelinei0_.comments_to_customer as comment16_42_0_, quotelinei0_.contract_pricing_indicator as contrac17_42_0_, quotelinei0_.cost_labor as cost_la18_42_0_, quotelinei0_.cost_markup_unresolved as cost_ma19_42_0_, quotelinei0_.country_of_origin as country20_42_0_, quotelinei0_.cpn as cpn21_42_0_, quotelinei0_.currency as currenc22_42_0_, quotelinei0_.customer_comments as custome23_42_0_, quotelinei0_.date_completed as date_co24_42_0_, quotelinei0_.description as descrip25_42_0_, quotelinei0_.design_registrable as design_26_42_0_, quotelinei0_.fail_set_validation as fail_se27_42_0_, quotelinei0_.file_row_number as file_ro28_42_0_, quotelinei0_.from_ndc_stock as from_nd29_42_0_, quotelinei0_.has_comment as has_com30_42_0_, quotelinei0_.has_invalid_quantity as has_inv31_42_0_, quotelinei0_.has_multiple_choices as has_mul32_42_0_, quotelinei0_.has_previous_match as has_pre33_42_0_, quotelinei0_.in_history as in_hist34_42_0_, quotelinei0_.inventory as invento35_42_0_, quotelinei0_.isr_id as isr_id36_42_0_, quotelinei0_.lead_free as lead_fr37_42_0_, quotelinei0_.lead_time as lead_ti38_42_0_, quotelinei0_.manufacturer_alias as manufac39_42_0_, quotelinei0_.manufacturer_alias_order_number as manufac40_42_0_, quotelinei0_.mapped_columns_hash as mapped_41_42_0_, quotelinei0_.match_accuracy as match_a42_42_0_, quotelinei0_.mfg_updated as mfg_upd43_42_0_, quotelinei0_.is_modified_cost_markup as is_modi44_42_0_, quotelinei0_.movement_code as movemen45_42_0_, quotelinei0_.mult as mult46_42_0_, quotelinei0_.ncnr as ncnr47_42_0_, quotelinei0_.newly_added as newly_a48_42_0_, quotelinei0_.number_of_orders as number_49_42_0_, quotelinei0_.number_of_quotes as number_50_42_0_, quotelinei0_.on_hand as on_hand51_42_0_, quotelinei0_.on_order as on_orde52_42_0_, quotelinei0_.part_alias as part_al53_42_0_, quotelinei0_.part_alias_order_number as part_al54_42_0_, quotelinei0_.part_scrub_modified_by_id as part_sc55_42_0_, quotelinei0_.pkg_qty as pkg_qty56_42_0_, quotelinei0_.pkg_type as pkg_typ57_42_0_, quotelinei0_.preferred_line as preferr58_42_0_, quotelinei0_.product_class as product59_42_0_, quotelinei0_.quote_id as quote_i60_42_0_, quotelinei0_.quote_line_item_additional_id as quote_l70_42_0_, quotelinei0_.rohs as rohs61_42_0_, quotelinei0_.tti_description_part_scrub as tti_des62_42_0_, quotelinei0_.tti_manufacturer_cost_markup as tti_man63_42_0_, quotelinei0_.tti_manufacturer_part_scrub as tti_man64_42_0_, quotelinei0_.tti_part_number_cost_markup as tti_par65_42_0_, quotelinei0_.tti_part_number_part_scrub as tti_par66_42_0_, quotelinei0_.unresolved as unresol67_42_0_, quotelinei0_.updated as updated68_42_0_, quotelinei0_.validation as validat69_42_0_, quotelinei1_.add_date as add_date2_43_1_, quotelinei1_.alternative_tti_manufacturer as alternat3_43_1_, quotelinei1_.alternative_tti_part_number as alternat4_43_1_, quotelinei1_.available_on_order as availabl5_43_1_, quotelinei1_.available_on_order_date as availabl6_43_1_, quotelinei1_.average_cost as average_7_43_1_, quotelinei1_.buy_cost as buy_cost8_43_1_, quotelinei1_.cancellation_window as cancella9_43_1_, quotelinei1_.commodity as commodi10_43_1_, quotelinei1_.country_of_origin as country11_43_1_, quotelinei1_.delivery_terms as deliver12_43_1_, quotelinei1_.eccn as eccn13_43_1_, quotelinei1_.entity_tti as entity_14_43_1_, quotelinei1_.hts_code as hts_cod15_43_1_, quotelinei1_.inco_terms as inco_te16_43_1_, quotelinei1_.info1 as info17_43_1_, quotelinei1_.info2 as info18_43_1_, quotelinei1_.last_received_date as last_re19_43_1_, quotelinei1_.min_buy_quantity as min_buy20_43_1_, quotelinei1_.mrp_back_ordered as mrp_bac21_43_1_, quotelinei1_.no_bid_reason as no_bid_22_43_1_, quotelinei1_.no_of_customers as no_of_c23_43_1_, quotelinei1_.number_of_customers as number_24_43_1_, quotelinei1_.number_of_sales as number_25_43_1_, quotelinei1_.order_date as order_d26_43_1_, quotelinei1_.order_margin as order_m27_43_1_, quotelinei1_.order_resale as order_r28_43_1_, quotelinei1_.payment_terms as payment29_43_1_, quotelinei1_.pm_code as pm_code30_43_1_, quotelinei1_.product_description as product31_43_1_, quotelinei1_.quantity as quantit32_43_1_, quotelinei1_.quote_history_date as quote_h33_43_1_, quotelinei1_.quote_history_margin as quote_h34_43_1_, quotelinei1_.quote_history_resale as quote_h35_43_1_, quotelinei1_.replacement_cost as replace36_43_1_, quotelinei1_.resale_base_price_prm as resale_37_43_1_, quotelinei1_.resale_info as resale_38_43_1_, quotelinei1_.reschedule_window as resched39_43_1_, quotelinei1_.sales_cost as sales_c40_43_1_, quotelinei1_.sales_info as sales_i41_43_1_, quotelinei1_.shipping_point as shippin42_43_1_, quotelinei1_.so_approval_index as so_appr43_43_1_, quotelinei1_.special_cost as special44_43_1_, quotelinei1_.tariff_charge as tariff_45_43_1_, quotelinei1_.tariff_indicator as tariff_46_43_1_, quotelinei1_.tariff_rate as tariff_47_43_1_, quotelinei1_.tti_so_mult as tti_so_48_43_1_, quotelinei1_.warehouse_location as warehou49_43_1_, tticolumn3_.can_multi_map as can_mult2_60_2_, tticolumn3_.column_in_value as column_i3_60_2_, tticolumn3_.column_name as column_n4_60_2_, tticolumn3_.column_type as column_t5_60_2_, tticolumn3_.data_type as data_typ6_60_2_, mappedcolu2_.quote_line_item_id as quote_li1_29_0__, mappedcolu2_.mapped_column_id as mapped_c2_29_0__, assignees4_.quote_line_item_comment_id as quote_li3_79_3_, assignees4_.quote_line_item_id as quote_li1_79_1__, assignees4_.user_id as user_id2_79_1__, internalco5_.comment as comment2_45_4_, internalco5_.comment_date as comment_3_45_4_, internalco5_.quote_line_item_id as quote_li5_45_4_, internalco5_.username as username4_45_4_, internalco5_.quote_line_item_id as quote_li5_45_2__, internalco5_.id as id1_45_2__, quantities6_.call_pm as call_pm2_47_5_, quantities6_.conn_discount as conn_dis3_47_5_, quantities6_.cost as cost4_47_5_, quantities6_.cost_source as cost_sou5_47_5_, quantities6_.cost_source_entity as cost_sou6_47_5_, quantities6_.ext_cost as ext_cost7_47_5_, quantities6_.ext_resale as ext_resa8_47_5_, quantities6_.gp_dollar as gp_dolla9_47_5_, quantities6_.manually_updated_margin as manuall10_47_5_, quantities6_.margin as margin11_47_5_, quantities6_.min as min12_47_5_, quantities6_.order_number as order_n13_47_5_, quantities6_.quantity as quantit14_47_5_, quantities6_.quote_line_item_id as quote_l22_47_5_, quantities6_.quote_line_item_quantity_status as quote_l15_47_5_, quantities6_.quoted_quantity as quoted_16_47_5_, quantities6_.resale as resale17_47_5_, quantities6_.resale_precision as resale_18_47_5_, quantities6_.resale_source as resale_19_47_5_, quantities6_.va_charges as va_char20_47_5_, quantities6_.va_margin as va_marg21_47_5_, quantities6_.quote_line_item_id as quote_l22_47_3__, quantities6_.id as id1_47_3__, valueaddmr8_.distributors_number as distribu4_81_6_, valueaddmr8_.environment as environm5_81_6_, valueaddmr8_.max_cost_pieces as max_cost6_81_6_, valueaddmr8_.min_cost as min_cost7_81_6_, valueaddmr8_.unit_cost as unit_cos8_81_6_, valueaddmr7_.quote_line_item_quantity_id as quote_li1_31_4__, valueaddmr7_.system_id as system_i2_31_4__, valueaddmr7_.va_code as va_code3_31_4__, valueaddmr7_.warehouse_location as warehous4_31_4__, valueaddcv10_.distributors_number as distribu3_80_7_, valueaddcv10_.environment as environm4_80_7_, valueaddcv10_.max_cost_pieces as max_cost5_80_7_, valueaddcv10_.min_cost as min_cost6_80_7_, valueaddcv10_.system_id as system_i7_80_7_, valueaddcv10_.unit_cost as unit_cos8_80_7_, valueaddcv9_.quote_line_item_quantity_id as quote_li1_30_5__, valueaddcv9_.va_cva_customer_number as va_cva_c2_30_5__, valueaddcv9_.va_cva_code as va_cva_c3_30_5__ from quote_line_item quotelinei0_ left outer join quote_line_item_additional quotelinei1_ on quotelinei0_.quote_line_item_additional_id=quotelinei1_.id left outer join quote_line_item_mapped_columns mappedcolu2_ on quotelinei0_.id=mappedcolu2_.quote_line_item_id left outer join tti_column tticolumn3_ on mappedcolu2_.mapped_column_id=tticolumn3_.id left outer join user_tti_quote_line_item assignees4_ on quotelinei0_.id=assignees4_.quote_line_item_id left outer join quote_line_item_comment internalco5_ on quotelinei0_.id=internalco5_.quote_line_item_id left outer join quote_line_item_quantity quantities6_ on quotelinei0_.id=quantities6_.quote_line_item_id left outer join quote_line_item_quantity_va_mrf valueaddmr7_ on quantities6_.id=valueaddmr7_.quote_line_item_quantity_id left outer join value_add_mrf valueaddmr8_ on valueaddmr7_.system_id=valueaddmr8_.system_id and valueaddmr7_.va_code=valueaddmr8_.va_code and valueaddmr7_.warehouse_location=valueaddmr8_.warehouse_location left outer join quote_line_item_quantity_va_cva valueaddcv9_ on quantities6_.id=valueaddcv9_.quote_line_item_quantity_id left outer join value_add_cva valueaddcv10_ on valueaddcv9_.va_cva_customer_number=valueaddcv10_.customer_number and valueaddcv9_.va_cva_code=valueaddcv10_.va_code where quotelinei0_.quote_id=? and (quotelinei0_.file_row_number in (? , ? , ? , ? , ? , ? , ? , ? , ?)) and quotelinei0_.preferred_line=0 order by quotelinei0_.file_row_number asc
  143. Hibernate: select TOP(?) userttiquo0_.user_id as col_0_0_, userttiquo0_.quote_assignment_id as col_1_0_ from user_tti_quote_assignment userttiquo0_ left outer join quote_assignment quoteassig1_ on userttiquo0_.quote_assignment_id=quoteassig1_.id where quoteassig1_.quote_id=? and userttiquo0_.user_id=? and userttiquo0_.partial_assign=0
  144. Hibernate: select notificati0_.id as id1_19_0_, values1_.id as id1_20_1_, notificati0_.condition as conditio2_19_0_, notificati0_.email as email3_19_0_, notificati0_.in_app as in_app4_19_0_, notificati0_.number_value as number_v5_19_0_, notificati0_.user_id as user_id6_19_0_, notificati0_.value as value7_19_0_, values1_.notification_rule_id as notifica3_20_1_, values1_.value as value2_20_1_, values1_.notification_rule_id as notifica3_20_0__, values1_.id as id1_20_0__ from notification_rule notificati0_ left outer join notification_rule_value values1_ on notificati0_.id=values1_.notification_rule_id where notificati0_.condition in (? , ?)
  145.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!