APPS.WMS_ITEM_LOAD dependencies on MTL_SYSTEM_ITEMS

Line 750: FROM mtl_system_items

746:
747: -- Get the item's primary uom code
748: SELECT primary_uom_code
749: INTO l_primary_uom_code
750: FROM mtl_system_items
751: WHERE inventory_item_id = p_inventory_item_id
752: AND organization_id = p_organization_id;
753: IF (l_debug = 1) THEN
754: print_debug('Item primary UOM code: ' || l_primary_uom_code);

Line 2711: FROM mtl_system_items

2707:
2708: -- Get the lot and serial number control code for the item
2709: SELECT serial_number_control_code, lot_control_code
2710: INTO l_serial_number_ctrl_code, l_lot_control_code
2711: FROM mtl_system_items
2712: WHERE inventory_item_id = l_inventory_item_id
2713: AND organization_id = p_organization_id;
2714: IF (l_debug = 1) THEN
2715: print_debug('Serial Number Code: ' || l_serial_number_ctrl_code);