APPS.GMD_SPREAD_FETCH_PKG dependencies on GME_BATCH_HEADER

Line 157: gme_batch_step_items d, gme_batch_header e

153: b.grade_control_flag,b.tracking_quantity_ind,b.location_control_code,
154: b.default_grade,b.primary_uom_code primary,b.secondary_uom_code secondary,
155: c.batchstep_no,e.batch_status, b.revision_qty_control_code,b.secondary_default_ind
156: FROM gme_material_details a, mtl_system_items_b b, gme_batch_steps c,
157: gme_batch_step_items d, gme_batch_header e
158: WHERE a.inventory_item_id = b.inventory_item_id
159: AND b.organization_id = a.organization_id
160: AND a.batch_id = V_entity_id
161: AND e.batch_id = V_batch_id

Line 212: l_batch_row GME_BATCH_HEADER%ROWTYPE;

208: l_mat_count NUMBER;
209: l_rsc_count NUMBER;
210: l_user_id NUMBER;
211:
212: l_batch_row GME_BATCH_HEADER%ROWTYPE;
213: l_batch_rec Cur_get_batch%ROWTYPE;
214: l_control Cur_get_controls%ROWTYPE;
215: l_labrec Cur_get_lab_lots%ROWTYPE;
216:

Line 947: FROM gme_batch_header

943: WHERE line_id = Pline_id;
944:
945: CURSOR Cur_get_batch IS
946: SELECT *
947: FROM gme_batch_header
948: WHERE batch_id = V_entity_id;
949:
950: l_line_id NUMBER;
951: l_item_rec Cur_get_item%ROWTYPE;