APPS.CHV_REBUILD_SCHEDULES SQL Statements

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

Line: 53

  SELECT schedule_item_id
  FROM   chv_schedule_items
  WHERE  schedule_id = p_schedule_id
  AND    rebuild_flag = 'Y';

Line: 71

  SELECT bucket_pattern_id,
	 vendor_id,
	 vendor_site_id,
	 organization_id,
	 mrp_compile_designator,
	 mps_schedule_designator,
	 drp_compile_designator,
	 schedule_subtype,
	 schedule_type,
	 schedule_horizon_start,
	 include_future_releases_flag
  INTO   x_bucket_pattern_id,
         x_vendor_id,
         x_vendor_site_id,
         x_organization_id,
         x_mrp_compile_designator,
         x_mps_schedule_designator,
         x_drp_compile_designator,
	 x_schedule_subtype,
	 x_schedule_type,
	 x_horizon_start_date,
	 x_include_future_releases
  FROM   chv_schedule_headers
  WHERE  schedule_id = p_schedule_id;

Line: 136

      DELETE FROM chv_item_orders
      WHERE schedule_id = p_schedule_id
      AND   schedule_item_id = x_schedule_item_id;

Line: 151

      DELETE FROM chv_horizontal_schedules
      WHERE  schedule_id = p_schedule_id
      AND    schedule_item_id = x_schedule_item_id;

Line: 167

      DELETE from chv_authorizations
      WHERE  reference_id = x_schedule_item_id
      AND    reference_type = 'SCHEDULE_ITEMS';