APPS.INV_SERIAL_PICK_PKG dependencies on MTL_SYSTEM_ITEMS

Line 297: from mtl_system_items_kfv

293: END IF;
294: IF l_status_allowed <> 'Y' THEN
295: select concatenated_segments
296: into l_item_name
297: from mtl_system_items_kfv
298: where inventory_item_id = p_inventory_item_id
299: and organization_id = p_organization_id;
300:
301: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');

Line 373: FROM mtl_system_items msi

369: IF l_retain_ato_profile = 'Y' THEN
370: BEGIN
371: SELECT 1
372: INTO l_ato_item
373: FROM mtl_system_items msi
374: WHERE msi.inventory_item_id = p_inventory_item_id
375: AND msi.organization_id = p_organization_id
376: AND msi.replenish_to_order_flag ='Y'
377: AND msi.bom_item_type = 4;