69: l_plan_cmplt_date varchar2(100);
70: l_actual_cmplt_date varchar2(100);
71: l_batch_close_date varchar2(100)
72: ;
73: l_organization_code mtl_parameters.organization_code%TYPE;
74:
75: l_planned_qty gme_material_details.plan_qty%TYPE;
76: l_uom gme_material_details.dtl_um%TYPE;
77: l_actual_qty gme_material_details.plan_qty%TYPE;
161: and gbsi.batchstep_id = gbs.batchstep_id
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
218: and gbsi.material_detail_id = bl.material_detail_id
219: and go.oprn_id = gbs.oprn_id) batch_line
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,
284: and gbsi.material_detail_id = bl.material_detail_id
285: and go.oprn_id = gbs.oprn_id) batch_line
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,