APPS.GMD_SPREAD_FETCH_PKG dependencies on GME_BATCH_STEPS

Line 51: gme_batch_steps d, gme_batch_step_items e

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 (+)
55: AND a.organization_id = c.organization_id (+)

Line 156: FROM gme_material_details a, mtl_system_items_b b, gme_batch_steps c,

152: SELECT a.*,b.description,b.lot_control_code,
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