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 1826: FROM mtl_system_items_vl msik --Bug 5302715 changed from kfv to vl

1822: , l_task_name task
1823: , l_subinventory_code subinventory_code
1824: , wilk.concatenated_segments LOCATOR
1825: -- milk.concatenated_segments LOCATOR -- Modified for bug # 5015415
1826: FROM mtl_system_items_vl msik --Bug 5302715 changed from kfv to vl
1827: , mtl_lot_numbers mln
1828: , mtl_material_statuses_vl mmsvl
1829: , po_hazard_classes poh
1830: , mtl_parameters mp