APPS.INV_LABEL_PVT13 dependencies on GME_BATCH_HEADER

Line 61: l_batch_id gme_batch_header.batch_id%TYPE;

57: l_label_status VARCHAR2(1);
58: l_label_err_msg VARCHAR2(1000);
59: l_is_epc_exist VARCHAR2(1) := 'N';
60:
61: l_batch_id gme_batch_header.batch_id%TYPE;
62: l_batch_no gme_batch_header.batch_no%TYPE;
63: l_formula_no fm_form_mst.formula_no%TYPE;
64: l_routing_no gmd_routings.routing_no%TYPE;
65: l_creation_date varchar2(100);

Line 62: l_batch_no gme_batch_header.batch_no%TYPE;

58: l_label_err_msg VARCHAR2(1000);
59: l_is_epc_exist VARCHAR2(1) := 'N';
60:
61: l_batch_id gme_batch_header.batch_id%TYPE;
62: l_batch_no gme_batch_header.batch_no%TYPE;
63: l_formula_no fm_form_mst.formula_no%TYPE;
64: l_routing_no gmd_routings.routing_no%TYPE;
65: l_creation_date varchar2(100);
66: l_plan_start_date varchar2(100);

Line 165: FROM gme_batch_header_vw bh, mtl_parameters mp, gme_material_details bl,

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

Line 221: FROM gme_batch_header_vw bh,

217: and gbsi.batchstep_id = gbs.batchstep_id
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,

Line 287: FROM gme_batch_header_vw bh,

283: and gbsi.batchstep_id = gbs.batchstep_id
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,