[Home] [Help]
48:
49: CURSOR Cur_lock_step_materials ( v_batchstep_id NUMBER,
50: v_batch_id NUMBER) IS
51: SELECT D.*
52: FROM gme_batch_step_items i, gme_material_details d
53: WHERE d.batch_id = v_batch_id AND
54: i.material_detail_id = d.material_detail_id AND
55: i.batchstep_id = v_batchstep_id AND
56: d.release_type = 3