DBA Data[Home] [Help]

APPS.INV_LABEL_PVT13 dependencies on MTL_SYSTEM_ITEMS_VL

Line 83: l_item mtl_system_items_vl.concatenated_segments%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;
86: l_lot_quantity NUMBER;
87: l_quantity2 NUMBER;

Line 171: mtl_system_items_vl msi

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
175: bl.line_type = 1 AND

Line 232: mtl_system_items_vl msi,

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

Line 299: mtl_system_items_vl msi,

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
303: