eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT13 dependencies on GME_MATERIAL_DETAILS

Line 78: l_planned_qty gme_material_details.plan_qty%TYPE;

74: l_batch_close_date varchar2(100)
75: ;
76: l_organization_code mtl_parameters.organization_code%TYPE;
77:
78: l_planned_qty gme_material_details.plan_qty%TYPE;
79: l_uom gme_material_details.dtl_um%TYPE;
80: l_actual_qty gme_material_details.plan_qty%TYPE;
81: l_material_detail_id gme_material_details.material_detail_id%TYPE;
82:

Line 79: l_uom gme_material_details.dtl_um%TYPE;

75: ;
76: l_organization_code mtl_parameters.organization_code%TYPE;
77:
78: l_planned_qty gme_material_details.plan_qty%TYPE;
79: l_uom gme_material_details.dtl_um%TYPE;
80: l_actual_qty gme_material_details.plan_qty%TYPE;
81: l_material_detail_id gme_material_details.material_detail_id%TYPE;
82:
83: l_item mtl_system_items_vl.concatenated_segments%TYPE;

Line 80: l_actual_qty gme_material_details.plan_qty%TYPE;

76: l_organization_code mtl_parameters.organization_code%TYPE;
77:
78: l_planned_qty gme_material_details.plan_qty%TYPE;
79: l_uom gme_material_details.dtl_um%TYPE;
80: l_actual_qty gme_material_details.plan_qty%TYPE;
81: l_material_detail_id gme_material_details.material_detail_id%TYPE;
82:
83: l_item mtl_system_items_vl.concatenated_segments%TYPE;
84:

Line 81: l_material_detail_id gme_material_details.material_detail_id%TYPE;

77:
78: l_planned_qty gme_material_details.plan_qty%TYPE;
79: l_uom gme_material_details.dtl_um%TYPE;
80: l_actual_qty gme_material_details.plan_qty%TYPE;
81: l_material_detail_id gme_material_details.material_detail_id%TYPE;
82:
83: l_item mtl_system_items_vl.concatenated_segments%TYPE;
84:
85: l_quantity NUMBER;

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

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,
234: mtl_transaction_lot_numbers mtln,
235: mtl_item_locations_kfv milk,

Line 298: gme_material_details bl,

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,
301: po_hazard_classes hzc,
302: mtl_transaction_reasons mtr