[Home] [Help]
46: CURSOR Cur_get_spread IS
47: SELECT a.*,b.description,b.lot_control_code,b.secondary_default_ind,
48: b.grade_control_flag,b.location_control_code,b.tracking_quantity_ind,c.expiration_date expiry_date,
49: b.primary_uom_code primary, c.lot_number lot, d.batchstep_no
50: FROM lm_sprd_dtl a, mtl_system_items_b b, mtl_lot_numbers c,
51: gme_batch_steps d, gme_batch_step_items e
52: WHERE a.inventory_item_id = b.inventory_item_id
53: AND a.organization_id = b.organization_id
54: AND a.inventory_item_id = c.inventory_item_id (+)
1248: last_update_date = V_last_update_date,
1249: last_updated_by = l_user_id,
1250: text_code = V_text_code
1251: WHERE sprd_name = V_spread_name;
1252: DELETE FROM lm_sprd_dtl
1253: WHERE sprd_id = V_sprd_id;
1254: DELETE FROM lm_sprd_tec
1255: WHERE sprd_id = V_sprd_id;
1256: DELETE FROM lm_sprd_prm
1282: FOR l_rec IN Cur_sprd_insert LOOP
1283: OPEN Cur_line_id;
1284: FETCH Cur_line_id INTO X_line_id;
1285: CLOSE Cur_line_id;
1286: INSERT INTO lm_sprd_dtl (line_id,sprd_id,move_order_line_id,line_type,formulaline_id,material_detail_id,line_no,
1287: rollup_ind,inventory_item_id,qty,detail_uom,revision,revision_qty_control_code,text_code,subinventory_code,
1288: location,lot_number,expiration_date,grade_code,transaction_id,reservation_id,secondary_qty,secondary_uom,
1289: buffer_ind, plant_organization_id,organization_id,last_updated_by,last_update_date,
1290: created_by,creation_date,locator_id)