APPS.INV_LABEL_PVT13 dependencies on GME_BATCH_HEADER

Line 64: l_batch_id gme_batch_header.batch_id%TYPE;

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

Line 65: l_batch_no gme_batch_header.batch_no%TYPE;

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

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

166: and gbsi.batchstep_id = gbs.batchstep_id
167: and gbsi.material_detail_id = bl.material_detail_id
168: and go.oprn_id = gbs.oprn_id) batch_line
169:
170: FROM gme_batch_header_vw bh, mtl_parameters mp, gme_material_details bl,
171: mtl_system_items_vl msi
172: where bh.batch_id = p_batch_id AND -- 121706
173: bl.organization_id = mp.organization_id AND
174: bh.batch_id = bl.batch_id AND

Line 229: FROM gme_batch_header_vw bh,

225: and gbsi.batchstep_id = gbs.batchstep_id
226: and gbsi.material_detail_id = bl.material_detail_id
227: and go.oprn_id = gbs.oprn_id) batch_line,
228: mmt.transfer_lpn_id
229: FROM gme_batch_header_vw bh,
230: mtl_parameters mp,
231: gme_material_details bl,
232: mtl_system_items_vl msi,
233: mtl_material_transactions mmt,

Line 296: FROM gme_batch_header_vw bh,

292: and gbsi.batchstep_id = gbs.batchstep_id
293: and gbsi.material_detail_id = bl.material_detail_id
294: and go.oprn_id = gbs.oprn_id) batch_line
295:
296: FROM gme_batch_header_vw bh,
297: mtl_parameters mp,
298: gme_material_details bl,
299: mtl_system_items_vl msi,
300: gme_pending_product_lots gppl,