pulsedb

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
db_change_push

    • -0
    • +211
    ./packages/uap_deferred_sessions.sql
    • -0
    • +219
    ./packages/us_deferred_sessions.sql
    • -16
    • +74
    ./procedures/calculate_min_max.sql
    • -4
    • +49
    ./procedures/create_new_dollar_session.sql
    • -5
    • +4
    ./procedures/create_new_inv_seeding_session.sql
    • -2
    • +1
    ./procedures/create_new_minmax_session.sql
    • -35
    • +177
    ./procedures/create_new_session.sql
    • -8
    • +21
    ./procedures/create_new_sku_session.sql
    • -7
    • +14
    ./procedures/del_sessions_marked_expired.sql
    • -11
    • +26
    ./procedures/del_transmitted_sessions.sql
    • -3
    • +44
    ./procedures/uap_create_new_dollar_session.sql
    • -45
    • +86
    ./procedures/uap_create_new_session.sql
    • -7
    • +19
    ./procedures/uap_create_new_sku_session.sql
    • -0
    • +23
    ./procedures/uap_post_store_sales_rollup.sql
    • -0
    • +23
    ./procedures/uap_truncate_store_dc_sales.sql
  1. … 20 more files in changeset.
GIT LAB TABLE DDL-03 july-23

    • -0
    • +10
    ./tables/PULSEUI_TABLE_ACO_BLACKOUT_SCHEDULE.sql
    • -0
    • +20
    ./tables/PULSEUI_TABLE_ACO_DUP_REPORT_DASHBOARD.sql
    • -0
    • +15
    ./tables/PULSEUI_TABLE_ACO_DUP_REPORT_OUTPUT.sql
    • -0
    • +33
    ./tables/PULSEUI_TABLE_ACO_DUP_REPORT_PIVOT_FINAL.sql
    • -0
    • +15
    ./tables/PULSEUI_TABLE_ACO_PREFERENCES.sql
    • -0
    • +13
    ./tables/PULSEUI_TABLE_ACO_SITE_HIERARCHY.sql
    • -0
    • +11
    ./tables/PULSEUI_TABLE_ACO_STATUS.sql
    • -0
    • +9
    ./tables/PULSEUI_TABLE_ADHOC_BLOCKOUT_SCHEDULE_BK.sql
    • -0
    • +11
    ./tables/PULSEUI_TABLE_BK_NEW_NUMBERS.sql
    • -0
    • +10
    ./tables/PULSEUI_TABLE_BK_NICHE_PRODUCT_MAPPING.sql
    • -0
    • +16
    ./tables/PULSEUI_TABLE_BK_PULSE_TRAINING_RESOURCE.sql
    • -0
    • +47
    ./tables/PULSEUI_TABLE_BK_SITE_02012022.sql
    • -0
    • +8
    ./tables/PULSEUI_TABLE_BK_TRANSFER_MAPPING.sql
    • -0
    • +8
    ./tables/PULSEUI_TABLE_BK_TRANSFER_MAPPING_HIERARCHY.sql
    • -0
    • +11
    ./tables/PULSEUI_TABLE_BK_TRANSFER_MAPPING_HUB.sql
  1. … 423 more files in changeset.
Match Gitlab master branch with prod scripts - Tables -US

    • -36
    • +14
    ./tables/ma_inv_coll_hierarchy.sql
    • -24
    • +12
    ./tables/ma_inv_coll_template.sql
    • -32
    • +15
    ./tables/ma_investment_collection.sql
    • -21
    • +21
    ./tables/major_account_site_stage.sql
    • -10
    • +10
    ./tables/major_account_stage.sql
  1. … 107 more files in changeset.
Added new API for Business Rules Roll back

    • -0
    • +22
    ./procedures/update_site_paramter_all.sql
  1. … 7 more files in changeset.
    • -278
    • +0
    ./procedures/CREATE_NEW_INV_SEEDING_SESSION.sql
    • -20
    • +20
    ./procedures/aco_coverage_update.sql
    • -17
    • +14
    ./procedures/add_sales_demand_systems_inv.sql
    • -10
    • +10
    ./procedures/add_systems_inventory.sql
    • -3
    • +3
    ./procedures/cal_decouple_totals_up.sql
    • -3
    • +3
    ./procedures/cal_forecast_criticality.sql
    • -3
    • +3
    ./procedures/cal_forecast_criticality_sess.sql
    • -3
    • +3
    ./procedures/cal_totals_site_hierarchy.sql
    • -29
    • +29
    ./procedures/cal_totals_site_sess_hier_tmp.sql
    • -3
    • +3
    ./procedures/calc_spa_totals_below.sql
    • -2
    • +2
    ./procedures/calc_total_save_ord_ret.sql
    • -201
    • +237
    ./procedures/calculate_min_max.sql
  1. … 257 more files in changeset.
update db trigger function script

    • -3
    • +3
    ./functions/supersede_products_by_site.sql
    • -0
    • +57
    ./functions/uap_ma_ifiu_product.sql
    • -0
    • +24
    ./functions/uap_nearest_even_number.sql
    • -0
    • +18
    ./functions/uap_nearest_multiple.sql
    • -0
    • +52
    ./functions/uap_supersede_products_by_site.sql
    • -0
    • +13
    ./triggers/audit_trbi_file_log_key.sql
    • -0
    • +13
    ./triggers/audit_trbi_files_key.sql
    • -0
    • +10
    ./triggers/audit_trbu_files_modify_dttm.sql
    • -0
    • +12
    ./triggers/group_field_tr.sql
  1. … 30 more files in changeset.
