APPS.GMD_SPREAD_FETCH_PKG dependencies on GME_MATERIAL_DETAILS

Line 71: FROM gme_material_details

67: AND line_type <> 3 ;
68:
69: CURSOR Cur_get_batch_text(V_matldetlid IN NUMBER) IS
70: SELECT text_code
71: FROM gme_material_details
72: WHERE material_detail_id = V_matldetlid;
73:
74: CURSOR Cur_get_formula_text(V_formlineid IN NUMBER) IS
75: SELECT text_code

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

Line 712: FROM gme_material_details

708: AND line_no = 1;
709:
710: CURSOR Cur_get_material_prod IS
711: SELECT inventory_item_id
712: FROM gme_material_details
713: WHERE batch_id = V_entity_id
714: AND line_type = 1
715: AND line_no = 1;
716: