APPS.INV_LABEL_PVT1 dependencies on MTL_SYSTEM_ITEMS

Line 64: FROM mtl_system_items

60: l_uom_code VARCHAR2(3) := '';
61: BEGIN
62: SELECT SECONDARY_UOM_CODE
63: INTO l_uom_code
64: FROM mtl_system_items
65: WHERE organization_id = p_organization_id
66: AND inventory_item_id = p_inventory_item_id;
67:
68: IF SQL%NOTFOUND THEN

Line 1875: FROM mtl_system_items_vl msik --Bug 5302715 changed from kfv to vl

1871: , l_task_name task
1872: , l_subinventory_code subinventory_code
1873: , wilk.concatenated_segments LOCATOR
1874: -- milk.concatenated_segments LOCATOR -- Modified for bug # 5015415
1875: FROM mtl_system_items_vl msik --Bug 5302715 changed from kfv to vl
1876: , mtl_lot_numbers mln
1877: , mtl_material_statuses_vl mmsvl
1878: , po_hazard_classes poh
1879: , mtl_parameters mp