Revert "Merge branch 'PUL-8329' into 'Anil-Special'"

This reverts merge request !743

    • -23
    • +22
    ./procedures/add_similar_parts.sql
    • -10
    • +2
    ./procedures/cross_populate_sns_parts.sql
    • -12
    • +0
    ./procedures/uap_sp_pulse_rules.sql
    • -155
    • +0
    ./scripts/new_numbers_cycle3.sql
  1. … 15 more files in changeset.
PUL-8255_DC Sales Not Populated in DC Sessions

    • -22
    • +23
    ./procedures/add_similar_parts.sql
    • -2
    • +10
    ./procedures/cross_populate_sns_parts.sql
PUL-8246_PUL-8256

PUL-8131_Block NL & SD Class Items from Order

    • -0
    • +12
    ./procedures/uap_sp_pulse_rules.sql
PUL-8158_NewNumberCategories - Add NOE

    • -0
    • +155
    ./scripts/new_numbers_cycle3.sql
PUL_8256_ChangeRuleforNBLines

    • -46
    • +72
    ./procedures/calculate_min_max.sql
PUL_8258_DeleteDCRule

    • -1
    • +1
    ./procedures/uap_sp_pulse_rules_isp_change.sql
    • -1
    • +1
    ./procedures/uap_sp_pulse_rules_isp_global.sql
    • -19
    • +42
    ./procedures/us_sp_pulse_rules.sql
    • -66
    • +33
    ./procedures/us_sp_pulse_rules_isp_change.sql
    • -46
    • +26
    ./procedures/us_sp_pulse_rules_isp_global.sql
PUL-8148_Transfer Mapping - Keep Items Stocking at Hub with 1+ demand

    • -9
    • +112
    ./procedures/create_new_session.sql
    • -5
    • +48
    ./procedures/create_new_sku_session.sql
    • -8
    • +109
    ./procedures/uap_create_new_session.sql
    • -8
    • +27
    ./procedures/uap_create_new_sku_session.sql
PUL-8173_DC Net Sales: Add to Adv Filter and Bulk Edit capable

    • -3
    • +11
    ./procedures/CREATE_NEW_INV_SEEDING_SESSION.sql
    • -20
    • +18
    ./procedures/create_new_dollar_session.sql
    • -14
    • +90
    ./procedures/create_new_session.sql
    • -2
    • +10
    ./procedures/create_new_sku_session.sql
    • -18
    • +17
    ./procedures/uap_create_new_dollar_session.sql
    • -45
    • +84
    ./procedures/uap_create_new_session.sql
    • -1
    • +9
    ./procedures/uap_create_new_sku_session.sql
    • -38
    • +42
    ./procedures/create_new_session.sql
    • -5
    • +52
    ./procedures/recalc_session_totals.sql
PUL-8150_Min-Max Session - No Session Data when 61+ Sites Selected

    • -10
    • +23
    ./packages/deferred_sessions.sql
PUL_8102

    • -2
    • +15
    ./procedures/uap_sp_pulse_rules.sql
    • -0
    • +13
    ./procedures/uap_sp_pulse_rules_isp_change.sql
    • -0
    • +13
    ./procedures/uap_sp_pulse_rules_isp_global.sql
    • -3
    • +19
    ./procedures/us_sp_pulse_rules_isp_change.sql
    • -3
    • +20
    ./procedures/us_sp_pulse_rules_isp_global.sql
PUL_8031

    • -1
    • +1
    ./procedures/cross_populate_sns_parts.sql
PUL_8102

    • -52
    • +78
    ./procedures/us_sp_pulse_rules.sql
PUL_8031

    • -92
    • +58
    ./procedures/cross_populate_sns_parts.sql
PUL_8114

    • -23
    • +50
    ./procedures/create_new_session.sql
    • -234
    • +107
    ./procedures/create_new_session.sql
    • -0
    • +72
    ./procedures/update_hs_parts.sql
PUL_8060

    • -15
    • +22
    ./procedures/calculate_min_max.sql
    • -318
    • +322
    ./procedures/create_new_session.sql
    • -420
    • +312
    ./procedures/us_sp_pulse_rules.sql
    • -91
    • +64
    ./procedures/us_sp_pulse_rules_isp_change.sql
PUL-8026_Hub Spoke: Hub sliders w/ PTS=0 not reflected in new sessions

    • -194
    • +162
    ./procedures/create_new_session.sql
PUL_8036_Min Max: session creation option: Do not update Min if Current Min > Per Car

PUL-7907_BlockReturnAbility

PUL-7919_HierarchiesForUAPNewNumbers

    • -17
    • +33
    ./procedures/uap_create_new_session.sql
PUL-7929_Transfer Mapping/Sales - update logic for Warehouse only locations

PUL-7907_BlockReturnAbility

    • -1
    • +25
    ./procedures/uap_sp_pulse_rules.sql
    • -0
    • +24
    ./procedures/uap_sp_pulse_rules_isp_change.sql
    • -0
    • +24
    ./procedures/uap_sp_pulse_rules_isp_global.sql
    • -0
    • +26
    ./procedures/us_sp_pulse_rules_isp_change.sql
    • -0
    • +27
    ./procedures/us_sp_pulse_rules_isp_global.sql