APPS.INV_VENDORMERGE_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 61

      update MTL_INTERCOMPANY_PARAMETERS
      set vendor_id   = p_vendor_id
      where vendor_id = p_dup_vendor_id;

Line: 65

      update MTL_KANBAN_CARDS
      set supplier_id   = p_vendor_id
      where supplier_id = p_dup_vendor_id;

Line: 69

      update MTL_KANBAN_CARD_ACTIVITY
      set supplier_id   = p_vendor_id
      where supplier_id = p_dup_vendor_id;

Line: 73

      update MTL_KANBAN_PULL_SEQUENCES
      set supplier_id   = p_vendor_id
      where supplier_id = p_dup_vendor_id;

Line: 77

      update MTL_SERIAL_NUMBERS
      set original_unit_vendor_id   = p_vendor_id
      where original_unit_vendor_id = p_dup_vendor_id;

Line: 91

      update MTL_INTERCOMPANY_PARAMETERS
      set vendor_site_id   = p_vendor_site_id
      where vendor_site_id = p_dup_vendor_site_id;

Line: 95

      update MTL_KANBAN_CARDS
      set supplier_site_id = p_vendor_site_id
      where supplier_site_id = p_dup_vendor_site_id;

Line: 99

      update MTL_KANBAN_CARD_ACTIVITY
      set supplier_site_id = p_vendor_site_id
      where supplier_site_id = p_dup_vendor_site_id;

Line: 103

      update MTL_KANBAN_PULL_SEQUENCES
      set supplier_site_id = p_vendor_site_id
      where supplier_site_id = p_dup_vendor_site_id;