76: l_uom gme_material_details.dtl_um%TYPE;
77: l_actual_qty gme_material_details.plan_qty%TYPE;
78: l_material_detail_id gme_material_details.material_detail_id%TYPE;
79:
80: l_item mtl_system_items_vl.concatenated_segments%TYPE;
81:
82: l_quantity NUMBER;
83: l_lot_quantity NUMBER;
84: l_quantity2 NUMBER;
162: and gbsi.material_detail_id = bl.material_detail_id
163: and go.oprn_id = gbs.oprn_id) batch_line
164:
165: FROM gme_batch_header_vw bh, mtl_parameters mp, gme_material_details bl,
166: mtl_system_items_vl msi
167: where bh.batch_id = p_batch_id AND -- 121706
168: bl.organization_id = mp.organization_id AND
169: bh.batch_id = bl.batch_id AND
170: bl.line_type = 1 AND
220:
221: FROM gme_batch_header_vw bh,
222: mtl_parameters mp,
223: gme_material_details bl,
224: mtl_system_items_vl msi,
225: mtl_material_transactions mmt,
226: mtl_transaction_lot_numbers mtln,
227: mtl_item_locations_kfv milk,
228: mtl_transaction_reasons mtr,
286:
287: FROM gme_batch_header_vw bh,
288: mtl_parameters mp,
289: gme_material_details bl,
290: mtl_system_items_vl msi,
291: gme_pending_product_lots gppl,
292: po_hazard_classes hzc,
293: mtl_transaction_reasons mtr
294: