APPS.INV_LABEL_PVT13 dependencies on GME_MATERIAL_DETAILS

Line 75: l_planned_qty gme_material_details.plan_qty%TYPE;

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;
78: l_material_detail_id gme_material_details.material_detail_id%TYPE;
79:

Line 76: l_uom gme_material_details.dtl_um%TYPE;

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;
78: l_material_detail_id gme_material_details.material_detail_id%TYPE;
79:
80: l_item mtl_system_items_vl.concatenated_segments%TYPE;

Line 77: l_actual_qty gme_material_details.plan_qty%TYPE;

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;
78: l_material_detail_id gme_material_details.material_detail_id%TYPE;
79:
80: l_item mtl_system_items_vl.concatenated_segments%TYPE;
81:

Line 78: l_material_detail_id gme_material_details.material_detail_id%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;
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;

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 223: gme_material_details bl,

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,
227: mtl_item_locations_kfv milk,

Line 289: gme_material_details bl,

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,
293: mtl_transaction_reasons mtr