[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 (+)
1282: last_update_date = V_last_update_date,
1283: last_updated_by = l_user_id,
1284: text_code = V_text_code
1285: WHERE sprd_name = V_spread_name;
1286: DELETE FROM lm_sprd_dtl
1287: WHERE sprd_id = V_sprd_id;
1288: DELETE FROM lm_sprd_tec
1289: WHERE sprd_id = V_sprd_id;
1290: DELETE FROM lm_sprd_prm
1316: FOR l_rec IN Cur_sprd_insert LOOP
1317: OPEN Cur_line_id;
1318: FETCH Cur_line_id INTO X_line_id;
1319: CLOSE Cur_line_id;
1320: INSERT INTO lm_sprd_dtl (line_id,sprd_id,move_order_line_id,line_type,formulaline_id,material_detail_id,line_no,
1321: rollup_ind,inventory_item_id,qty,detail_uom,revision,revision_qty_control_code,text_code,subinventory_code,
1322: location,lot_number,expiration_date,grade_code,transaction_id,reservation_id,secondary_qty,secondary_uom,
1323: buffer_ind, plant_organization_id,organization_id,tpformula_id, last_updated_by,last_update_date,--added tpformula_id for Bug#7254259
1324: created_by,creation_date,locator_id,prod_percent)