[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM GMD_VAL_RULE_GTMP;
INSERT INTO GMD_VAL_RULE_GTMP(
recipe_validity_rule_id, recipe_id , orgn_code , recipe_use ,
preference , start_date , end_date , min_qty ,
max_qty , std_qty , inv_min_qty , inv_max_qty ,
text_code , attribute_category , attribute1 , attribute2 ,
attribute3 , attribute4 , attribute5 , attribute6 ,
attribute7 , attribute8 , attribute9 , attribute10 ,
attribute11 , attribute12 , attribute13 , attribute14 ,
attribute15 , attribute16 , attribute17 , attribute18 ,
attribute19 , attribute20 , attribute21 , attribute22 ,
attribute23 , attribute24 , attribute25 , attribute26 ,
attribute27 , attribute28 , attribute29 , attribute30 ,
created_by , creation_date , last_updated_by , last_update_date ,
last_update_login , validity_rule_status , planned_process_loss , organization_id ,
inventory_item_id , revision , detail_uom , unit_cost ,
total_cost , delete_mark)
VALUES
(
x_recipe_validity_out(i).recipe_validity_rule_id, x_recipe_validity_out(i).recipe_id ,
x_recipe_validity_out(i).orgn_code , x_recipe_validity_out(i).recipe_use ,
x_recipe_validity_out(i).preference , x_recipe_validity_out(i).start_date ,
x_recipe_validity_out(i).end_date , x_recipe_validity_out(i).min_qty ,
x_recipe_validity_out(i).max_qty , x_recipe_validity_out(i).std_qty ,
x_recipe_validity_out(i).inv_min_qty , x_recipe_validity_out(i).inv_max_qty ,
x_recipe_validity_out(i).text_code , x_recipe_validity_out(i).attribute_category ,
x_recipe_validity_out(i).attribute1 , x_recipe_validity_out(i).attribute2 ,
x_recipe_validity_out(i).attribute3 , x_recipe_validity_out(i).attribute4 ,
x_recipe_validity_out(i).attribute5 , x_recipe_validity_out(i).attribute6 ,
x_recipe_validity_out(i).attribute7 , x_recipe_validity_out(i).attribute8 ,
x_recipe_validity_out(i).attribute9 , x_recipe_validity_out(i).attribute10 ,
x_recipe_validity_out(i).attribute11 , x_recipe_validity_out(i).attribute12 ,
x_recipe_validity_out(i).attribute13 , x_recipe_validity_out(i).attribute14 ,
x_recipe_validity_out(i).attribute15 , x_recipe_validity_out(i).attribute16 ,
x_recipe_validity_out(i).attribute17 , x_recipe_validity_out(i).attribute18 ,
x_recipe_validity_out(i).attribute19 , x_recipe_validity_out(i).attribute20 ,
x_recipe_validity_out(i).attribute21 , x_recipe_validity_out(i).attribute22 ,
x_recipe_validity_out(i).attribute23 , x_recipe_validity_out(i).attribute24 ,
x_recipe_validity_out(i).attribute25 , x_recipe_validity_out(i).attribute26 ,
x_recipe_validity_out(i).attribute27 , x_recipe_validity_out(i).attribute28 ,
x_recipe_validity_out(i).attribute29 , x_recipe_validity_out(i).attribute30 ,
x_recipe_validity_out(i).created_by , x_recipe_validity_out(i).creation_date ,
x_recipe_validity_out(i).last_updated_by , x_recipe_validity_out(i).last_update_date ,
x_recipe_validity_out(i).last_update_login , x_recipe_validity_out(i).validity_rule_status ,
x_recipe_validity_out(i).planned_process_loss , x_recipe_validity_out(i).organization_id ,
x_recipe_validity_out(i).inventory_item_id , x_recipe_validity_out(i).revision ,
x_recipe_validity_out(i).detail_uom , x_recipe_validity_out(i).unit_cost ,
x_recipe_validity_out(i).total_cost , 0);