APPS.ZPB_REPOS SQL Statements

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

Line: 17

  update ZPB_CYCLE_MODEL_DIMENSIONS
  set QUERY_OBJECT_PATH = new_root||QUERY_OBJECT_PATH
  where QUERY_OBJECT_PATH like 'ZPBSystem/%';

Line: 24

  update ZPB_DC_OBJECTS
  set target_obj_path = new_root||target_obj_path
  where target_obj_path like 'ZPBSystem/%';

Line: 31

  update ZPB_DC_OBJECTS
  set dataentry_obj_path = new_root||dataentry_obj_path
  where dataentry_obj_path like 'ZPBSystem/%';

Line: 38

  update zpb_status_sql
  set QUERY_PATH = new_root||QUERY_PATH
  where QUERY_PATH like 'ZPBSystem/%';

Line: 45

  update ZPB_DEPENDENT_OBJECTS
  set document_name = new_root||document_name
  where document_name like '%/%';

Line: 52

  update ZPB_DEPENDENT_OBJECTS
  set saved_selection_name = new_root||saved_selection_name
  where saved_selection_name like '%/%';

Line: 59

  update ZPB_WRITEBACK_TRANSACTION
  set QDR = new_root||QDR
  where QDR like 'ZPBSystem/%';

Line: 66

  update zpb_line_dimensionality
  set sum_selection_path = new_root||sum_selection_path
  where sum_selection_path like 'ZPBSystem/%';

Line: 73

  update zpb_task_parameters
  set VALUE = new_root||VALUE
  where value like 'ZPBSystem/%';

Line: 80

  update ZPB_SOLVE_OUTPUT_SELECTIONS
  set selection_path = new_root||selection_path
  where selection_path like 'ZPBSystem/%';

Line: 85

                 'Upgrade of ZPB_SOLVE_OUTPUT_SELECTIONS complete');

Line: 87

  update ZPB_SOLVE_INPUT_SELECTIONS
  set selection_path = new_root||selection_path
  where selection_path like 'ZPBSystem/%';

Line: 92

                 'Upgrade of ZPB_SOLVE_INPUT_SELECTIONS complete');