APPS.CSP_VALIDATE_PUB dependencies on MTL_SERIAL_NUMBERS
Line 220: from mtl_serial_numbers
216: l_serial_control_code := 0; -- reset l_serial_control_code for reuse
217:
218: -- check whether the serial number resides in the store
219: select nvl(current_status, 1) into l_serial_status 220: from mtl_serial_numbers 221: where inventory_item_id = p_inventory_item_id
222: and serial_number = p_serial_number
223: and current_organization_id = p_organization_id;
224: